Editorial – Dealing with Ugly Babies
One thing I learned while working as a database administrator over 17 years is the importance of teamwork across departments....
2019-02-27
240 reads
SQLEspresso
Azure Key Vault Logging
Following up from last week’s post on Azure Key Vault in this blog I will show you how to the...
2019-02-20
223 reads
Speaking Internationally at SQLBits
I am very excited and lucky to be speaking at my very first international conference, SQLBits. SQLBits, the largest SQL...
2019-02-13
181 reads
What is Azure Key Vault?
Keys and secrets (AKA passwords) are an essential part of data protection management not only on-premises, but within the cloud...
2019-02-06
243 reads
Azure Advisor
Azure offers a lot of value-added services included with the price of what you pay . One of the things really,...
2019-01-30
273 reads
Scheduling things to Run in SQL Server
A key part of the SQL Server Agent is the ability to schedule jobs. While you can create one schedule...
2019-02-08 (first published: 2019-01-23)
2,739 reads
Approximate COUNT DISTINCT
We all have written queries that use COUNT DISTINCT to get the unique number of non-NULL values from a table....
2019-01-15 (first published: 2019-01-03)
2,456 reads
Static Data Masking (SSMS 18.0 Preview)
Ever need to have a test database on hand that you can allow others to query “real like” data without...
2019-01-02 (first published: 2018-12-19)
2,682 reads
SQL Server Vulnerability Assessment
SQL Server Vulnerability Assessment (VA) in SQL Server Management Studio 17.4 or later lets SQL Server scan your databases for...
2018-12-12
315 reads
SQL Data Discovery and Classification in SSMS 17.5
Data exploration and documentation can be cumbersome, classifying data can be one of those tedious but necessary things. With the...
2018-12-05
925 reads
Blogs
The fundamental requirements of a reporting system
By ChrisJenkins
There are some fundamental boxes that your reporting system must tick. ✅ The figures...
Seeing the Bigger Picture: How A Monitoring Tool Changed My Approach to Estate Management
By Chris Yates
When it comes to managing complex database environments, having the right monitoring solution is...
A New Word: Foilsick
By Steve Jones
foilsick – adj. feeling ashamed after revealing a little too much of yourself to...
Forums
Create an HTML Report on the Status of SQL Server Agent Jobs
Comments posted to this topic are about the item Create an HTML Report on...
The Last Good DBCC Run
Comments posted to this topic are about the item The Last Good DBCC Run
count the number of NULLs in a row
Hi everyone I have a SP that finds the average based on 3 tables. ...
Question of the Day
The Last Good DBCC Run
I want to check when DBCC CHECKDB was last run on my Baseball database. What code should I use?
See possible answers