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

Archives: 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, 95 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, 87 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, 215 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, 89 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, 164 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, 175 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, 184 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

0 comments, 185 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, 231 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, 144 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, 310 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, 122 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, 98 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, 482 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, 194 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, 183 reads

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

SQL Doc by RedGate

I recently was on a call where a technical unit indicated they did not receive any form of documentation around the vendor database that was created. Now, seeing that I fall into the database profession it sparked my fancy. I began to ask a few questions to the individual who… Read more

0 comments, 165 reads

Posted in The SQL Professor on 19 April 2017

SQL Server: Functions vs. Stored Procedures to return result sets

A while back, I was building the database schema for a web application which had some reporting functionality and among other things, I had do implement logic in the database to prepare the data for the application's reports. The queries I constructed were relatively complex which meant that I needed…

Read more

0 comments, 89 reads

Posted in xSQL blog on 19 April 2017

SQL Security Email Course

Today I am very excited to announce that I have (finally!) launched my email course covering the basics of SQL Server Security. This has been a lot of work to get a new system in place to make the learning experience a little different. It is like a normal email… Read more

0 comments, 106 reads

Posted in WaterOx SQL on 19 April 2017

VirtualBox SQL FCI - Given Network Name Is Unusable

The other day I needed to test some HADR requirements on my local machine so using VirtualBox, I created a 2 server Windows 2012 R2 failover cluster with shared storage provided by FreeNAS and a domain controller. All was good at the windows level so I proceeded to install a… Read more

0 comments, 110 reads

Posted in SQL Server Rocks! on 19 April 2017

Older posts