Shrink transaction log file

Sometimes the shrink transaction log file doesn't work.

Before we troubleshoot it, we need to know how the log file works:
Transaction...

Simple batch script to generate XMLA and deploy SSAS DB

Reblogged from Data on Wheels - Steve Hughes: As I was working through some issues with my cube design, I realized...

Storage options available in Windows for SQL Server

There are several options available for configuring your storage media in Windows Server 2003 and Windows Server 2008. By understanding...

One week after #sqlsat132

It has been nearly one week since SQL Saturday 132 in Pensacola Florida.  I was chosen to give my talk...

Find unused indexes using sys.dm_db_index_usage_stats

The SQL Server maintains all indexes defined against a table regardless of their usage. Index maintenance can cause significant amounts...

TechEd North America 2012 videos online

Microsoft has posted ALL the session videos for TechEd North America 2012 and they are available for free!  What a...

Slacking Off: The Right Side of the Brain

I think it’s only fitting to follow up a post about performance reviews and self-evaluations with a post about slacking...

Connection Pooling :At a Glance

What is a Connection Pool?
A connection pool is a group of database connections (with same connection properties) maintained in the...

PASS Data Architecture VC presents Neil Hambly–Improve Data Quality & Integrity using Constraint

Tuesday’s (June 19th, 2012) PASS Data Architecture Virtual Chapter has Neil talks about database design that uses Constraints for Integrity...

Running for the #SQLPass #NomCom

Guess, what?  I’ve thrown my hat in to the elections for the Nomination Committee for PASS.  That means that I...