SQL Vulnerability Assessment for Azure SQL Database

Back in September 2017 Microsoft announced a new security feature for Azure SQL Database called the SQL Vulnerability Assessment (VA)....

Stop Previewing the bim.layout File in SSAS Tabular

A quick blog post for future reference, because I know I’ll bump into this again someday.
When you’re working with a...

Recruitment Agents are not bad people...despite what you might read

Welcome to WIN at IT contracting: A FREE guide showing YOU How to get the most out of Recruitment Agent...

Webinar: Identify and Eliminate SQL Server Performance Issues

I’m giving a webinar tomorrow, March 22, 2018, at 3 PM Eastern.
Free Registration Link
Here’s what I’ll be covering:
Are you struggling...

Dates and Times in SQL Server: DATETIME2

This post continues our look at date and time data types in SQL Server. SQL Server 2008 introduced new data...

Working with tabs and spaces in SSMS (Day 34)

There are several different options available for working with tabs and spaces in SSMS. In fact, there are enough that...

TempDB Filling Up On Secondary Replicas

Have you ever had an issue where TempDB was filling up on your secondary replicas?  Do those secondaries happen to...

SQL Server Data Management Life Cycle

This is the second article in the “Backup and Restore (or Recovery) in SQL Server” stairway series (see the full...

Moving a table using BCP and native format

You need to move a table from one instance to another with the following requirements:
The instances are on separate domains....

PowerShell script repository - SQL Server

A simple get-help output
PowerShell is a .Net based command line tool designed for automation.

It is recommended to script repetitive task...