Copying a TDE database from one instance to another

I got my first real world experience with a TDE (transparent data encryption) database recently. For those who don’t know...

Reading Extended Event File Session Data

Using Extended Events to trap/trace information allows the trapping of that information to various targets. One of the targets I will frequently tell people to use is the file target....

Reading Extended Event File Session Data

Using Extended Events to trap/trace information allows the trapping of that information to various targets. One of the targets I will...

A myth about view TIP #102

 
I don’t know why every interviewer’s favorite question “Can we insert record using View ?” If you say Yes/No the interviewer...

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

008 – Wayne Sheffield – MCM - WaterOx Consulting

Reading Time: 2 minutesMeet the SQL Master! In WOxPod!, episode # 008 – “Wayne Sheffield...
The post 008 – Wayne Sheffield – MCM appeared first...

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

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

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