Using the Sequence Object to Generate Reference Numbers

The SEQUENCE object was added to T-SQL in SQL Server 2012. It’s reasonably well known to DBAs, but less so...

Data Warehouse Design and Power BI at SQL Saturday Tampa 2019

Hello, fellow data nerds! I wanted to make you aware of a fantastic event coming up this month in Tampa,...

dbatools

Requests or Suggestions

...

Debugging Type Binding in PowerShell

Some effort I spent in researching Type Binding in Stack Overflow to help answer a question by Chris Oldwood helped me solidify my understanding of the best way to...

Enter our Database #DevOps Contest

Share your story and you could win. Enter as often as you like before Mar 20.
https://www.red-gate.com/hub/entrypage/competition

How to resolve ‘Login failed for user’ and sa password lost (Error 18456)

This blog post explains how to get into SQL Server if you have lost your sa password or you have...

Last Week Reading (2019-03-10)

Databricks-Connect – FINALLY! Do write your code in VS Code and run it remotely on Azure Databricks cluster. Automatically validate E-mail...

Missing Indexes in the Query Store

I’ve shown before how to use the DMVs that read the plan cache as a way to connect the missing indexes suggestions with specific queries, but the other place...

My latest presentations

I frequently present at user groups, and always try to create a brand new presentation to keep things interesting.  We...

My latest presentations

I frequently present at user groups, and always try to create a brand new presentation to keep things interesting.  We all know technology changes so quickly so there is...