Force installation of 64-bit ACE OLE DB provider

Anyone working with SSIS and Excel probably had the following issue: you are creating an SSIS package using an Excel...

SQL Lunch – GeoFlow: 3D Geospatial Visualization

Join me next month to learn about a new Geospatial visualization feature of Excel 2013 on the SQL Lunch.

Lunch Details

#75-GeoFlow:...

SQL PASS Performance Virtual Chapter Presentation

Today I was fortunate enough to be able to give a new presentation to the SQL PASSPerformance Virtual Chapter called...

SQLIntersection conference wrapup

Two weeks ago was a busy one. I helped coordinate and spoke at our second SQL Saturday Omaha on April...

Troubleshooting SQL Server Error 15517

Last week I had the following error message repeating over and over again in the SQL Server log of one of...

Building My HDInsight Server Cluster

After all the hype about Big Data, Hadoop, and now HDInsight, I decided to build out my own big data...

Discover, Diagnose, and Document ALL Your SQL Servers On Your Coffee Break

We all know that we should document our SQL Servers, right? RIGHT?
So let's say you had some time on...

DMV-8 : Check Space consumed by Database……..sys.dm_db_file_space_usage

sys.dm_db_file_space_usage DMV (Dynamic Management View), described by BOL as follows: http://msdn.microsoft.com/en-us/library/ms174412.aspx
Returns space usage information for each file in the database.
It’s...

Estimate Table Size based on the Metadata from INFORMATION_SCHEMA.COLUMNS

A problem I face often is not knowing the size of a new table that I’m creating. I put some...

How do I tell the stored procedure name from inside the stored procedure?

I’ve occasionally had the problem of trying to put “smart” logging messages into a process. You know the ones, you’re...