Planning to upgrade/migrate requires a fair amount of prep work. Some of that prep work involves auditing your server for any users that may still be using the instance.
2019-08-09 (first published: 2019-07-17)
Quality data is a goal we all strive to attain. Nobody wants to have bad data. Yet, despite our best efforts, the problem of bad data has its way...
2019-08-05 (first published: 2019-07-11)
For the most part, things work the way you might expect them to work in windows - except it is on Linux. Sure some things are different, but SQL...
2019-07-29 (first published: 2019-07-10)
This article demonstrates how to use Extended Events to determine if a database is being used by someone or something.
Finding Deprecated Uses in SQL Server November 7, 2016...
2019-07-22 (first published: 2019-07-03)
There are multiple ways of retrieving data from a table when you have a list of values. This article explores the use of the table value constructor.
2019-07-18 (first published: 2019-07-02)
Data professionals around the globe are frequently finding themselves occupied with figuring out why and when a file (data or log) for a database has changed in size. Whether...
2019-07-10 (first published: 2019-06-25)
An important part of any DBAs job is to ensure database related jobs are running prim and proper. Sometimes that just doesn't happen. When jobs are being overlooked, it...
2019-07-04 (first published: 2019-06-20)
If you are being serious in your role, then the amount of times you grant permissions to the public role should either be a) never, b) when you want...
2019-07-01 (first published: 2019-06-17)