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

Latest Blog Posts

Finding gaps or missing dates in a date range using TSQL

Here’s a quick how-to on returning temporal data set that includes missing dates. Suppose you are tasked to query an employee’s “time sheet”. You’d want to return not only the days he’s reported to work but also all the days that he missed.

The expected result would look something like… Read more

0 comments, 154 reads

Posted in Marlon Ribunal - SQL, Code, Coffee, etc. on 29 May 2015

Query Progress Tracking in SQL Server for the DBA VC

This past Wednesday, I delivered my session, “Query Progress Tracking in SQL Server” to the DBA Virtual Chapter.

The session covers many techniques for tracking the progress of queries and processes. I also talked about very nice features that were added in SQL Server 2014 and SQL Server 2016.

The… Read more

0 comments, 107 reads

Posted in Matan Yungman on 29 May 2015

005 – Antiques Roadshow - WaterOx Consulting

Reading Time: 4 minutes

Are You Running An Antiques Roadshow? In WOxPod!, episode # 005 –...

The post 005 – Antiques Roadshow appeared first on WaterOx Consulting.

Read more

0 comments, 91 reads

Posted in WaterOx SQL on 29 May 2015

hey its time for 2016!!!

Hi all Yeah its true microsoft announced SQL server 2016 cp2 has been released to public and also we can read books online for it. First blog from mobile …..happy leaning…    

Read more

0 comments, 100 reads

Posted in Vinay Thakur on 29 May 2015

Installing SQL Server 2016 CTP2 – UI Changes

SQL Server 2016 CTP2 public build was released by Microsoft yesterday, and if you haven’t downloaded it yet, then drop everything(No, not a Production DB !) and go and get it from here.

This post is based on the UI changes/additions which I observed while I installed this specific… Read more

0 comments, 135 reads

Posted in on 29 May 2015

Earning my MCSE: Business Intelligence Certification

I earned my MCSE: Business Intelligence Certification on May 27, 2015. It was a long road, but I did it. Back in May of 2013, I wrote about being Certifiable and wasn’t really interested in pursuing any certifications. What made me change my mind you ask? The short answer is,… Read more

0 comments, 106 reads

Posted in SQL Swimmer on 28 May 2015

SQL Server 2008 R2 SP3 Install Errors

Whenever it is time to install a service pack every DBA silently hopes that nothing will go wrong.  I would surmise that, in most cases, installing the service pack is a non-event.  No flashing lights, no fireworks, no applause and no major hiccups.  This post is not about one of… Read more

0 comments, 76 reads

Posted in John Morehouse | on 28 May 2015

Creating a SQL 2016 CTP2 Virtual Machine in Azure

With the CTP2 of SQL Server 2016 now released you may be eager to try it out.  One of the best ways to do this in my opinion is to set it up on a virtual machine.  You could certainly do this with VMWare or Hyper-V but my new preference… Read more

1 comments, 116 reads

Posted in Devin Knight on 28 May 2015

SQL Server 2016 Live Query Statistics

So now that SQL Server 2016 CTP2 is released to the public we can all finally play with all the new features inside SQL Server 2016. You can download SQL Server 2016 CTP2 here:

While I was playing around with all the new features inside SQL Server 2016 (especially… Read more

0 comments, 179 reads

Posted in DotNine SQL Server and more on 28 May 2015

Multiple Windows Groups with different default databases

A question came up at work the other day, mostly as a mind game, but you never know it might actually come up at some point. So here is the idea.

  • UserA is a member of Group1, Group2 and Group3.
  • Group1 is set up as a server principal with a…

Read more

0 comments, 73 reads

Posted in SQLStudies on 28 May 2015

Microsoft Azure SQL Databases – Power and Performance

By David Postlethwaite

On the Database Scale page we can decide on the performance level that we want our database to have.
There are three performance levels Basic, Standard and Premium

  • Basic is best suited for a small size database, supporting one single operation at a time such as for…

Read more

0 comments, 66 reads

Posted in The SQL DBA in the UK on 28 May 2015

SQL 2016 Preview has been released!

For those who haven’t noticed already:

SQL Server 2016 CTP2 (or Preview as some call it) has just been released!
This means it is play time!

You can either download a copy if you’re old school like me, or you can spin up a VM in Azure like all the… Read more

2 comments, 95 reads

Posted in Koen Verbeeck on 28 May 2015

Forensic analysis for log files in sql server

The Importance of Log Files in SQL Server

On the SQL server every day we perform many transactions and as we know that all these transactions affect the log file. After all, the transactions are stored in the log file so every transaction contains some space in the log file… Read more

0 comments, 76 reads

Posted in Zora's SQL Tips on 28 May 2015

Azure SQL Database Elastic Scale Part 3 - Setting up and Querying the Shards

Azure SQL Database Elastic Scale Part 3 - Setting up and Querying the Shards
MAY 28, 2015

For those of you who have been following along with this series of posts, I have been looking at how Azure SQL Database Elastic Scale can be used to Horizontally Scale a Payroll…

Read more

0 comments, 179 reads

Posted in Pie in the Sky on 28 May 2015

Integrating Other Data Mining Tools with SQL Server, Part 1.1: The Weaknesses of WEKA

By Steve Bolton

…………The same rules that applied to my amateur mistutorial series on A Rickety Stairway to SQL Server Data Mining and Outlier Detection with SQL Server are in play for this series of occasional articles, which will provide a brief overview of using various third-party data mining… Read more

0 comments, 110 reads

Posted in Multidimensional Mayhem on 28 May 2015

Visualizing the Tally Table

I was reading Dwain Camps’ article on Time Slots and thought it was a very interesting solution to a problem I’ve had a few times. Getting time slots inside of a period that I want to query. If you have a similar need, or want to learn more, I’d urge… Read more

2 comments, 122 reads

Posted in The Voice of the DBA on 27 May 2015

Columnstore Indexes – part 54 (“Thoughts on upcoming improvements in SQL Server 2016?)

Continuation from the previous 53 parts, the whole series can be found at This is a not very deep technical post, which is describing the upcoming news and changes in SQL Server 2016. Since there is no public CTP…

Read more

4 comments, 153 reads

Posted in Niko's blog on 27 May 2015

How an MPP appliance solution can improve your future

Massive parallel processing (MPP) is the future for data warehousing.

So what is MPP?  SQL Server is a Symmetric Multiprocessing (SMP) solution, which essentially means it uses one server.  MPP provides scalability and query performance by running independent servers in parallel.  That is the quick definition.  For more… Read more

2 comments, 73 reads

Posted in James Serra's Blog on 27 May 2015

SQL F.A.D. – CSV List of Columns - WaterOx Consulting

Reading Time: 2 minutes

I had a project once that was using change data capture (CDC)...

The post SQL F.A.D. – CSV List of Columns appeared first on WaterOx Consulting.

Read more

1 comments, 123 reads

Posted in WaterOx SQL on 27 May 2015

PASS Board Update: May 2015

I’ve had a busy month on the Board.

You may have seen some tweets going by about our compliance with international laws regarding SPAM. This has been something of an education, so anything I say wrong below, it’s because I’m wrong, but not malevolent (at least in regards to this… Read more

2 comments, 89 reads

Posted in The Scary DBA on 27 May 2015

Older posts