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

Latest Blog Posts

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, 17 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, 28 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, 47 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, 146 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, 68 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, 119 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, 72 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, 99 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, 68 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, 71 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, 65 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, 526 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, 149 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, 71 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, 76 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

6 comments, 177 reads

Posted in SQLAndy on 17 September 2014

[SQL Snacks Video] Performance Tuning 101 – Baseline with PAL Tools

Welcome to Part 1 of my SQL Snack Pack on Performance Tuning! The series is dedicated to help beginners understand how to start performance tuning with SQL Server. This first video describes how to setup a baseline for your system using the PAL tools. It is essential to get a…

Read more

0 comments, 192 reads

Posted in - Ayman El-Ghazali on 17 September 2014

Why I’m Not Excited About Hekaton (In-Memory OLTP)

A while back I had written a post about why I’m excited about Hekaton (now called ‘In-Memory OLTP’ – not sure why, Hekaton is much more fun to say), and while I am certainly still excited about this new feature, it does have some significant barriers to entry.  Here’s a… Read more

1 comments, 3,455 reads

Posted in Adam Kreul | Blog on 17 September 2014

I Am Running For the PASS Board of Directors: #passvotes

This year, I submitted my application to run for the PASS Board and it was accepted. This then is my announcement to all of you and the beginning of my campaign for election. My name is Grant Fritchey and I’m running for the PASS Board.

It’s traditional to either make… Read more

1 comments, 2,647 reads

Posted in The Scary DBA on 17 September 2014

Triggers are not toys!

For the love of all that’s SQL, triggers are not toys! I’m not even talking about logon triggers or DDL triggers. I’m talking about plain old ordinary DML triggers.

Triggers are very useful tools but can easily cause all sorts of headaches. In fact I would generally advise… Read more

7 comments, 294 reads

Posted in SQLStudies on 17 September 2014

Older posts