Port numbers and SQL Server

I made a mistake the other day. I’ll admit it. I was wrong. Now I know all of you are...

Power Query – Controlling M Query Functions with User Driven Parameters

Have you ever had a user run a query against one of your largest tables only for them to immediately...

Speaker of the Month: April 2015

One of my favorite events of the year is the SQL Saturday in Silicon Valley. They’ve had four of them...

Toggle Functionality Looses In excel--ssrs 2005

Hi Folks

Highlighting on the issue that I faced last week while working on reporting services 2005.

Requirement :- A data region (table)...

tSQLt with TRY..CATCH

Someone asked me the question recently about how tSQLt works with TRY..CATCH blocks and the exceptions that we might test...

Availability Groups - Where Did My Disks Go?

The TL;DR - beware of Failover Cluster Manager trying to steal your non-shared storage!
--At a client recently two availability groups on...

Can Log Shipping Work Without Shipping the Log?

When you configure log shipping, there are 4 SQL Server Agent jobs that are set up:
Backup: Performs a backup log...

Connect the Nots

Today I learned that you can’t adjust the font size in SQL Server Management Studio’s Object Explorer pane. Nor registered...

Generating tSQLt tests from a dacpac

UPDATE I went and built this into my add-in for SSDT, more details https://the.agilesql.club/blog/Ed-Elliott/2015-11-17/Create-Stub-tSQLt-t… and https://the.agilesql.club/Projects/SSDT-Dev-Pack
Generating tSQLt tests from a dacpac I use SSDT and tSQLt in my work...

Generating tSQLt tests from a dacpac

Generating tSQLt tests from a dacpac
I use SSDT and tSQLt in my work and I am always interested in productivity...