Archives: December 2011
Top CNN News
0 comments, 0 reads
Posted in SQL Server Citation - SQL Blog by Hemantgiri S. Goswami, SQL MVP on 31 December 2011
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
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.
2011 was a great year on a personal and professional level
1) Completed the Brighton Marathon in 4hrs 36 secs
3) More time spent on Database Architecture projects
4) Read more books for recreation
5) My favourite SQLServer-DBA.com posts this year were:
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
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
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
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:
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
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
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
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,177 reads
Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 30 December 2011
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
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
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
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
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
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
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, 1,966 reads
Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 29 December 2011
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