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

Archives: December 2011

SQL Server A to Z – YEAR


Welcome to the penultimate installment of SQL Server A to Z (it’s not often I get to use “penultimate”). Officially, Y stands for Year, but that would be kinda boring, and quite short, so let’s run with it and talk about all sorts of date-parts-related… Read more

0 comments, 2,206 reads

Posted in Cleveland DBA on 26 December 2011

Twas The Week After Christmas....

Holiday Greetings to all you DBA's and SQL Server professionals! This blog goes out to all of you who are on-call this week, or in the office, keeping SQL Servers safe from the grinches.  Hope you enjoy!


Twas the week after Christmas, when all through the office;
Not a client… Read more

3 comments, 2,084 reads

Posted in Pearl Knows on 26 December 2011

Modifying SQL Server Synonyms – this time with Powershell

So, how do you recover from the Holidays? Hot Cocoa by the fire? Relaxing evening with your spouse watching an easily predictable romantic-comedy? Snuggling up with SMO synonym class documentation?
I chose the SMO documentation. After I wrote the last blog post (http://sqldbamusings.blogspot.com/2011/12/modifying-sql-server-synonyms.html), I was saddened. I did…

Read more

1 comments, 1,424 reads

Posted in Kyle Neier on 26 December 2011

SQL Server – How to identify service pack installed

Identifying current service pack installed for SQL Server can be difficult if you don’t know which command to use! Most of the time I have seen people using @@VERSION to check for SQL Server service pack level, which is not correct as it returns the service pack level of operation… Read more

9 comments, 2,680 reads

Posted in SQL and Me on 25 December 2011

SQL Server 2012 RC0 and beyond

Since the stable and mainly feature-complete versions of SQL Server 2012 have been available, I have been heads-down on multiple BI projects using this software.  SQL Server 2012 is not just the next, incremental build of the same database platforms with a few added features here and there.  No, SQL… Read more

5 comments, 708 reads

Posted in SQL Server BI Blog on 25 December 2011

SQL Server 2012 (“Denali”): New Security Features

SQL Server 2012 has many new security features, and three of the bigger new features are: Default Schema for Windows Groups, Audit enhancements, and User-Defined Server Roles.

Default Schema for Windows Groups

A database schema can now be tied to a Windows Group rather than an individual user in order… Read more

1 comments, 1,878 reads

Posted in James Serra's Blog on 23 December 2011

Re-blog – December 16 – December 22

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, 491 reads

Posted in StrateSQL on 23 December 2011

SQL Saturday #104: Colorado Springs

January 8th, 2012 will be the first SQL Saturday for 2012. 104 SQL Saturdays is an amazing number for our community. I will be presenting on Dimensional Modeling based on the Kimball books. Database design and the planning for them has been a necessary start for successful projects.

I… Read more

3 comments, 705 reads

Posted in The Smiling DBA on 23 December 2011

Basics QA on Extended Event

Basics QA on Extended Event



I am learning Extended Event so this is my first blog on extended event, There is a great whitepaper on XEvent by Jonathan Kehayias.

Q1. What is extended event?

A1. It is a light weighted profiler kind of trace introduced on sql… Read more

0 comments, 1,576 reads

Posted in Vinay Thakur on 23 December 2011

SQL Server Sample Databases – All Versions

Many of you DBAs DB Devs and BI Devs in these days can have some changes from one SQL Server version to another (SQL Server 2012RC0 / 2008 R2 / 2008 / 2005) and when you trying some scripts that you can find here in SSC articles or anywhere else,… Read more

0 comments, 1,379 reads

Posted in Dukagjin Maloku - Dugi'DBA on 23 December 2011

Tis The Season to be Giving...#SQLFamily

Indeed the Holiday Season is traditionally a season of giving, and being charitable to those who are less fortunate.  Although giving back should be all year-round, the end of the year, coupled with the holiday spirit, (and maybe last minute tax-deductions :-) always rouses folks to be generous.  Nonetheless, giving back is… Read more

0 comments, 1,610 reads

Posted in Pearl Knows on 23 December 2011

Data Driven Subscription failed with timeout error

One fine day, one of our data driven subscription which was running fine, failed with timeout error.

library!WindowsService_118!eb4!12/20/2011-07:30:01:: i INFO: Handling data-driven subscription 1b850434-fe69-47e5-a227-219d1b2e040c to report /External Reports/Report1, owner: domain\user, delivery extension: Report Server Email.
library!WindowsService_118!1288!12/20/2011-07:30:01:: i INFO: Initializing EnableExecutionLogging to ‘True’ as specified in Server system properties.
library!WindowsService_118!1288!12/20/2011-07:30:01:: i… Read more

1 comments, 1,133 reads

Posted in What I Learnt @ Work on 23 December 2011

2011 What A Great Year

What A Diffrince A Year Makes

In January I posted up my new years list basically, stuff I wanted to learn in the last twelve months. Lets take a quick look at last years goals.

SQL Server Stuff

1. Partitioning
Done, and pretty early on. I did a lot… Read more

0 comments, 979 reads

Posted in SQL Man of Mystery on 22 December 2011

How many calls – A T-SQL Question

I got a call from a friend recently that was looking for some query help. He was actually using Access, which I haven’t used in years. He knew a little T-SQL, so he could convert anything I gave him to work with his database.

Here was his issue. He had… Read more

6 comments, 1,215 reads

Posted in The Voice of the DBA on 22 December 2011

The #Meme15 Round-Up

The first round of #meme15 has finished.  In total, there were eighteen people that participated.  If there were more, I missed them, just leave a comment here and I’ll update this post.  We even managed to nab a couple non-SQL people in the first go round.  Maybe next time we’ll… Read more

0 comments, 763 reads

Posted in StrateSQL on 22 December 2011

A SQL Server Christmas Card

Merry Christmas everyone!

DECLARE @hohoho char(100)
DECLARE @bells smallint
DECLARE @tiers smallint
DECLARE @maxtiers smallint

SELECT @hohoho = ' ', @tiers = 1, @bells = 1, @maxtiers = 6
PRINT @hohoho

WHILE @tiers < @maxtiers
	SELECT @bells = POWER(@tiers,2), @hohoho = ' '
	WHILE @bells < 12*@tiers

Read more

1 comments, 724 reads

Posted in Cleveland DBA on 22 December 2011

PASS Summit 2011 Eval Results

My presentation on Professional Development Plans ended up being ranked 47th out of 190, with an overall score of 4.63. The range is 1-5 with 5 being good, but it’s also a game of inches. If my score had been 4.5 I would have dropped to 90th place. Solidly in… Read more

0 comments, 602 reads

Posted in SQLAndy on 22 December 2011

SQL Server Sample Databases - All Versions

Many of you DBAs DB Devs and BI Devs in these days can have some changes from one SQL Server version to another (SQL Server 2012RC0 / 2008 R2 / 2008 / 2005) and when you trying some scripts that you can find here in SSC articles or anywhere else,… Read more

0 comments, 1,194 reads

Posted in Dukagjin Maloku - Dugi'DBA on 22 December 2011

Filtering in SSMS

Do you spend seconds, maybe even minutes trying to find things in SSMS?  Ever find yourself scrolling up and down thrown the tree trying to find that one specific object you seek?

Did you know it doesn’t have to be that way?  Microsoft has provided us the tools to help… Read more

1 comments, 1,828 reads

Posted in SQL RNNR on 21 December 2011

Newer posts

Older posts