T-SQL Tuesday #112 - The Cookie Jar

This month’s T-SQL Tuesday comes from Shane O’Neill (blog | twitter). He starts us off with this:
Dipping into the Cookie Jar is about when the going gets tough and...

T-SQL Tuesday Sharing Cookies

It has been a while since I have participated in a T-SQL Tuesday but I felt the urge to do...

Using Kubernetes Deployments for Updating SQL Server

In Kubernetes we can leverage Controllers to help manage our application state, keeping them in the desired state. In this blog post, we’re going to look at how to...

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...