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

Latest Blog Posts

Cumulative Update – 7 for SQL Server 2014 RTM Is Now Available !

The 7th cumulative update release for SQL Server 2014 RTM is now available for download at the Microsoft Support site. Cumulative Update 7 contains all the hotfixes released since the initial release of SQL Server 2014 RTM.

Those who are facing severe issues with their environment, they can plan to… Read more

0 comments, 13 reads

Posted in MSSQLFUN on 27 April 2015

Speaking at NT Conference 2015 in Slovenia

It is always feels like a great honour to be invited to speak at a big conference, but when this conference is one of the biggest in its respective area and being run for the 20th time – it feels…

Read more

0 comments, 52 reads

Posted in Niko's blog on 26 April 2015

Microsoft DataZen Mobile Platform Available to Enterprise Customers for Free

Last week Microsoft announced that they had acquired the DataZen mobile BI platform and were adding it to their enterprise BI product suite.  This is very exciting news that rounds out the Microsoft BI capabilities of their entire product portfolio.  What’s more, is that they plan to make if free…

Read more

0 comments, 66 reads

Posted in SQL Server BI Blog on 26 April 2015

Hi Folks,

Hope you all are doing good. Would like to start with praying for all those who have been affected by a deadly earthquake in Nepal. Just when it seems that life is good something like this happens, to remind us of that we are not permanent here. Death…

Read more

0 comments, 0 reads

Posted in Everyday IT Challenges on 26 April 2015

Sql Saturday Talk

I had the honour of talking at the excellent Sql Saturday Exeter this morning and wanted to share my slides and say thanks to the organisers, sponsors and everyone who came along to my session - I really enjoyed it and I hope you did to.

The slides are available:

Read more

0 comments, 96 reads

Posted in Ed Elliott's Sql Developer Blog on 25 April 2015

SQLPort in Coimbra

One more project can be finally revealed – on the 5th of May of 2015, SQLPort is invading the home base of the 10th eldest university in europe (Unesco World Heritage Site) – Coimbra. This will be an epic 66th…

Read more

0 comments, 113 reads

Posted in Niko's blog on 24 April 2015

ETL #71–Your data can mysteriously disappear after a WHERE clause was added (1)

Validations at end of ETL indicate missing data

At the end of each ETL job, I always run some sort of validation process to give me an indication that the data loading and processing are as expected or things have gone terribly wrong. The latter happened last Thursday when I… Read more

0 comments, 68 reads

Posted in Sherry Li's BI Corner on 24 April 2015

How to post a T-SQL question on a public forum

If you want to have faster turnaround on your forum questions, you will need to provide enough information to the forum users in order to answer your question.

In particular, talking about T-SQL questions, there are three things that your question must include:

  1. Table scripts
  2. Sample data
  3. Expected output

  Read more

0 comments, 68 reads

Posted in SpaghettiDBA on 24 April 2015

Somebody Doesn’t Like You, and That’s Good

Everybody wants to be liked, to some extent. Being disliked by others feels like a deficiency, a shortcoming in oneself that must be fixed. It feels like a failure that you’ve let someone down, or even worse, it can make you feel like you’re somehow broken or deficient.

I would… Read more

0 comments, 74 reads

Posted in Tim Mitchell on 24 April 2015

Window Server 2008 Failover Clustering Logs

In Windows 2003 failover clustering, Cluster nodes continuously putting details in log file on each node. This log is in readable plain text format & located in %SystemRoot%\Cluster folder on each node in the cluster and the name of the file is CLUSTER.LOG.

In Windows 2008, One of the major… Read more

0 comments, 83 reads

Posted in MSSQLFUN on 24 April 2015

Availability Group WSFC Failovers During VM Movement

If you experience a WSFC failover during a VMware vMotion / Hyper-V Live Migration with your virtualized SQL Servers when using Availability Groups, you might have server and/or networking hardware that takes a bit longer than usual to handle the network port failover. This can lead to short unexpected outages… Read more

0 comments, 80 reads

Posted in Technobabble by Klee from @kleegeek on 23 April 2015

PASS Board Update: April 2015

It’s been a pretty interesting month on the board.

First, we did have a little problem. I’m sure one or two of you may have noticed that the SQL Saturday web site was down for a moment. Well, three days. Joking aside, this was a serious problem, but my… Read more

6 comments, 98 reads

Posted in The Scary DBA on 23 April 2015

Ruminations on Writing Great T-SQL

Today we’re going to try to extend some advice that I once heard from SQL MVP Jeff Moden, which I wrote about in my previous blog entitled “Make it Work, Make it Fast, Make it Pretty.”  That advice was just as pertinent then as it is now,… Read more

2 comments, 1,733 reads

Posted in DwainCSQL on 23 April 2015

SQL Sentry Pro Explorer is worth it...

I'll post more later, but after a full day of query tuning on a difficult view, I'd definitely say the cost for PRO is worth it. I'm a fan of sql sentry (free), and decided recently to push for a license at work on this tool.

Turns out it was… Read more

0 comments, 137 reads

Posted in BIT Barbarian on 22 April 2015

Instances and Ports with PowerShell

Just a quick post and a day late for #SQLNewBlogger There are some excellent posts on that hashtag and I recommend that you read them

When you know a server name but not the name of the instances or the ports that they are using this function will be of… Read more

0 comments, 131 reads

Posted in SQL DBA With A Beard on 22 April 2015

How Many SQL Log Files Do You Keep?

Reading Time: 2 minutes

Ever have this happen?

You (on vacation): I’ll have another piña colada please. Yes, in the coconut. Thanks! Hmm, my phone is ringing…..Hello?

Work: There are problems! The database is messing up and being really slow!

: Well, email me the latest log file from SQL… Read more

1 comments, 91 reads

Posted in WaterOx SQL on 22 April 2015

Optimizing the Modern Data Platform with SQL Server 2014

Join Jason Strate and Pragmatic Works in Minneapolis on May 7. Learn about Optimizing the Modern Data Platform with SQ Server 2014. Register here.

Read more

0 comments, 125 reads

Posted in DataOnWheels on 22 April 2015

Overview of Published Articles – 2015Q1

Here is an overview of the articles I published in the first quarter of 2015.


This will probably be my last article for Intense School for a while.


But on the other hand, I’ve doubled my efforts for… Read more

0 comments, 113 reads

Posted in Koen Verbeeck on 22 April 2015

Backup before you restore

You should always be recoverable. If you haven’t heard that before, take note of it. It’s important.

A while back I wrote about Operational Recovery. This is when there isn’t a disaster but you still need to restore some or all of a database. Someone forgot the WHERE clause… Read more

3 comments, 89 reads

Posted in SQLStudies on 22 April 2015

Make Sure to Schedule Your SQL Server Replication Jobs

You setup SQL Server Replication and everything looks fine. Rows are flowing between the servers and you think you’re done.

Right? Wrong..

At some point in time, your replication jobs will stop (some replication failure, stop for maintenance, etc..). Once that happens, will they start working again?

When you… Read more

0 comments, 169 reads

Posted in Matan Yungman on 22 April 2015

Older posts