SQL Server

SQL Server Community

SQL Server Blogs

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...
2 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...
21 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...
16 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...
23 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...
53 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...
33 0 /
Jen McCown
Follow /19 Sep 2014 at 2:42pm / SQL Server

Wendy Pastrick and Grant Fritchey: Optimists in Action #passvotes

If I had a favorite kind of politician, it would be the kind that, when asked a question, sighs tiredly, and then regains their gleam of manic optimism as they begin to speak about the path ahead. Given that, my two favorite politicians right now are...
53 0 /
Jorge Segarra
Follow /19 Sep 2014 at 2:30pm / SQL Server

EPM Framework v4 Released!

The Enterprise Policy Management Framework (EPMF) team is proud to announce the updated release of “Enterprise Policy Management Framework 4.0 for project EPMFramework. This is a major release with lots of performance tweaks and The EPM Framework...
32 0 /
Tracy McKibben
Follow /19 Sep 2014 at 1:00pm / SQL Server

Friday Followup For September 19, 2014

It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re not doing any real work anyway. Posts That Were Popular This Week Don’t Get Slimed By Bad Parameter Sniffing...
98 0 /
Chris Webb
Follow /18 Sep 2014 at 9:17pm / SQL Server

Handling Data Source Errors In Power Query

Recently I was asked an interesting question by Ondra Plánička in the comments of a blog post : how can you handle errors caused by unavailable or missing data sources in Power Query? Let’s imagine you are loading a csv file like this one into Excel...
40 0 /
Follow /18 Sep 2014 at 3:58pm / SQL Server

Tips for First-Timers Attending PASS Summit 2014

Are you attending PASS Summit 2014 ? If this is your first year at the conference and you’re not sure what to expect, then you are in luck! We are taking the stress and hard work out of conference prep with a simple snap shot of what you need to...
49 0 /
Follow /18 Sep 2014 at 3:45pm / SQL Server

Video: Walk & Talk #002 – RTO

Recovery Time Objective (RTO) What is it and why does it matter? I am actually walking this time! Join me to walk & talk through what the RTO (Recovery Time Objective) is with regards to SQL Server. Location: American Chestnut Land Trust –...
55 0 /
David Dye
Follow /18 Sep 2014 at 2:35pm / SQL Server


A common question is what is the difference between truncating a table and deleting a table.  The short answer is that they both do the same thing, but in different ways.  So consider that you have a table that contains 1,000,000 rows and you need to...
51 0 /
Chris Yates
Follow /18 Sep 2014 at 1:17pm / SQL Server

Passwords – A T-SQL Tuesday Topic

Being engrossed with the daily tasks at hand I completely missed this month’s T-SQL Tuesday is being brought to you by Sebastian Meine Blog | Twitter . Although the time frame has passed I would be amiss if I didn’t continue on my journey...
39 0 /
Larry Leonard
Follow /17 Sep 2014 at 7:08pm / SQL Server

CMS: List All Jobs that Do Not Notify on Failure

Using CMS , we can get a list of all the Jobs on all the servers that have no email (nor page, nor netsend) notification set up for Failure. This can be useful to find Jobs that are silently failing, and even Jobs that are no longer in use. -- Find Jobs...
72 0 /