Designing a Data Warehouse from the Ground Up Webinar Recording with Q & A

 Thank you to everyone that registered and attended my webinar Designing your Data Warehouse from the Ground Up webinar this...

Your Devs' Questions Answered With sys.dm_server_services

It starts with "I'm a developer...

"... with no RDP access, how can I tell if the SQL Server Agent service...

ISNULL around the predicate and SARGability

You may have heard of the word, SARGable. In brief, it’s a term derived from the phrase, Search ARGument able,...

Importing Power Pivot & Power View into Power BI

The Power BI August update just rolled out today (8/20/2015) and in the latest update there’s a lot of cool,...

Changing Cell Phones Again

Slightly off topic, but since I use a cell phone so much for data transfer and work, it’s important that...

Reblog: How I prepared myself for the MCSE certification

SQLKover update: this was one of the most popular posts on my old blog. It’s quite old now and SQL...

Remember Nepal - Lead by Example

Below is the original article in its entirety, that was published on the Americas MVP Community Facebook page, on July...

Creating an SQL Databases – New Portal

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...

Tables, Columns and Defaults Oh My!

The joys of inheriting a new database and being thrown into the fire to quickly assimilate as much information about the database as possible can be troublesome. This script...

Tables, Columns and Defaults Oh My!

Picture this if you could. You inherit a new database either through the change of a job, or finding a...