Archives: August 2013
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
How to find sql server version,edition,Server Name?
Return SQL Server edition installed on machine.
return Edition ID
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
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
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
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
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
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
<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
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
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…
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
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
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
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
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
0 comments, 1,002 reads
Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 29 August 2013