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

Archives: December 2011

Wishing you all a very Happy and Prosperous new year, may success comes to your doorstep
Image source : Top CNN News

Read more

Book review - SQL Server Secret Diary (Know the unknown secrets of SQL Server)

Like a lot of people within the SQL community, I can never read enough on the subject.  Books, whitepapers, academic research and blogs can all be valuable source of information, so whilst browsing Amazon I found this book on a free kindle download.  The preface makes some bold claims indeed… Read more

2 comments, 2,295 reads

Posted in Dave Ballantynes blog on 31 December 2011

Happy New Year

Image: ponsuwan / FreeDigitalPhotos.net

As 2011 draws to a close and as people look forward to evening of partying and celebrating I’d just like to wish everyone a very happy, healthy and prosperous New Year.

Read more

0 comments, 1,951 reads

Posted in The SQL DBA in the UK on 31 December 2011

SQLServerDBA News - 2011 Review for SQLServerDBA

2011 was a great year on a personal and professional level

1)       Completed the Brighton Marathon in 4hrs 36 secs

2)       Blogged on SQLServerDBA.com and DBA-DB2.com frequently

3)       More time spent on Database Architecture projects

4)       Read more books for recreation

5)       My favourite SQLServer-DBA.com posts this year were:

JOIN… Read more

0 comments, 1,555 reads

Posted in SQLServer-DBA on 31 December 2011

Good Bye 2011

Good Bye 2011

Hey there, this year is going to an end and just want to recall what all happened this year in my life both personally (cannot disclose much J) and professionally.

The good news about this year is on 24th Dec 2011, we blessed a second… Read more

0 comments, 1,286 reads

Posted in Vinay Thakur on 31 December 2011

Thoughts on SSSOLV December Meeting

This is very late – I know.  The meeting was held on December 8, 2011 and I haven’t yet shared my recap/thoughts about the meeting.

We hold the SQL Server Society of Las Vegas user group meeting on the second Thursday of every month.  We have decided to hold the… Read more

0 comments, 1,469 reads

Posted in SQL RNNR on 30 December 2011

Estimated Completion Time for Backups and Restores

I’m in the middle of a database migration and thought I’d quickly share a script I threw together to show estimated time of completion for a database restore in progress on SQL Server. The script will also show you estimated time for database backups to complete as well.

Please don’t… Read more

2 comments, 36,439 reads

Posted in SQL Chicken on 30 December 2011

SSIS Community Tasks and Components

Do you know there are hundreds of additional tasks, tools, and components for SSIS, many which are free?  Why re-invent the wheel?  Take a look at this exhaustive list created by Todd McDermid on CodePlex: SSIS Community Tasks and Components.  It is split into the following categories:

  • Tools
  • Connection…

Read more

0 comments, 3,078 reads

Posted in James Serra's Blog on 30 December 2011

Re-blog – December 23 – December 29

Welcome to the Friday Re-Blog summary post.  The aim of these posts is to bring some old posts that newer readers may not have had a chance to see.  Also a chance to bring back to the forefront posts that some may have seen but forgot about.

If you have… Read more

0 comments, 1,431 reads

Posted in StrateSQL on 30 December 2011

Increase SQL Server Error Log Files

Recently I learned that you can and probably should increase the number of SQL Server Error logs that your instance of SQL Server maintains.  This is real simple to change.  You can make the change via the GUI with a few simple steps or accomplish it with TSQL.

To make… Read more

5 comments, 3,814 reads

Posted in Tim Radney - Database Professional on 30 December 2011

January 2012 Las Vegas SQL UG

This month I am attempting to get a jump on things a bit.  I am hoping to get the info out in a more timely fashion throughout this new year for the User Group meetings for S3OLV.

Out with the old and in with the new.  Let’s ring in the… Read more

0 comments, 1,682 reads

Posted in SQL RNNR on 30 December 2011

January Midlands PASS meeting - Hosting Ed Wilson, the "Scripting Guy"

On January 10, 2012, Midlands PASS is pleased to welcome back PowerShell expert and teacher, Ed Wilson (blog | twitter), and his lovely wife Teresa.


Whether you haven't learned what PowerShell is yet or you're an expert yourself, you're sure to learn something from Ed as he… Read more

0 comments, 1,685 reads

Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 30 December 2011

RedGate SQL Index Manager BETA

I recently attended the first micro training event with Red Gate where Grant Fritchey demonstrated a BETA tool called SQL Index Manager.  This tool is aimed at the accidental DBA or for those like me who are just lazy. 

It is basically a nice GUI to return your index fragmentation… Read more

1 comments, 2,497 reads

Posted in Tim Radney - Database Professional on 29 December 2011

How Many Calls? Part 2

I wrote recently about a report that a friend of mine needed from his Access database. In the first post, I used a CTE and an outer join to cull together some data, however since I wasn’t sure Access would support any of that, I came up with another way. Read more

0 comments, 1,698 reads

Posted in The Voice of the DBA on 29 December 2011

SQL Saturday 99 – Confio Interview

Welcome to the seventh of a few sponsor interview posts from SQL Saturday 99.  After reading Arnie Rowland’s (Blog |@ArnieRowland) Paying For Free post, I thought it might be worthwhile to do a little bit more to interview our attendees and others to the sponsors… Read more

0 comments, 1,563 reads

Posted in StrateSQL on 29 December 2011

SQL Server A to Z – CPU-Z

How fitting that I should close out the A to Z series while I close out the year.  We’ve finally arrived at letter Z and that stands for the CPU-Z utility.  Yes, technically that isn’t a part of SQL Server, but if you hadn’t already noticed by Monday’s ‘Y’ post,… Read more

1 comments, 2,064 reads

Posted in Cleveland DBA on 29 December 2011

December Recap

The past few months I have been pretty busy.  December is no exception to that.  Between normal work, moonlighting as a general contractor on my own basement, and trying to keep up with my family – it almost seems like the month has barely even been a blink.

Other than… Read more

1 comments, 1,517 reads

Posted in SQL RNNR on 29 December 2011

Danish Developer Conference – DDC 2012

I am proud to announce that we at Geniiius will be speaking at DDC 2012. DDC 2012 is a one day event held in Horsens, Denmark on the 29th of February 2012. You can sign up for the conference by following this link.

DDC 2012 is all about… Read more

0 comments, 1,672 reads

Posted in SQL Server Notes from the Field on 29 December 2011

What is SQL Saturday?

I saw the following post from Andy Warren (blog | twitter), one of the creators of SQL Saturday. He was trying to explain what SQL Saturday was to a non-SQL person and found that while saying it's a free day of training is accurate but not complete. I… Read more

0 comments, 2,753 reads

Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 29 December 2011

Ready for the new year?

The New Year is just around the corner. Every year I make a resolution. And every time I fail. That is the story of my life. This year I want it to be different. I have more than one resolution for this year. I am sure I will be successful… Read more

2 comments, 2,268 reads

Posted in RumblingDBA on 29 December 2011

Older posts