Webinar Today at 3pm

I’m taking on a new topic today. Titled “ How to capture who did what in your SQL Server databases”, it’s...

:CONNECT in SSMS

Those people who are familiar with SQLCMD will recognize this command. It is used to connect to an instance from...

Upcoming Webinar – Creating Power Map Reporting Solutions

Come join me for this webinar on 4/17/2014 at 11:00 AM EST

Creating Power Map Reporting Solutions
Excel 2013 with Office 365...

Upcoming Webinar – Bringing Power BI Q&A to your Organization

Come join me for this webinar on 4/15/2014 at 11:00 AM EST

Bringing Power BI Q&A to your Organization
Q&A is an...

Whats This Command Bar ?

One of the challenges I faced while creating my TSQL Smells visual studio (SSDT) add in, was trying to find out...

Quick tip: Querying AD with xp_logininfo

We all have blind spots in our knowledge. We don’t know they are there and when we are thinking through...

Tables without Clustered Indexes?

Today, we experienced performance issues with some of the SSRS reports that were deployed as part of the latest application/database...

Smart Moves with SQL Server VMs – VM Proximity

Today I am starting a new series of short posts designed to help SQL Server administrators with virtualized SQL Servers...

Setting Up Tabular Models on Windows Azure

In my last post, I discussed how to set up Oracle in Windows Azure. During a customer call, there were...

A summary of the SQL Server security #datachat is live

Recently I posted about participating in a #datachat about SQL Server security. As it turned out, we didn’t talk about...