SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Archives: February 2010

Why Do My SQL 2008 Compressed Backups Shrink?


Recently a coworker was doing some research with SQL 2008 Backup Compression on a very large database. During the testing they noticed that the backup file shrunk rather than grew.

The Facts

The database that the test was being run on was 360GB in size. The backup initially created… Read more

0 comments, 381 reads

Posted in Adventures in SQL on 25 February 2010

Editorial - “Dude, Your Fly Is Open”

In case you don’t subscribe to the SQL Server Central daily newsletter, check out the editorial I wrote entitled “Dude, Your Fly Is Open”, a lighthearted look at when and how to point out the mistakes of others.  You can find it here: http://www.sqlservercentral.com/articles/Editorial/69482/. Read more

0 comments, 565 reads

Posted in Tim Mitchell on 25 February 2010

Renaming a Standalone Instance of SQL Server

I needed to upgrade the underlying IO subsystem of one of my IO intensive SQL Servers. After some discussion with various teams it was decided that the best way to achieve this whilst minimising disruption was to build a fresh server with a new name and a fresh SQL Server… Read more

5 comments, 1,935 reads

Posted in The SQL DBA in the UK on 25 February 2010

I’m Attending the South Florida Code Camp on February 27, 2010

I’m driving down tomorrow for the sixth annual South Florida Code Camp. This will be my third time attending and I’m doing two presentations this time, and as usually SQLShare is sponsoring the speaker event on Friday night. It’s a huge event, typically about 600 attendees, and well worth… Read more

0 comments, 481 reads

Posted in SQLAndy on 25 February 2010

Day 4 - Pragmatic Works Webinar Series

Hey gang !

I’m presenting today at 1pm on Zero to Cube in 60 minutes. We’re going to build an analysis Services Cube to and I’m going to show you how we can make it useful for reporting in short amount of time. We currently have over 800 folks for…

Read more

0 comments, 381 reads

Posted in Adam Jorgensen on 25 February 2010

The Journey from Smart to Good

“It’s easier to be smart than good.”

I heard that quote in a recent sermon at church and it is one I can very much relate to in more than one area of my life.  In context the pastor was discussing the difference between knowing what the Bible says (being… Read more

2 comments, 725 reads

Posted in Wise Man or Wise Guy on 25 February 2010

The Apples and Oranges of Training

SQL Server Training is out there in all sorts of formats, price points and quality. It's time to look at the quality part.

What makes TED Talks (www.ted.com) magic is the digestible format. You take an expert accustomed to talking to their colleagues and writing inpenetrable books -… Read more

0 comments, 878 reads

Posted in Bill Nicolich on 25 February 2010

Growing the Pool of SQL Speakers – Part 2

About a week ago I wrote Part 1, and got some interesting feedback (which I appreciate). Today I want to try to think about some of those comments and try to evolve the idea some. I want to defend my ideas a little, but not sink into defensiveness. I… Read more

3 comments, 832 reads

Posted in SQLAndy on 25 February 2010

Bruce Schneier – Geek of the Week

I used to subscribe to Bruce’s monthly Cryp-o-gram and enjoyed it. He’s moved to a blog format, and I think that the content suffers a bit as he pushes things out quicker, but he’s still a great read.

This week at Simple-Talk, he was the geek of the week for… Read more

0 comments, 688 reads

Posted in The Voice of the DBA on 25 February 2010


I just had the opportunity to spend some time with my four year old son at the doctor’s office.  It was a painful experience, for my son as well as myself – but for different reasons.  He was playing on the monkey bars, lost his grip and fell.  A natural… Read more

2 comments, 559 reads

Posted in SQL RNNR on 25 February 2010

Where Do You Look on the Internet for SQL Server Jobs?

I recently had a SQL Server DBA write to me that they were going to be laid off, and they asked me if I had any special insight into what are the best websites to look for SQL Server-related jobs. I haven’t looked for a SQL Server job in a… Read more

7 comments, 643 reads

Posted in SQL Aloha on 24 February 2010

New On SQLPASS.ORG – Dealing with Micromanagers

In my regular professional development column for the Professional Association for SQL Server (PASS), Plays Well With Others, check out my latest post on dealing with micromanagers.

Those TPS reports are due at 3:30 pm sharp, Mister!

If you’ve ever dealt with a manager who questioned your every move, hijacked… Read more

0 comments, 467 reads

Posted in Kevin E. Kline on 24 February 2010

Upcoming Speaking Event Schedule

I have a fairly busy schedule of upcoming speaking events (especially for someone with a full-time day job).

I will be giving my Dr. DMV: How to Use Dynamic Management Views to Monitor and Diagnose Performance Issues With High Volume OLTP Workloads presentation at the Rocky Mountain Tech Trifecta event… Read more

0 comments, 845 reads

Posted in Glenn Berry's SQL Server Performance on 24 February 2010

Brad McGehee is coming to SQL Lunch

Mr. Exceptional DBA is coming to our SQL Lunch. Patrick and I are excited to welcome Brad MCGehee to SQLLunch.com. "No Fluff Just Stuff " for a presentation on being an exceptional DBA. Brad is always a crowd pleaser so make sure you get on and check it out!  Read more

0 comments, 390 reads

Posted in Adam Jorgensen on 24 February 2010

I'm Presenting Tomorrow - Zero to Cube !

I’m presenting tomorrow on Zero to Cube in 60 minutes. This is an all Demo Session for work with cubes and putting data in a form that can be analyzed and reported on quickly and efficiently through SQL Server Analysis Services.  Come check it out at http://pragmaticworks.com/resources/webinars/February2010Webinar.aspx. Brian Knight… Read more

0 comments, 375 reads

Posted in Adam Jorgensen on 24 February 2010

Day 3 - Pragmatic Works Webinar Series

Hey Guys and Gals ! If you missed the webinars today, you missed a great show! Brian took us through the fundamentals of SSIS and getting started with this exciting product. SSIS is such a powerful tool, not just for ETL and data warehousing, but for environment management, workflow processing…

Read more

0 comments, 436 reads

Posted in Adam Jorgensen on 24 February 2010

Developing Your DBA Skills Further Thanks to Experience with Multiple RDBMS


Any DBA who really understands databases and SQL standards can make out with other RDBMSs quite well, and if they have not tried yet, I recommend it for the reasons I shall discuss below.

Specialists maintain, with reason, that you cannot be a Master/Mistress of multiple database management systems. Read more

5 comments, 2,817 reads

Posted in The Database Hive for SQL Server DBAs on 24 February 2010

Managing user data and response through 'drop boxes'

There are a few ways to get data from a client to your system; FTP or email.  Internally we tend to use email for two reasons: everyone has it and  it provides an audit trail (I know who sent what and when).  The corporate email standard is MS Outlook, which… Read more

0 comments, 574 reads

Posted in SQLRunner on 24 February 2010

Plan for Failure

Notice I didn't title this "Plan to Fail." We should never plan to fail. That's sabotage. And that ain't right, as we say in the South.

However, when we do our planning, it is an unrealistic expectation for everything to work every time, especially when it comes to IT. Our… Read more

Upcoming SQL Lunch Webinars

If you haven’t attended a SQLLunch, I suggest that you put this upcoming lunch on your schedule. Brad McGehee, SQL Server MVP, will be presenting an Introduction to Graphical Execution Plans. Brad has over 15 years of SQL Server Experience and over 6 years of training.

Add To Outlook: Add…

Read more

0 comments, 961 reads

Posted in SQLDownSouth on 24 February 2010

Newer posts

Older posts