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

Latest Blog Posts

I’ve joined the SQL SERVER MVP community – Thank you!


Today I awoke to find an email from Microsoft informing me that I’d been awarded an MVP. Wow.

I had to re-read the email several times over the course of the next hour to ensure it was true. Also checking the date – to make sure it was… Read more

0 comments, 15 reads

Posted in measure twice, cut once. on 1 October 2014

I’m a SQL Server MVP!

I was just awarded as a Microsoft SQL Server MVP!

I can’t believe Microsoft has chosen me for this award and to be included in such a prestigious program.  There are only a little over 70 SQL Server MVPs in the United States and a little over 350 world wide. Read more

10 comments, 48 reads

Posted in Ryan Adams on 1 October 2014

Renewed as MVP for 2015

Took a break to check email and saw the confirmation that I was renewed for another year. Pleasant news for a Wednesday morning. Strange to realize this is my 7th time, where did the time go? I’ve certainly changed a lot in those years!

For those who aren’t MVP’s and… Read more

0 comments, 47 reads

Posted in SQLAndy on 1 October 2014

C-R-U-D The Basics

C-R-U-D The Basics

What is CRUD? Well, there are a lot of things I can think of when I use the term CRUD; however within the wonderful world of technology CRUD is an acronym that surprisingly enough, when I polled, didn’t really give a straight answer. That really surprised me;… Read more

2 comments, 41 reads

Posted in The SQL Professor on 1 October 2014

SQL Server 2008 SP4 Released

On September 30th 2014 Microsoft released service pack 4 for SQL Server 2008. This service pack contains all cumulative updates since SP3 was released as well as all updates from previous service packs.

Today begins the day we should all begin testing in Dev with SP4. You can get information… Read more

0 comments, 45 reads

Posted in Tim Radney - Database Professional on 1 October 2014

Optimizing Power BI Q&A with Synonyms and Phrasing using Cloud Modeling

If you’ve have used or even just seen a demo of Power BI Q&A you’ve likely seen there’s great potential in the feature for even low-tech user. I usually say, “If the user knows how to use a search engine then they can interact with Q&A.” You can read the… Read more

0 comments, 41 reads

Posted in Devin Knight on 1 October 2014

Identifying large queries using Extended Events

Following on from my last blog post I now want to run through how to identify large queries using Extended Events.

Extended Events were introduced in SQL Server 2008 and allow monitoring to be run against a server with a lower performance impact than profiler sessions and server side traces. Read more

0 comments, 37 reads

Posted in The DBA Who Came In From The Cold on 1 October 2014

Intro to Auditing in SQL Server on SQL Shack

I had an article published yesterday on

Intro to Auditing in SQL Server.

It’s worth reading if I do say so myself. In it I go through several different methods for generating data that might be required by an auditor. I range from adding auditing columns to each… Read more

0 comments, 42 reads

Posted in SQLStudies on 1 October 2014

Track My Query Utility

Were you ever in a situation where you ran a query, it ran for a long time and you didn’t know what it was doing? Sure you were..

What if you had a visual indication of where things are stuck in your execution plan, while the query is running?

A… Read more

4 comments, 43 reads

Posted in Matan Yungman on 1 October 2014

Error while enabling NetFx3 feature || Alternate source path error

Hello Friends,
Life Is a struggle with Lot of If and buts. It’s being a many month I was out of touch with my blogging hunger. But there were lot of question which I was getting from time to time on my mails/blogs , which I will try to answer… Read more

0 comments, 39 reads

Posted in AshishSharePointBlog on 1 October 2014

PASS 24HOP AlwaysOn Questions Answered

I presented a session titled “SQL Server AlwaysOn Quickstart” on September 10th for the 24 Hours of PASS event.  You can view the session recording HERE if you missed it.  The session was a preview of the full session I will be presenting at the PASS Summit 2014 this November.… Read more

0 comments, 54 reads

Posted in Ryan Adams on 30 September 2014

PASS Voting Extended Until October 14th

The Board of Directors has extended voting in the current election through October 14th. Read the post from President Thomas Larock about why and what you have to do to be eligible. Then head to Election HQ to review the candidates, ask questions, and read posts and endorsements from other… Read more

0 comments, 58 reads

Posted in SQLAndy on 30 September 2014

Speaking at Space Coast SQL Users Group on October 10th, 2014

I’ll be driving to Viera for the monthly Space Coast SQL Users Group meeting next week. Topic still to be decided, probably Learning Plans and something SQL, look for details on the web site today or tomorrow at

Read more

0 comments, 58 reads

Posted in SQLAndy on 30 September 2014

The Fallacy of Internal Access Only

In the wake of Shell Shock, I’ve seen some vendor advisories indicate that while their product is vulnerable, it’s only through the management interface but everything is okay because if best practices have been followed, the management interface isn’t/hasn’t been exposed to the Internet.

No, everything is not okay.… Read more

0 comments, 54 reads

Posted in Databases – Infrastructure – Security on 30 September 2014

IaaS, PaaS, and SaaS explained

You might be reading a lot about Cloud computing and see three acronyms frequently: IaaS, PaaS, Saas.  Cloud providers offer their services according to these three fundamental models:

Infrastructure-as-a-service (IaaS)

This is the most basic model which is essentially your virtual machines in a cloud data center.  You… Read more

0 comments, 169 reads

Posted in James Serra's Blog on 30 September 2014

VMware vCenter Web Client IP redirect solution

If you are working on a VMware vCenter Server v5.5 in an environment that has multiple segregated VLANs designed to isolate certain types of traffic, and find that the web client for your admin-facing interfaces keeps redirecting to an internal isolated IP address – and therefore fails – here’s the… Read more

0 comments, 48 reads

Posted in Technobabble by Klee from @kleegeek on 30 September 2014

Video: Walk & Talk #003 – RPO

What is the RPO?

And why does it matter?

Join me as I walk through Jefferson Patterson Park’s Indian village and discuss the Recovery Point Objective and what it means is respect to SQL Server.

Location: Jefferson Patterson Park

More info:

The post Video: Walk & Talk #003 –… Read more

1 comments, 50 reads

Posted in WaterOx SQL on 30 September 2014

Notes On SQLSaturday Orlando #318

Notes from a speaker/volunteer perspective:

  • It was a lot of fun to talk to the students at our Student to IT Pro Seminar. Interesting to hear their questions, easy to forget what it’s like to be a true beginner. 70 people in the seminar. Win!
  • I had about 20 in…

Read more

2 comments, 73 reads

Posted in SQLAndy on 30 September 2014

A real life table variable performance problem.


I’m sure we’ve all heard and read about the differences between table variables and temporary tables. In case you haven’t here’s one of many articles that you can read on the subject.

Anyway, there is a business process in one of my databases that calculates results via… Read more

0 comments, 64 reads

Posted in measure twice, cut once. on 30 September 2014

SQLServer 2008 R2 SP3 released, Now its testing and deployment time!

As promised Microsoft released SQL Server 2008 R2 SP3 last Friday, and now this is your opportunity to test and patch all the existing SQLServer 2008 R2 to this latest build.

SP3 will be the last and final service pack for SQL Server 2008 R2 ,and it will be a… Read more

0 comments, 78 reads

Posted in on 29 September 2014

Older posts