Drop down boxes not working in SQL Server 2012 Configuration Manager

After a data centre power outage a decision was made to switch the start up mode of a bunch of...

PASSMN Presentation Follow-Up: Strategies for SQL Server Index Analysis

This past Tuesday, I got a chance to speak at the Minnesota SQL Server User Group.  It was a great...

T-SQL Tuesday #67 – Extended Events for DBCC

It’s the second Tuesday of the month and time for another T-SQL Tuesday. This time it’s #67 from Jes Borland...

Bulk Copy Program (BCP)–A simple way to export data in a file TIP#101

 
Let’s consider a scenario where the end user require a CSV file of all the records in a table then...

Extended Events, Birkenstocks and SQL Server

I bring you yet another installment in the monthly meme called T-SQL Tuesday.  This is the 67th edition, and this...

Notes from the June 17, 2015 MagicPASS Meeting

Notes:
Kendal has been doing an exam push focused on 70-461. A couple passed so far, a couple more tried and...

PASS Excel BI VC presents Ásgeir Gunnarsson: End to End Risk Assessment – Using PowerView

Join us today at noon central for Asgeir presenting for the Excel BI VC.

Thu, Jun 18 2015 12:00 Central Daylight...

Rebuilding Existing Partitioned Tables to a New Partition Scheme

[read this post on Mr. Fox SQL blog]
Continuing on with my Partitioning post series, this is part 4.
The partitioning includes several major...

Speaking at 24 Hours of PASS: Growing Our Community

24 Hours of PASS is just around the corner, and I’m happy to say that this time I’ll be speaking...

Thursday Morning SQL Break – June 15, 2015

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