Category Archives: Configuration

Requesting a SQL Configuration Change Requires Evidence

Part of a DBA’s job is making sure everyone is comfortable with proposed changes. I recently created a Change Request to increase the SQL setting Cost Threshold for Parallelism. Here is the justification I provided to get sign-off from the responsible … Continue reading

Posted in Configuration, DBA | Leave a comment

Great post on Compression Options

We are in the process of implementing Columnstore Indexes. I came across this page while researching and shared it with the DBA Team. http://aboutsqlserver.com/tag/clustered-columnstore-indexes/

Posted in Configuration, DBA, SQL | Leave a comment

SQL 2014, BIDS and SQL Server Data Tools

With SQL 2014 the tools used by developers are not part of the installation media and in fact SSMS is not even necessary for some. Be prepared to discuss with the development group what are the options before any SQL installations take place … Continue reading

Posted in Configuration, DBA, Leadership | Leave a comment

Renaming a Cluster Resource

We recently moved the server room from in house to a data center. While power, air, security and seismic capabilities were good reasons, it had to happen because the entire company is moving out of the building! Anyway, while the VMs … Continue reading

Posted in Configuration | Leave a comment

Using SQL To Configure Database Mirroring

We use database mirroring for replicating data from physical sql servers to the disaster recovery location; SRM is used for virtual machines. I don’t like the point and click interface though. So many screens for a pretty simple series of … Continue reading

Posted in Configuration, DBA, SQL | Leave a comment

Updating Statistics

Statistics and sql server. When people ask me what are statistics I answer with a Google maps analogy: while we know the roads are there, the traffic changes and, therefore, in the same way we know it is best to patiently … Continue reading

Posted in Configuration, DBA, SQL | 2 Comments

Making use of the model Database

All the websites and books talk about how the model database is what all future databases are based on, including tempdb, so add important stuff there. In my experience, there is not a great need to have the same function … Continue reading

Posted in Configuration | Leave a comment

Execute As

We all want to have our databases not owned by an individual. Especially the model database. We can run alter authorization on database::<<db name>> to sa after the fact, but why make a problem? An easy way to avoid this … Continue reading

Posted in Configuration, DBA, SQL | Leave a comment

Making SSMS Work for You

I love taking advantage of the customizable keyboard shortcuts in SSMS. You can put in stored procedures to be run when you press certain key combinations. For example, I have sp_helptext run when I press CTRL+5 and an expanded version … Continue reading

Posted in Configuration, DBA | Leave a comment

Changing The Port Used By SQL Server

We need to change the port sql server uses from the default to… something else. Towards that end I want to make aliases on all the end user computers and other sql servers so they can still connect without problems. … Continue reading

Posted in Configuration, DBA | Leave a comment