SQL Server

SQL Server Community

SQL Server Blogs

Follow /23 Sep 2014 at 9:39pm / SQL Server

Tuesday Tips: Answering the What and When of Baselines

In recent months we’ve posted about baselines, including our homage to Derek Jeter as he nears playing in final professional game – Read it here . Expect more on the topic coming soon. Why? Quite simply, as a DBA you can’t truly understand...
25 0 /
Follow /23 Sep 2014 at 8:51pm / SQL Server

Using the new Qlik Sense Desktop

To all of my regular readers, I apologize for the lack of activity on this blog the last few months. With moving, new jobs, and and a new city I haven’t quite found the time to be doing writing, but hopefully now as things quiet down I can get back into...
21 0 /
Kendal Van Dyke
Follow /23 Sep 2014 at 7:15pm / SQL Server

PASS Chapter Leaders - Remember To Talk About Elections With Your Chapters!

Last week before our monthly MagicPASS meeting I went through my usual routine of grabbing the PASS chapter deck and noticed that there are no slides mentioning the upcoming Board of Directors elections. I'm surprised because the elections are a great...
19 0 /
Melissa Coates
Follow /23 Sep 2014 at 2:16pm / SQL Server

Third Annual SQL Saturday BI Edition in Charlotte

The third annual SQL Saturday, BI Edition , is back in Charlotte! It's coming up next weekend, on Saturday, October 4th. SQL Saturday is a free* training event for Database and Business Intelligence professionals...
26 0 /
Follow /23 Sep 2014 at 10:34am / SQL Server

Compressing Open Row Groups

If you’re using, or at least read up on Clustered Columnstore Indexes then you’ll know that the data is stored in segments. You’ll also know that there are 4 states the segments can be in at any one time: OPEN CLOSED INVISIBLE...
33 0 /
David Dye
Follow /23 Sep 2014 at 8:00am / SQL Server

All About SSIS Variables Part 1

Variables have been available in SSIS since first introduced in 2005. So what exactly are they for and what can you do with variables? Glad you asked!! Variables can be used for a number of different purposes: 1. Define the path of a package 2. Hold...
18 0 /
Follow /22 Sep 2014 at 4:17pm / SQL Server

Cumulative Updates – SQL Server 2012 SP1 CU12

As part of their Incremental Service Modelling , Microsoft have released SQL Server 2012 Service Pack 1 Cumulative Update #12. To apply this cumulative update package, you must be running SQL Server 2012 SP1. So it is pertinent for versions 11.0.3000...
33 0 /
David Dye
Follow /22 Sep 2014 at 3:22pm / SQL Server

#SQLSat340 Materials

I want to thank the  attendees, organizers and speakers at SQL Saturday #340 San Diego.  This was an awesome event and it is always well worth the travel to attend such a great event. My presentation materials have been uploaded to the SQL Saturday...
38 0 /
Shaun Stuart
Follow /22 Sep 2014 at 2:00pm / SQL Server

SYS.DM_EXEC_REQUESTS Changes Between Versions Of SQL Server

I was recently doing some work with a backup verification routine that is meant to run on various versions of SQL Server and came across some variations in the way the RESTORE VERIFYONLY command is reported by sys.dm_exec_requests between SQL Server 2005...
39 0 /
Kenneth Fisher
Follow /22 Sep 2014 at 1:00pm / SQL Server

Changing configuration settings with sp_configure

I was recently asked where to go in Configuration Manager to change the settings for xp_cmdshell. It was then that I realized that the existence of sp_configure is probably not universal knowledge. I was truly shocked. For some reason I had thought that...
37 0 /
Chris Webb
Follow /22 Sep 2014 at 11:06am / SQL Server

Why I Support The PASS Name Change And Its Efforts To Expand Into The BA Community

Unless you take a close interest in the politics of PASS you may have missed the kerfuffle around it changing its name from the “Professional Association of SQL Server” to just PASS a month or so ago. Blog posts from Andy Warren and R. Brian Kelley seem...
57 0 /
Rohit Garg
Follow /22 Sep 2014 at 10:03am / SQL Server

SQL Server Cluster LooksAlive and IsAlive Check

Windows Cluster Service use the “heartbeat” process to check whether each node is alive at both the OS level and SQL Server level. Heartbeat signals works on UDP. Microsoft Windows Cluster service perform 2 health checks to perform node...
34 0 /
Nakul Vachhrajani
Follow /22 Sep 2014 at 4:30am / SQL Server

#0347 – SQL Server – Basics – A SELECT that does not fetch anything also does not SET anything

In today’s post, I go all the way back to the basics because of a logical bug I saw in production code recently. It is always said to be a good practice to initialize variables within procedures so that you know what the default value is and what are...
46 0 /
Chris Shaw
Follow /19 Sep 2014 at 7:57pm / SQL Server

Avoid Technology Debt

Can you afford to miss this free training class? See the end of this post on how to sign up. Have you ever been in a situation where you are working on implementing a SQL Server based solution and you need to make a decision about the technology that...
70 0 /
Jason Strate
Follow /19 Sep 2014 at 5:00pm / SQL Server

Reblog: September 12 to September 18

Photo credit – Jenn and Tony Bot Sometimes old stuff is just as cool as new stuff. Over the past few years, I’ve written a few things that are worth a revisit from time to time. In this post, you’ll find a list of previous year’s...
51 0 /