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

Archives: August 2013

70-457 Reviewer #10 Managing SQL Server Agent

This review topic is part of Managing Data lesson which covers 20% of the certification exam. SQL Server Agent enables you to execute scheduled or event-driven administrative jobs, automating processes you would otherwise have to execute manually. Each SQL Server instance you setup has a separate SQL Server Agent. During…

Read more

0 comments, 1,192 reads

Posted in Coffee and SQL on 31 August 2013

Retiring of the MCM Certifications

The MCM is dead. Long live the MCM.

The small, exclusive club of SQL Server Microsoft Certified Masters is going to remain small and exclusive. This club, with less than 200 members world-wide, includes some of the biggest and brightest names in the SQL Server community. And Microsoft has decided… Read more

1 comments, 4,153 reads

Posted in A Discussion of SQL Server-Related Topics on 31 August 2013

Terminal #MCM – 30 days to go

We just finished the webshow last night, when one of our chatroom fellows – Nic Cain – told us that the MCM and MCA programs were dying. He almost immediately blogged the news: MS was canceling the Microsoft Certified Master and Microsoft Certified Architect programs, and it was all up…

Read more

6 comments, 1,179 reads

Posted in SQL Awesomesauce on 31 August 2013

How to find SQL Server Version,Edition,Server Name?

How to find sql server version,edition,Server Name?

SQL Server provides a System Defined function SERVERPROPERTY(propertyname) .

By using this function you can find a number of things

Property Name
Return SQL Server edition installed on machine.
select ServerProperty('edition')
return Edition ID
select ServerProperty('editionid')

Read more

0 comments, 22,824 reads

Posted in Querying Microsoft SQL Server on 31 August 2013

PASS Virtual Chapter Events : September 2013


Join SQL Server professionals from around the world for free online technical training and networking year round. PASS Virtual Chapters (VC) are interest-based forums that unite the SQL Server community through live webcasts with top SQL Server experts, online forums and resources – including an archive of past presentations,… Read more

0 comments, 1,435 reads

Posted in Marc Beacom on 31 August 2013

SSRS: Ignore Series Grouping in Chart

In SSRS, when you add a Series Group to a chart the data for each series is aggregated based on the series grouping specified. In some situations, you may have a series that you want aggregated differently than the series grouping. 

For example, you may want to display a series… Read more

1 comments, 11,158 reads

Posted in Salvo(z) SQL on 31 August 2013

PASS SQL Saturday Events : September 2013


PASS SQL Saturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. Please note that in order to attend one of these event, you must register (registration links are provided for each event). Please register soon as seating is limited, and let… Read more

0 comments, 1,486 reads

Posted in Marc Beacom on 31 August 2013

SQL in the City 2013 US Tour

It was a huge honor to be chosen for the 2013 US tour of SQL in the City. Red Gate put on a phenomenal tour in 2012 hitting 6 major cities. This year they are bringing the event back. This year will bring Red Gate to Pasadena on October 9th,… Read more

0 comments, 1,190 reads

Posted in Tim Radney - Database Professional on 30 August 2013

“Unraveling Tangled Code” recording and downloads!

Last weekend I gave my “Unraveling Tangled Code” talk at SQL Saturday Oklahoma, and they were kind enough to record and post the session over on UserGroup.TV!  You can get the slide deck and demo code here. This session stemmed from the recurring nightmare that is undocumented, unsupported code that…

Read more

0 comments, 1,107 reads

Posted in SQL Awesomesauce on 30 August 2013

Reblog: August 23 to August 29

I’ve always been a fan of the feeling when I find an old blog post that’s got just the information that I need to solve a problem or answer a question.  It’s that whole “cha-ching” – buried treasure! feeling.  That’s kind of the aim of this blog post.  To provide… Read more

0 comments, 1,360 reads

Posted in StrateSQL on 30 August 2013

Building a simple forecast solution on SQL Server

Pricing Forecast is a marketing function that requires a lot of data crunching. Normally there are some factors that the Marketing team wants to adjust to find out just the optimum pricing for their products. Accordingly, the forecast solution needs to be fairly flexible but still be powerful enough to…

Read more

9 comments, 1,507 reads

Posted in Terry's Business Intelligence on 30 August 2013

One for My SQL Sisters

Women, for the entire male half of the population, I apologize.

Those who know me well recognize, pretty easily, that I am hardly “politically correct.” My mode of address can be blunt and even rude. But… I think it’s also recognized that I’m very even-handed with my blunt statements. Female… Read more

10 comments, 1,780 reads

Posted in The Scary DBA on 30 August 2013

Professional Etiquette When Sending Mass Email – Use BCC:

<begin soap box rant>

Time and time again I find myself having to email people to remind them about how and when to use BCC when sending out correspondence to a huge group via email.

The main rule of thumb I tell the senders is that if dialog is not… Read more

0 comments, 1,338 reads

Posted in Tim Radney - Database Professional on 30 August 2013

Building a Better Litter Box

First, I know as I write this that my friend Kevin will be emailing me later today that I’ve jumped the shark again (is it possible to do it more than once?)! Still, it’s every bloggers right to inject a small amount of whimsy into what they write and I’m… Read more

0 comments, 1,423 reads

Posted in SQLAndy on 30 August 2013

Just Wow!! features

Over the years with each release I’m often impressed by some of the features contained in SQL server but every so often, I start to use a feature that I haven’t used before and I’m blown away by just how good that particular feature is. Sometimes it is the sheer…

Read more

0 comments, 1,307 reads

Posted in SQL Server Rocks! on 30 August 2013

Fixing a Bug: DBCC CHECKDB data purity checks are skipped for master and model

Fellow MVP Paul Randal just blogged about an issue he has discovered with how the master and model databases are created in SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, and SQL Server 2012. I just checked, and the same issue is present in SQL Server 2014 CTP1… Read more

1 comments, 1,606 reads

Posted in Glenn Berry's SQL Server Performance on 29 August 2013

Data Mining with Excel Q&A

Thank you to everyone who attended my free webinar on August 29, 2013 where I talked about using the Data Mining Add-in for Excel. If you were unable to attend you can find the recording here. You can also check out all the Pragmatic Works Free Training videos here Read more

0 comments, 2,641 reads

Posted in Bradley Schacht on 29 August 2013

Resume hoarders

Unfortunately in my line of work as a consultant, I am contacted far too often by resume hoarders, who are “recruiters” who sole job is to collect resumes, with no attempt at all to try to match the right person with the position that is open.  It’s just a matter… Read more

0 comments, 1,477 reads

Posted in James Serra's Blog on 29 August 2013

Windows Azure SQL Database and Throttling

When I present on Windows Azure SQL Database, one of the biggest concerns comes up around throttling. Just the concept that your queries might be shut down because they use too many resources tends to freak people out. I’m not sure why. I think we ought to have the same… Read more

0 comments, 1,522 reads

Posted in The Scary DBA on 29 August 2013

Before Asking for Help...

I have a standard rule that I use before going and bugging a co-worker or posting via social media/message forum about a technical question I might have. I invoke this rule except in cases where there's a production down or impaired situation and seconds count. Here's the rule:


Before I… Read more

Older posts