SQL Server

Recommended reading from mrdenny for April 05, 2013

This week I've found some great things for you to read. These are a few of my favorites that I've found this week.

• Celebrating a Tremendous Year for...

How Many SQL Server ERRORLOG Files Do I Keep?

When working with SQL Servers there are lots of settings that people like to tweak to make their SQL Server run smoother.  One setting that I really like tweaking is the number of ERRORLOG files that are kept.  By default SQL Server keeps the last 6 ERRORLOG files around deleting the last one...

Recommended reading from mrdenny for March 29, 2013

This week I've found some great things for you to read. These are a few of my favorites that I've found this week.

• How To Return Document Property Values in...

Using Event Viewer Logging for SSIS Performance Trouble Shooting

So while working with a client recently I was going some performance tuning on SSIS for them.  While SSIS isn't exactly my normal workload, the problem wasn't really in SSIS, but just normal SQL Statements being called from SSIS. While attacking this problem, the first thing that I did was look...

Recommended reading from mrdenny for March 22, 2013

This week I've found some great things for you to read. These are a few of my favorites that I've found this week.

• Navigating Microsoft’s employment...

Keeping Your Speaking Commitments

Many event organizers are way too polite to publicly admit that this problem exists as badly as it does.  But a problem has been showing up way to much recently.  The problem which I speak of is session speakers not showing up for their sessions, and the even bigger problem of speakers not...

Recommended reading from mrdenny for March 15, 2013

This week I've found some great things for you to read. These are a few of my favorites that I've found this week.

• VMware vCloud Transfer spooling area is not...

Deleting LOB Data and Shrinking the Database

While attending SQL Saturday 194 in Exeter over in England one of the attendees came to Mladen Prajdić, Andre Kamman and myself with an interesting problem.  She had a database table which was about 200 Gigs in size which she wanted to...

Recommended reading from mrdenny for March 08, 2013

This week I've found some great things for you to read. These are a few of my favorites that I've found this week.

• Why should you bother with the PASS BA...

Recommended reading from mrdenny for March 01, 2013

This week I've found some great things for you to read. These are a few of my favorites that I've found this week.

• Big Data Analytics with Hive, Windows &...