Administration

Discovering Symantec NetBackup

Discovering Symantec NetBackup

I have worked with a large organization (150,000+ employees). This organization has a central location and hundreds of subordinate sites. Headquarters (HQ) has dictated that the Symantec NetBackup MS SQL Client will be used for all SQL Server backups. Each site has…

Trace flags every DBA should know about

I have compiled a list of trace flags which I recommend enabling by default on all of you SQL Server instances and ones which are simply, useful. Check out the page and bookmark it for reference as I will be…

Do not use percentage based auto-growth

Do not use percentage based auto-growth

Having autogrowth enabled on your SQL Server instance is great! Even in IT shops where you diligently right-size your database files (which is a good idea), autogrowth is the perfect emergency feature. It will increase the size of your files, as needed, until…

Fast, light-weight, row counts

Fast, light-weight, row counts

Often we need to know the number of records in a table. If you are looking for something very specific, such as the number of non-NULL values in a particular column, learn how to use COUNT() correctly with this post…

Synchronizing Server Objects for Availability Groups

Synchronizing Server Objects for Availability Groups

Updated: 9/8/2017 In addition to the release based method demonstrated below. I created a SQL Agent job based method using dbatools here. This method was created in response to a lot of feedback from DBAs like you. Original After we…

Row Level Security in SQL Server 2016 CTP2

Row Level Security in SQL Server 2016 CTP2

Earlier this year Microsoft Azure implemented Row-Level Security (Brent’s announcement). In following Microsoft’s cloud-first release concept, this great feature is now part of SQL Server 2016 CTP2, and expected to be included in the RTM version. When I first saw…

QS-Config v2.0 Enters Open Beta: Major Refactoring

QS-Config v2.0 has passed closed beta and is now entering open beta. Feature changes / additions: Supports PowerShell v2.0 and higher. Supports SQL Server 2014. One script for all supported versions of SQL Server, rather than a script per version….

Multiple Server Management – Finding the Database Server

Multiple Server Management – Finding the Database Server

Often database administrators must ask themselves a simple, yet tedious question, “what server is that database on,” or maybe, “how many servers do we still have on SQL Server 2005?” This article will cover how to use SQL Server’s Central…