Advent of Code Contest

I saw the post from Steve Jones about the Advent of Code contest and decided to take a look. The first...

Monday Morning SQL Break – December 28, 2015

It’s Monday and time for this week’s blog and twitter round-up for last week. If you haven’t already, follow me...

One More PASS Board Update for 2015

Remember that post I wrote about taking on SQLSaturday events as my new PASS portfolio?

Never mind.*
Instead, it seems I’ll be...

Speaker of the Month: December 2015

The hardest presentations I’ve ever given in my life were not to large audiences or in big rooms. They weren’t...

Can we get a license for DDL Triggers?

There are several types of triggers.
Logon triggers – Fired when someone tries to connect to the instance.DML triggers – Fired after...

New Whitepaper – SQL Server Licensing Reduction

Poor storage performance continues to be the largest pain point with enterprise Database Administrators in today’s virtual world. However, it...

Quick Tip: Why Can’t I Pin an Excel Range to a Power BI Dashboard?

So two new exciting capabilities were announced recently in Power BI.  One involved Excel and the other SSRS, but they...

SET ANSI_NULLS, NOCOUNT and QUOTED_IDENTIFIER.

Hi Guys, When you generate a script to create a Stored Procedure, below three statements are generate by default. SET ANSI_NULLS on SET NOCOUNT on SET QUOTED_IDENTIFIER on Why do we...

What Permissions Does This Login Have?

I recently was tasked with this ticket:
Please add new login Domain\Bob to server MyServer.  Grant the login the same permissions...

Cannot Open the Properties of a 2014 Availability Group in SSMS 2016 CTP 3

I ran across a bug in SSMS 2016 CTP 2 back in August.  If you try to right click and...