Dynamic SQL and the joys of QUOTENAME

I’m a big fan of dynamic SQL. In the past I’ve written a How to, a Best Practices and even...

Find the number of rows for a value, without querying the table

Dear all,

Being a DBA, developers approach me with questions like can you run this query for me in production?

Select*FROM[dbo].[FactInternetSales]
WHERE UnitPrice...

SQL Server Wait Types Library – UPGRADED!

Have you heard of SQLskills? Have you heard of the waits library? If not then where have you been hiding?...

PASS Summit Call for Speakers

Yesterday was the first day to submit sessions for the PASS Summit 2017 in Seattle on Oct 30th thru Nov...

MySQL and Backups As A Service

With today’s announcement that MySQL is available as a Platform as a Service (PaaS) offering through Azure, a lot more...

SQL Server Management Studio v17.0

Version numbers are confusing. SQL Server Management Studio (SSMS), the client user interface by which most DBAs access SQL Server,...

Using DBCC Clonedatabase

I haven’t messed with the new DBCC CloneDatabase option in SQL Server 2014/12016 (depending on patches), but recently I saw...

Installation of SQL Server vNext CTP on Linux Distribution CentOS 7

It was a paradigm shift in December 2016, when Microsoft made their SQL Server database available for Linux; it was...

Copying files from/to a container

Last week I was having an issue with a SQL install within a container and to fix I needed to...

My Session about SQL Server Parameterization

 
Last month I presented a session in the wonderful GroupBy online conference about SQL Server parameterization. The title of the...