• Home
  • About
  • Blog
  • Speaking
  • Contact

Tag: SQL SERVER

Home Posts Tagged "SQL SERVER"

Index maintenance on a VLDB: How to tame the beast!

5 July 2016SQL StijnNo CommentsCOLUMNSTATISTICS, Index Maintenance, INDEX REBUILD, SQL SERVER, VLDB

When working with large data volumes, doing normal day to day maintenance becomes a more difficult issue, in a previous post (https://swyssql.wordpress.com/2015/08/06/dbcc-how-to-check-the-uncheckable-dbcc-on-vldb/) I talked about how to handle DBCC CheckDB on a multi-terabyte database. Today I will tackle another issue I came across while dealing with multi-terabyte databases, Index Maintenance. Like most of you my…

Distributed Availability Groups: Availability groupception!

4 July 2016SQL StijnNo CommentsAVAILABILITY GROUP, DISTRIBUTED AVAILABILITY GROUPS, HIGH AVAILABILITY, SQL SERVER, SQL SERVER 2016

On the all new SQL Server 2016 we now have a feature which reminds me of the movie Inception with Leo DiCaprio & Tom Hardy. There you had the dreams in dreams in dreams, for the availability groups we now have AG in AG. This makes the Distributed Availbility groups a dream come true for…

Query Store: Here is the bacon!

14 March 2016SQL StijnNo CommentsBACON, Micros, QUERY STORE, SQL, SQL SERVER, SQL SERVER 2016

Whenever I go to a burger restaurant & I want to order myself a nice and tasty burger. The first thing I do is look at the menu and ask myself the question: “Where is the bacon?”. I did the same thing while looking at the menu of the new up and coming SQL Server…

Migration Gone Wrong! The Fallback Scenario

23 February 2016SQL StijnNo CommentsCONSOLIDATION, DOWNGRADE VERSION, FALLBACK, MICROSOFT, MIGRATION, ROLLBACK, SQL SERVER, SQL SERVER 2000, SQL SERVER 2005, SQL Server 2012, SQL SERVER CONSOLIDATION

Today I’ll be handling an issue I had with the migration of a SQL Server 2000 database to SQL Server 2012. About a week ago we migrated the database from the old and grumpy, and more importantly unsupported windows server 2003 and SQL Server 2005 instance. All was well, and we had no instant issues…

THE SQL SERVER MISCONFIGURATION CHRONICLES: PART 3 Database Files

24 December 2015SQL StijnNo CommentsDatabase, DataFiles, Initial File Initialization, Log File, SQL, SQL SERVER, T-SQL, Virtual Log File, VLF

In the previous part of the SQL Server Misconfiguration Chronicles we handled the default instance memory configuration (https://swyssql.wordpress.com/2015/12/17/the-sql-server-misconfiguration-chronicles-part-2-instance-memory-settings/) In the third part of the misconfiguration we will handle the database files. If you create a database SQL Server will look at your model database and create the file structure as specified in your model database….

THE SQL SERVER MISCONFIGURATION CHRONICLES: PART 2 Instance Memory Settings

17 December 2015SQL StijnNo CommentsDefault memory, MaxMemory, Memory, Misconfiguration, SQL, SQL Script, SQL SERVER, T-SQL

In the first part of the SQL Server Misconfiguration Chronicles we handled the database level issue of AutoClose & AutoShrink (https://swyssql.wordpress.com/2015/12/08/the-sql-server-misconfiguration-chronicles-part-1-database-autoclose-autoshrink/) The second part of the misconfiguration chronicles will handle the default memory settings of a freshly installed SQL Server instance. SQL Server by default configures the instance memory settings to take a maximum memory…

The SQL Server Misconfiguration Chronicles: Part 1 Database AutoClose & AutoShrink

8 December 2015SQL StijnNo CommentsAutoClose, AutoShrink, Database, Databases, Script, SQL SERVER, SQL Server 2008, SQL Server 2012, SQL Server 2014, SQL Server Database, SQL Server Misconfiguration, SQL Server Script

In the SQL Server Consulting world you see a lot of different environments, but mostly you see the same basic misconfigurations for their SQL Server Enviroment. The following blogposts will show you the most common issues with the configuration of SQL Server, they will tell you what the issue is, why it is a bad…

TEMPDB: The Ghost of VersionStore

30 October 2015SQL StijnNo CommentsDBA, SQL SERVER, T-SQL, TEMPDB, TRANSACTIONS, UNCOMMITTED TRANSACTIONS, VERSION STORE, VERSIONSTORE

Close to the 30th of October we find that some SQL Servers start acting spooky, as if they want to add to the sentiment of Halloween. This week I had one SQL Server doing exactly that. The server was running without any problems for the past months but today his TempdDB was starting to fill…

Openrowset across the CMS: The Proxy Way of Life

20 March 2015SQL StijnNo CommentsCMS, MICROSOFT, Openrowset, Proxy, SQL SERVER, TSQL

Today I came across an issue I was having with my CMS. On my CMS server I have a database which has a few tables with some detail about my server state (Memory/Diskspace/…). I wrote a few stored procs to gather this data with openrowset in combination with the serverlist that I get from the…

The inevitable: Migrating ACCESS 2007 to SQL Server 2014

18 March 2015SQL StijnNo CommentsAccess database, SQL SERVER

There comes a time in every SQL Server dba’s life when he will have to consolidate a MS Access database to a SQL server, it is inevitable and destiny decided that it was my time today.An overly used Access database which had almost grown beyond its capacity was the one who decided my fate today,…

Posts navigation

1 2 >

Recent Posts

  • Building a Modern Lakehouse Data Warehouse with Azure Synapse Analytics: Moving your Database to the lake
  • Azure Synapse Dedicated SQL Pools: Workload Management
  • Synapse Spark – Playing with Data Frames with Python
  • Synapse Spark – Reading CSV files from Azure Data Lake Storage Gen 2 with Synapse Spark using Python
  • Azure Synapse Analytics – Serverless SQL Pools: Data Elimination

Recent Comments

    Archives

    • June 2022
    • December 2021
    • May 2021
    • April 2021
    • March 2021
    • February 2021
    • January 2021
    • December 2020
    • August 2016
    • July 2016
    • March 2016
    • February 2016
    • December 2015
    • October 2015
    • August 2015
    • March 2015
    • December 2014
    • November 2014
    • July 2014
    • February 2014
    • January 2014
    • December 2013

    Categories

    • Azure Synapse Analytics
    • Building a Modern Lakehouse Data Warehouse
    • Geen categorie
    • MS PDW
    • SQL 2016
    • SQL Maintenance
    • SQL Server Migration
    • SQL Server Misconfiguration Chronicles
    • SQL2014
    • Troubleshooting

    Contact Stijn now


    © SQL Stijn 2017 - Privacy Policy - Cookie Policy
    Manage Cookie Consent
    To provide the best experiences, we use technologies like cookies to store and/or access device information.
    Functional Always active
    The technical storage or access is strictly necessary for the legitimate purpose of enabling the use of a specific service explicitly requested by the subscriber or user, or for the sole purpose of carrying out the transmission of a communication over an electronic communications network.
    Preferences
    The technical storage or access is necessary for the legitimate purpose of storing preferences that are not requested by the subscriber or user.
    Statistics
    The technical storage or access that is used exclusively for statistical purposes. The technical storage or access that is used exclusively for anonymous statistical purposes. Without a subpoena, voluntary compliance on the part of your Internet Service Provider, or additional records from a third party, information stored or retrieved for this purpose alone cannot usually be used to identify you.
    Marketing
    The technical storage or access is required to create user profiles to send advertising, or to track the user on a website or across several websites for similar marketing purposes.
    Manage options Manage services Manage vendors Read more about these purposes
    View preferences
    {title} {title} {title}