Yup, @StrateSQL’s Running for the PASS Board of Directors

Why I’m Running Over the past few years, I’ve been considering running for the PASS Board of Directors and this year appears to be the right year to do this....

Yup, @StrateSQL’s Running for the PASS Board of Directors

Why I’m Running
Over the past few years, I’ve been considering running for the PASS Board of Directors and this year appears...

Detaching corrupt databases

Question – Can you detach a corrupt database? Answer – IT DEPENDS! More specifically it depends on the SQL Server version. SQL...

Future DBA – Big Data -MongoDB 2

In our earlier blog we discussed an introduction to MongoDB. so, how is MongoDB is into BigData, MongoDB has a...

My SQL Prompt GitHub Repo

Last year I published an article on SQLServerCentral from Guarab Vohra on using SQL Prompt with a VCS. I really...

Off Again

It’s another week of travel for me, starting early this morning. This is another crazy trip, and yes, I did...

Power BI Custom Visuals Class (Module 19 – Chiclet Slicer)

In this module you will learn how to use the Chiclet Slicer Power BI Custom Visual.  The Chiclet Slicer is...

PowerShell, Pester and Ola Hallengrens Maintenance Solution

If you are a SQL DBA you will have heard of Ola Hallengrens Maintenance solution If you haven’t go and...

Restore through FULL backup

Problem

A common misconception that i've heard a few times around backups is that a FULL backup invalidates previous TRANSACTION LOG...

SQL 2016 SSMS memory leak?

Has SSMS (SQL Server Management Studio) been crashing on you? Have you been getting Out of Memory messages when attempting...