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

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

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

Presenting at the Space Coast SQL Group on August 13, 2015

I’m heading to the coast on August 13, 2015 to talk about database corruption, SQLSaturday Orlando, and the possibility of...