Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in

Latest Blog Posts

The Mentoring Experiment – Closing Thoughts

Andy wrote a post today called The End of the Mentoring Experiment, which is something we’ve talked about for some time. In fitting with the decision, and perhaps justifying it further, we decided to do this a few months back, but as with many things, we haven’t gotten to… Read more

0 comments, 79 reads

Posted in The Voice of the DBA on 22 September 2014

Grant for President

Grant Fritchey is running for the PASS board. He’s not running for President, though I’m not sure why he shouldn’t be able to. The board makes decisions as a group and the President isn’t necessarily more or less powerful than other members. However the President can be the face… Read more

0 comments, 78 reads

Posted in The Voice of the DBA on 22 September 2014

Communication and the Board: #PASSVotes

The whole idea behind PASS is to build a community of people who can assist each other in their daily work lives. PASS succeeds at that wonderfully. Further, PASS, the organization, tries extremely hard to let you know what it’s doing and how it’s doing things. You can read the… Read more

0 comments, 43 reads

Posted in The Scary DBA on 22 September 2014

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 DBA’s were born with this knowledge. As… Read more

0 comments, 51 reads

Posted in SQLStudies on 22 September 2014

Resolving SSDT-BI Installation with IsVisualStudio2012ProInstalled() error

Recently I was building a new virtual machine for presentations, and loaded up my usual battery – Windows 7, SQL Server 2012, and SSDT-BI.  The installation of these pieces went as expected, and everything appeared to work well – until I attempted to execute an SSIS package on this new… Read more

1 comments, 46 reads

Posted in Tim Mitchell on 22 September 2014

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 & resource availability check.

LooksAlive Health Check

1) LooksAlive is a… Read more

0 comments, 53 reads

Posted in MSSQLFUN on 22 September 2014

SQLSaturday Orlando Marketing Plan-Part 45

It’s Saturday a week out and I’m trying to finish up messages for the week. A lot to send this week. Monday messages to the registered and not-registered list, one more lunch reminder, three sponsor email blasts, a big Friday reminder with lots of notes, and a Saturday morning “don’t… Read more

0 comments, 53 reads

Posted in SQLAndy on 20 September 2014

Parameterization Part 5: Two Common Mistakes

This is the fifth post in my Parameterization series. In previous posts I wrote about parameter sniffing and when it is good or bad, and also about how to work around the problems associated with parameter sniffing when data is not uniformly distributed. In this post I would like… Read more

0 comments, 158 reads

Posted in Guy Glantser on 20 September 2014

The Student To IT Pro Seminar We’re Doing at SQLSaturday Orlando

Ever since SQLSaturday #1 our venue has been Seminole State College (Seminole Community College back then), provided graciously and perhaps more importantly, at no charge. Finding a venue is a big deal when it comes to planning an event and finding one that’s free, that’s harder! Putting a bunch of… Read more

0 comments, 73 reads

Posted in SQLAndy on 19 September 2014

Back from DevConnections

I spent a few days at DevConnections this week and really enjoyed the conference. The location was Aria in Las Vegas, where I’ve never been, but it was a new, really nice hotel and there was one amazing thing:

The wi-fi worked.

Not on and off, pretty much the entire… Read more

0 comments, 127 reads

Posted in The Voice of the DBA on 19 September 2014

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 blog posts that came… Read more

0 comments, 84 reads

Posted in StrateSQL on 19 September 2014

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 Wendy Pastrick and Grant…

Read more

0 comments, 106 reads

Posted in SQL Awesomesauce on 19 September 2014

A Manager or a Community Person: #PASSVotes

I am running for the PASS Board. You can read more about what I’ve posted and what others have to say here on this page.

Today I want to ask you a question. Should someone on the board be a manger or should they be a community person? Let’s… Read more

3 comments, 70 reads

Posted in The Scary DBA on 19 September 2014

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 4.0 includes the following updates:

  • For enhanced support of large environments
    • Reviewed database…

Read more

0 comments, 76 reads

Posted in SQL Chicken on 19 September 2014

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
  • Building (for FREE) a Virtual Server for SQL Demos
  • Cheating DBCC…

Read more

0 comments, 70 reads

Posted in RealSQLGuy - Helping You To Become A SQL Hero on 19 September 2014

Outlier Detection with SQL Server, part 1: Finding Fraud and Folly with Benford’s Law

By Steve Bolton

…………My last blog series, A Rickety Stairway to SQL Server Data Mining, often epitomized a quip by University of Connecticut statistician Daniel T. Larose, to the effect that “data mining is easy to do badly.”[1] It is clear that today’s sophisticated mining algorithms can still… Read more

0 comments, 584 reads

Posted in Multidimensional Mayhem on 19 September 2014

Standardize SQL Server Implementations (Dev to Prod)

In this session Prakash will walk through the process he has implemented to alleviates many of the pain points for deploying, managing, and supporting multiple SQL Server deployments from development to production.

Read more

0 comments, 161 reads

Posted in SQLFeatures on 19 September 2014

SQLSaturday Orlando Marketing Plan-Part 44

More notes:

  • Registration at 520. Not as big a bump this week as we expected, probably due to the message going out to the unregistered list Tuesday late afternoon, but equally possibly that we’re reached the ones that plan to go. I’m tempted to email again this week, but I…

Read more

0 comments, 74 reads

Posted in SQLAndy on 18 September 2014

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 – South Side Trail: Gravatt Lane (0.72 miles… Read more

1 comments, 82 reads

Posted in WaterOx SQL on 18 September 2014

Why I Support PASS & Why I Criticize PASS

A friend recently asked me about my involvement with PASS, and that lead to the two questions in the title. Why do I support PASS? Why do I criticize PASS? And there is one more that goes with it, do I balance criticism with praise? Interesting stuff.

First, for those… Read more

9 comments, 232 reads

Posted in SQLAndy on 17 September 2014

Older posts