Using Configuration Files in SSIS

Now in SQL 2012 we have parameters that make it easy, but configuration files are still an option and I...

Wishing You a Very Happy Holi

Happy Holi

Holi is the time to unwind de-stress and bond with sweets,Thandai and colours.Come let’s rejuvenate by immersing ourselves in the...

Verify a success of database backups

One of the most important tasks on a DBA’s to-do list is backing up databases on a regular basis. This...

PASS SQLSaturday Events: April 2014

PASS SQL Saturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. Please...

When Good BI Goes Bad – Data Quality

Regardless of the Technology BI is about Data
Many BI projects are sold as a technology solution.  Vendors come in a...

Friday Followup For March 14, 2014

It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re...

Introduction to Power BI Recording and Q&A

I hope you were able to attend my free webinar on Understanding Microsoft Self-Service BI on March 13, 2014. If...

Reblog: March 7 to March 13

Photo credit – Travis
Ever go digging through your backyard for dinosaur bones? Maybe not, but it’s worthwhile from time to time...

SQL for Everybody

I read a terribly excited blog this morning by a guy who had just discovered Alt-F1 in SSMS. (If you don’t...