dbachecks – Going parallel – Cut off your execution times

On one of the last clients I have worked, I have implemented dbachecks in order to get the state of...

Gather Always On Configuration using a DMV query

If you were like me, you would know your AG configuration by heart. However, what if you get busy with...

Check health and status of Availability Group using DMVs

-- Health and status of WSFC cluster. These two queries work only if the WSFC has quorumSELECT*FROMsys.dm_hadr_clusterSELECT*FROMsys.dm_hadr_cluster_members

-- Health of the AGsSELECT...

Securing Test and Dev Environments at the SQL Privacy Summit

Redgate Software is putting on a one day SQL Privacy  Summit on May 18 in London at the Grange Tower...

SQL Server 2016 – SQL Server Telemetry \ CEIP Services

CEIP (Customer Experience Improvement Program) is somethings runs from ages and almost each vendor perform it to collect product usage...

SQL Saturday Wheeling 2018

Third time in a month, I will be presenting Machine Learning Server, this time at SQL Saturday Wheeling

SQL Server Nested Transactions Probably Don't Work How You Think

SQL Server allows you to nest multiple transactions but the results of doing so are completely not obvious.
Take the following...

Webinars, and Azure, and SQL… OH MY!

Hello everybody!  Thank you once again for stopping by and reading.  April has been pretty busy with presentations, and I...

Quick tip: format source code in html

I run a technical blog, so it is necessary to put code in almost every post. Most of the GUIs...

Dates and Times in SQL Server: T-SQL functions to get the current date and time

We have come on quite a journey so far. SQL Server and Azure SQL Database provide date and time data...