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

Archives: September 2017

Instant File Initialization in SQL Server on Linux

Earlier this week Ned Otter (@NedOtter) brought up a question about Instant File Initialization on SQL Server on Linux, check out the thread here. I was up way too early in the morning, as I normally am, so I decided to poke around and see how it… Read more

0 comments, 95 reads

Posted in Anthony Nocentino's Blog on 23 September 2017

SQL Server On Containers

On Sep 23rd 2.45 PM PST, I will be presenting 2 sessions on “SQL Server On Containers” @ at SQLSaturday San Diego, if you are in the area I hope to see you…

Location: UCSD Extension – University City Center, 6256 Greenwich Dr., San Diego, California, 92122, United States

Read more

0 comments, 91 reads

Posted in SQLFeatures on 23 September 2017

Information Measurement with SQL Server, Part 2.2: The Rényi Entropy and Its Kin

By Steve Bolton

…………I kicked off this far-ranging series on using SQL Server to quantify information by discussing two of the earliest and most important measures, the Hartley function and Shannon’s Entropy. These foundations of information theory are intimately related to a more general measure, Rényi Entropy, which is… Read more

0 comments, 63 reads

Posted in Multidimensional Mayhem on 22 September 2017

SQL Server: The danger of large data types

Databases are platforms that are designed to securely store and retrieve your data. Perhaps that’s why they’re called a data “base”? So if your data is in a base, you’d want to lay it out in some logic way.

Watch towers go on the corners, barracks go somewhere over there,… Read more

0 comments, 99 reads

Posted in Confessions of a Microsoft Addict on 22 September 2017

How Mature are you in Database DevOps?

I remember seeing the Carnegie Mellon Software Capability  Maturity Model (CMM) when I was in university. It was fascinating, and I was sure this was the way to write software. Across many jobs and many years, I realized that few organizations even try to become more efficient and capable in… Read more

0 comments, 162 reads

Posted in The Voice of the DBA on 22 September 2017

PASS Summit 2017 is Coming

The yearly PASS Summit is just around the corner, a little less than six weeks away. For those not familiar with this event, it is a gathering of several thousand data professionals for 4+ days of education and networking. The PASS Summit will take place in Seattle, Washington, from Tuesday,… Read more

0 comments, 138 reads

Posted in Tim Mitchell on 22 September 2017

Restore BACPAC to SQL Azure


2 posts in 1 day? When you’re hot, you’re hot!

I’m actually writing this one whilst I’m waiting for a BACPAC to restore to Azure. It’s actually incredibly easy: use SQLPackage! Setthe /SourceFile to your bacpac, and use the connection string published on Azure, and you’re done!

View the… Read more

0 comments, 94 reads

Posted in Richie Lee's SQL Stuff on 22 September 2017

How To Update Visual Studio 2017

(AKA how I lost a morning)


This morning I needed to update my version of SSDT, but before I could do that I needed to update Visual Studio 2017:

Awkward wording of an error message aside, let’s update Visual Studio 2017.

But how?

I just started VS 2017, and… Read more

0 comments, 145 reads

Posted in Richie Lee's SQL Stuff on 22 September 2017

SQLpassion Online Training in October 2017

(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the essential knowledge you need to know about performance tuning on SQL Server.)

Today I’ve announced my SQLpassion Online Training for October 2017.

  • On October 5 I’m running a one-day…

Read more

0 comments, 135 reads

Posted in Klaus Aschenbrenner on 21 September 2017

Distributed Writes

In SQL Server, scaling out reads (i.e. using Active secondary replicas via AlwaysOn Availability Groups) is a lot easier than scaling out writes.  So what are your options when you have a tremendous amount of writes that scaling up will not handle, no matter how big your server is?… Read more

7 comments, 132 reads

Posted in James Serra's Blog on 21 September 2017

Recover Deleted Data from SQL Table Using Transaction Log and LSNs


At times a user may perform UPDATE operation or DELETE operation in SQL server database without applying the WHERE condition. This is a very common reason for encountering loss of data from SQL Server Tables. As the SQL Server database is a highly popular relational DBMS among corporate sectors… Read more

0 comments, 113 reads

Posted in PowerSQL By Prashanth Jayaram on 21 September 2017

What’s a SQL Compare Snapshot?

I saw a short video from Grant Fritchey on the Redgate channel that shows how to cerate a snapshot in SQL Compare. I think snapshots are great, and there are lots of uses (more on that later), but I do find sometimes I use the term and people are confused. Read more

0 comments, 202 reads

Posted in The Voice of the DBA on 21 September 2017

Test Database Compatability with dbatools

I really like the dbatools project. This is a set of PowerShell cmdlets that are built by the community and incredibly useful for migrations between SQL Servers, but also for various administrative actions. I have a short series on these items.

One of the items that few DBAs think… Read more

0 comments, 254 reads

Posted in The Voice of the DBA on 20 September 2017

Does rebuilding my clustered index also rebuild my non-clustered indexes?

I’ve been working with SQL Server for many years now, and up until recently, I assumed that rebuilding any clustered index would cause non-clustered indexes to be rebuilt as well, because the non-clustered index includes the clustered index in it. This assumption is wrong. On SQL Server 2000, this only… Read more

0 comments, 150 reads

Posted in Born SQL with Randolph West on 20 September 2017

An open letter to the PASS community (2017)

PASS is our community.

It may sound a little cliche, especially with the current political climate in the US and other nations, but it’s absolutely true. PASS is our community. It’s made up of data professionals from around the globe. All of us are volunteers, from the attendees to the… Read more

0 comments, 139 reads

Posted in The Data Files on 20 September 2017

Hmmm… What’s This?

OK So, I am doing some digging and peaking around again in SQL Server and came across a database option called Date Correlation Optimization Enabled = False. Honestly, I had no clue what it did, so I took it as a learning opportunity to look into it and do… Read more

1 comments, 122 reads

Posted in SQLEspresso on 20 September 2017

TSQL2sDay – Get-PostRoundup

First an apology, this round up is late!

The reason for that is an error in the PowerShell testing module Pester (That’s not completely true as you shall see!!)

I spoke in Stuttgart at the PowerShell Saturday last weekend and had intended to write this blog post whilst travelling, unfortunately… Read more

1 comments, 126 reads

Posted in SQL DBA With A Beard on 20 September 2017

Dieser Blog ist umgezogen // This Blog has moved: http://andreas-wolter.com/blog/


Liebe Leser
dieser Blog ist hiermit nur noch „Archiv“ und wird nicht mehr weiter gepflegt.
Seit August 2017 finden sich neue Artikel ausschließlich unter der neuen URL:

Dear Readers
this blog is now merely an „archive“ and no longer being updated.
Since August 2017 new articles are exclusively…

Read more

0 comments, 121 reads

Posted in Andreas Wolter SQL Server & BI blog (English / German) on 20 September 2017

The Tabular Model Documenter is now a Power BI Template

A while back I created the Tabular Model Documenter Power BI model that can connect to your SSAS Tabular or Power BI model and display metadata about the model to help you see relationships, calculations, source queries, and more.  I had been meaning to turn it into a parameterized template… Read more

7 comments, 155 reads

Posted in Data Savvy on 19 September 2017

Older posts