SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Latest Blog Posts

The Birthday Problem – with T-SQL and R

When I was on SQLCruise recently – Buck Woody (b|t) made a interesting statement – that in a room of 23 people, there is over a 50% chance that  two or more have the same birthdays. And sure enough, we did end up having more than… Read more

0 comments, 41 reads

Posted in Mala's Data Blog on 24 April 2017

Setting the default file type for a new file in VS Code

Just a short post today. When you open a new file in VS Code (Using CTRL + N) it opens by default as a plain text file.

To change the language for the file use CTRL +K, M.

That’s CTRL and K together and then M afterwards separately.

then you… Read more

0 comments, 37 reads

Posted in SQL DBA With A Beard on 24 April 2017

Monday Coffee 2017-04-24

Back after a couple of busy weeks, kinda looking forward to getting back into the old work routine (ah, well maybe )

Last week was a big week, I had my first article published on SQLShack.com and there were a couple of small events going on called Docker Con 2017… Read more

0 comments, 52 reads

Posted in The DBA Who Came In From The Cold on 24 April 2017

I Escaped from a SQL Server Service Pack Nightmare

I hope you take backups or have a recovery plan in place before a SQL Server service pack upgrade,  if not you might want to reconsider. Initially I wasn’t going to capture the screen shots during this recovery because my … Continue reading

Read more

2 comments, 66 reads

Posted in All About SQL on 24 April 2017

Wait Statistics integration inside the Query Store in SQL Server vNext

I remember writing an article about Query specific wait statistics being available inside execution plans in SQL Server 2016 SP1. The way that works is when you view the actual execution plan of a query (through SSMS or the XML) you are able to see the wait information that specific… Read more

0 comments, 113 reads

Posted in DotNine SQL Server and more on 23 April 2017

Resumable Online Index Rebuild

I have been fascinated with another new feature of the upcoming SQL Server release and so I decided to blog about it.

The new version of SQL Server (2017) introduces a very exciting feature for the DBA’s – the Resumable Online Index Rebuild.
This feature is targeting the installations that… Read more

0 comments, 107 reads

Posted in Niko's blog on 23 April 2017

Why Did Your Availability Group Creation Fail?

Availability Groups are a fantastic way to provide high availability and disaster recovery for your databases, but it isn’t exactly the easiest thing in the world to pull off correctly. To do it right there’s a lot of planning and effort that goes into your Availability Group topology. The… Read more

0 comments, 222 reads

Posted in Anthony Nocentino's Blog on 22 April 2017

Excel BI VC presents Prathy Kamasani–Power BI Dashboards for Excel Users


Thu, Apr 27 2017 20:00 GMT Daylight Time

Power BI Dashboard within an hour for Excel users

RSVP: https://attendee.gotowebinar.com/register/8516045593703848705

Power BI Dashboard within an hour for Excel users

If you are an experienced Excel user or Someone in your organisation mentioned about Power BI and you want to understand…

Read more

0 comments, 98 reads

Posted in The Smiling DBA on 22 April 2017

Columnstore Indexes – part 104 (“Batch Mode Adaptive Joins”)

Continuation from the previous 103 parts, the whole series can be found at http://www.nikoport.com/columnstore/.

This blog post is a logical continuation of the blog post that I have published in December 2016 – Columnstore Indexes – part 93 (“Batch Mode Adaptive Memory Grant Feedback”), but this time I… Read more

4 comments, 171 reads

Posted in Niko's blog on 22 April 2017

DevOps Basics– git Cloning Repos

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers.

This continues my series on git, because I think it’s good to know what the command line is and how to use it.

Once you have git… Read more

0 comments, 189 reads

Posted in The Voice of the DBA on 21 April 2017

2 Great Courses For Databases Professionals - Deal Of the Week

I received  the email from Learning Tree on Wednesday with their weekly offer of courses running in the London Education Center this May. There are 2 Great  Courses For Databases Professionals.  Aside from the SrumMaster course which is priced separately you can get the courses listed for £750 plus…

Read more

0 comments, 196 reads

Posted in The SQL DBA in the UK on 21 April 2017

Book Review – The Truthful Art

I’m participating in the #vizBookClub, a great idea by the data visualization community. In short, we read a book about data visualization and we post our thoughts online. A blog post with more detail: Introducing our Data Viz Book Club. The first selected book is The Truthful Art by… Read more

1 comments, 196 reads

Posted in Koen Verbeeck on 21 April 2017

Microsoft Data Amp event announcements

Yesterday was the Microsoft Data Amp event where a bunch of very exciting announcements were made:

  • SQL Server vNext CTP 2.0 is now available and the product will be officially called SQL Server 2017:
    • Runs on Linux and Docker
    • Support for Graph queries.  More info
    • Support for R and now…

Read more

1 comments, 239 reads

Posted in James Serra's Blog on 20 April 2017

What is SQL Server?

I’ve been playing around with YouTube, making some tutorial videos on SQL Server and it’s been a fun process so far. For my first video I decided to start at the beginning – This video looks at what SQL Server is? Basically what comes under the SQL Server umbrella? What…

Read more

0 comments, 150 reads

Posted in The SQL DBA in the UK on 20 April 2017

Thoughts about the Microsoft Data Amp Announcements

Microsoft conducted a live event called Microsoft Data Amp to announce a number of key features and releases for SQL Server on premises and data platforms in Azure (such as Azure SQL DB and Azure Data Lake). Some of these include features that I have been waiting to see. Here… Read more

2 comments, 320 reads

Posted in DataOnWheels on 20 April 2017

Presenting 2 sessions @ SQLSaturday (Silicon Valley)

Apr 22nd I will be presenting “Re-Indexing – The quest of ultimate automation” & “Consolidated Essential Performance Health Check using PowerShell” @ SQLSaturday, Silicon Valley, if you are in the area I hope to see you

PASS sqlsaturday’s are free 1-day training events for SQL Server professionals… Read more

0 comments, 128 reads

Posted in SQLFeatures on 19 April 2017

Using Twitter with VS Code

So today I saw this tweet from Mathias in reply to Stefan and Amanda


That looks cool. Twitter in VS Code, one less programme to open Here how it works

Open VS Code and hit CTRL + P and type ext install twitter or hit CTRL + SHIFT +… Read more

0 comments, 103 reads

Posted in SQL DBA With A Beard on 19 April 2017

SQL Server 2017 is coming

It’s official: the next version of SQL Server, planned to be released this year, will be called SQL Server 2017. It is currently in the Community Technology Preview (CTP) 2.0 stage which is the first production-quality preview of the product.

Even though it’s coming just a year after SQL 2016,… Read more

0 comments, 513 reads

Posted in Gorandalf's SQL Blog on 19 April 2017

SQL Server on Linux (Ubuntu)–Updating from Early CTP

I’ve been testing the SQL Server on Linux for a long time. After the recent Microsoft Data Amp event, I saw the announcement for CTP-2. So I did what I’ve been doing for some time on my Ubuntu machine:

sudo apt-get update

sudo apt-get install mssql-server

However, I got… Read more

0 comments, 200 reads

Posted in The Voice of the DBA on 19 April 2017

Weaning yourself off of SQL Profiler (Part 1)

In this brave, new world of Extended Events (XE, XEvents), I find myself with a mixture of scripts for troubleshooting issues – some use XE, and some use traces. We’ve all been told that XE is a much better system (it is much more lightweight, causing less of an issue… Read more

0 comments, 190 reads

Posted in A Discussion of SQL Server-Related Topics on 19 April 2017

Older posts