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...

Updating PowerPivot model and PowerView report with PowerShell

Before I start describing a problem that my PowerShell script helps to resolve, these are a few blog posts of...

Execution Plans in Extended Events

Extended Events is a wonderful tool. Execution Plans are also some wonderful things – or are a wonderful tool as well. Both of these tools are fantastic for troubleshooting. Combined,...

Execution Plans in Extended Events

Extended Events is a wonderful tool. Execution Plans are also some wonderful things – or are a wonderful tool as well. Both...