SQL Homework – March 2018 – Recovery Objectives

My very first SQL Homework post was about taking a backup. The vast majority of people who work with databases...

Error 33206 - SQL Server Audit Failed to Create the Audit File

One of the joys of working with SQL Server is the descriptive and meaningful error messages, right?

https://vignette.wikia.nocookie.net/batmantheanimatedseries/images/a/a7/DiD_39_-_Joker_Vision.jpg/revision/latest?cb=20160610021326
Exhibit A - the 33206:
Error:...

Four Ways to Find Free Space In SQL Server Database

Determine Free Space In SQL Server DatabaseIn our previous section we have discussed about Using Stored Procedures in SQL Server For Better Performance and know various advantages of using...

Four Ways to Find Free Space In SQL Server Database

Determine Free Space In SQL Server Database
In our previous section we have discussed about Using Stored Procedures in SQL Server...

The Hidden Price Of Foreign Keys

Foreign key constraints put the “relation” into relational databases. They enforce integrity by requiring that a key value referencing another...

Calculating DTU's for Azure SQL Database

One of my clients asked to calculate the DTU’s required for an existing database before migrating to Azure SQL Database. Pricing Azure SQL Database is different from traditional SQL...

Calculating DTU's for Azure SQL Database

One of my clients asked to calculate the DTU’s required for an existing database before migrating to Azure SQL Database....

Configure Read only routing for an always on availability group

One of my friend sent an email with the requirement to load balance the traffic coming from application to secondary SQL Server replicas in always on availability group. Read-only...

Configure Read only routing for an always on availability group

One of my friend sent an email with the requirement to load balance the traffic coming from application to secondary...

SQL Saturday 723, March 24, 2018 in Rochester, NY. Join us and kick your SQL Server knowledge up a notch!

If you are a SQL Server professional and are interested in spending a day with a bunch of other like-minded...