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

Archives: February 2016

Goodness-of-Fit Testing with SQL Server Part 6.1: The Shapiro-Wilk Test

By Steve Bolton

…………Just as a good garage mechanic will fill his or her Craftsman with tools designed to fix specific problems, it is obviously wise for data miners to stockpile a wide range of algorithms, statistical tools, software packages and the like to deal with a wide variety… Read more

0 comments, 2,697 reads

Posted in Multidimensional Mayhem on 29 February 2016

PowerShell – Backup Individual database and delete all it’s respective files by keeping a recent file

Problem Statement

The requirement is to backup individual database and after successful backup the script should retain the most recent file and delete the rest from a directory for that specific database.

The below Powershell script is used to backup a specific database on a given directory

[System.Reflection.Assembly]::LoadWithPartialName("Microsoft.SqlServer.SMO") | Out-Null…

Read more

4 comments, 2,097 reads

Posted in PowerSQL By Prashanth Jayaram on 29 February 2016

Wait Statistics in Azure SQL Database

You need to be aware that you’re going to see differences when you’re working with Azure SQL Database when it comes to wait statistics. If you’re running a v12 Azure SQL Database (and if you’re not, go fix it), you can run a query against sys.dm_os_wait_stats. Here’s the output for… Read more

4 comments, 1,508 reads

Posted in The Scary DBA on 29 February 2016

SQL Saturday Chicago Precon – SQL Server Infrastructure – This Friday

This Friday I will be holding a precon training session at the next SQL Saturday in Chicago called ‘SQL Server Infrastructure Tuning for Availability and Performance.’ Only a few seats remain!

The focus of the course is to help those new to the enterprise server infrastructure concepts become… Read more

0 comments, 810 reads

Posted in Technobabble by Klee from @kleegeek on 29 February 2016

Blogger questions: How often should I blog?

What with the #sqlnewblogger effort we’ve been seeing a lot of new bloggers (and some old ones starting up again) and there is one thing that seems to come up over and over again.

How often should I blog?

Let’s start with how often I blog. I post twice a… Read more

10 comments, 1,217 reads

Posted in SQLStudies on 29 February 2016

Goodbye Pragmatic Works

Normally when I write a blog, I start out will a Hello to my Dear Reader.   Not today.  This was almost a blog I didn't write because I didn't know where to start.  So let me start with the people and see if it moves along from there.


Read more

3 comments, 948 reads

Posted in SQLBalls on 29 February 2016

I/O Baseline Comparison – Idera Diagnostic Manager

What servers need the most attention when it comes to I/O?  When I increase the memory on a server what effect does it have on I/O?  What was it before the change and what was it afterwards?

These are tough questions, and I have a script that I hope will… Read more

0 comments, 898 reads

Posted in Simple SQL Server on 29 February 2016

Dynamic Data Masking

Here’s a new feature that I like very much: Limiting exposure of sensitive data like user emails, phone numbers, addresses, credit card numbers and so on.

This feature has been available in the Azure SQL Database for a while and now it is included in the new SQL Server 2016… Read more

4 comments, 2,023 reads

Posted in Gorandalf's SQL Blog on 29 February 2016

Article Series: Power BI Solutions for the Enterprise

I’m working on a series of articles about creating enterprise solutions with Power BI and the first article was published this past week in SQL Server Pro Magazine.  I will republish the completed series but until then, I’ll post short excerpts from each article.  In future posts, I’ll show examples…

Read more

6 comments, 849 reads

Posted in SQL Server BI Blog on 28 February 2016

My favourite wait state– ASYNC_NETWORK_IO

Sometimes it does feel that a problem is a database problem until proven otherwise.  When this does occur I have had to put a lot of time and effort into demonstrating the hows and whys.  One of the easiest ( and most common ) scenarios of this is related to… Read more

4 comments, 2,544 reads

Posted in Dave Ballantynes blog on 28 February 2016

From XML to JSON – script

Last Thursday I presented my session “From XML to JSON” in the Application Development PASS Virtual Chapter. The session is about XML and JSON, two widely used markup languages, shared by many applications and data platforms. XML has been natively supported in SQL Server since 2005, and JSON is… Read more

1 comments, 666 reads

Posted in Guy Glantser on 28 February 2016

Because loyalty is a two-way street

Moving a dog to Australia with no money at hand

I always had plans to move to Brisbane, Australia, where my brother lived. After getting hitched, it was a long wait for my wife to be relieved from Central Government services before we moved to AU. With the way things… Read more

10 comments, 190 reads

Posted in SQL Roadie on 27 February 2016

Mandatory Sql Server properties to configure on a new instance

After installing a SQL Server instance, it’s good that you check the instance settings and change some of them. Next are the top 3 settings that have become a best practice for configuring a fresh instance, unless there are some very special reasons to not touch them. However, relevant documentation is given to… Read more

0 comments, 633 reads

Posted in Si vis pacem, para sql on 26 February 2016

Some Sql Server properties to configure on a new instance

After installing a SQL Server instance, it’s good that you check the instance settings and change some of them. Next are the top 3 settings that have become a best practice for configuring a fresh instance, unless there are some very special reasons to not touch them. However, relevant documentation…

Read more

0 comments, 525 reads

Posted in SQL Mighty on 26 February 2016

Fix a Network Binding Order Warning

Network Binding Order Warning One of the more common errors I see when setting up a Windows cluster (usually in preparation for a SQL Server Failover Cluster Instance or a SQL Server Availability Group) is regarding an incorrect network binding order.  You will see this presented as a warning in… Read more

10 comments, 1,672 reads

Posted in Ryan Adams on 26 February 2016

The Jarvis–Standing Desk Update

I started using a standing desk a few years back. While visiting the Redgate Software office, I saw one of my coworkers standing and using boxes of books to lift their keyboard and mouse. I tried that.

My first desk from 2012.

It worked OK, and I found myself… Read more

8 comments, 1,944 reads

Posted in The Voice of the DBA on 26 February 2016

Announcing Workshops – Columnstore Deep Dive (in German)

To support Microsoft with the upcoming release of the SQL Server 2016, OH22 have decided to open another public 2-days deep dive workshop on Columnstore Indexes.

This public workshop will take place in Cologne on 10th & 11th of May 2016, at Microsoft Germany office in Cologne (Notice that… Read more

0 comments, 856 reads

Posted in Niko's blog on 26 February 2016

SQL 2012 Identity Columns Feature

Recently, a customer mentioned that they seemed to be missing records in tables they don’t delete from. Generally, at this point the first thoughts would be user error or code problem or even someone fiddling in the database. But having dug deeper into this, I came across this “feature”.… Read more

1 comments, 1,392 reads

Posted in SQLYSE with Pankaj Manek on 25 February 2016

DBCC Just Runs Faster, Unless You’re Cheap

The CSS SQL Server Engineers have released a post showing that consistency checks using DBCC CHECKDB is faster and scales better in SQL Server 2016.

This is great news for all of us, especially if you are struggling to get all of your maintenance done within your allotted maintenance window. Read more

1 comments, 581 reads

Posted in The Database Avenger on 25 February 2016

Well that’s just neat: Row Level Security, new in SQL Server 2016

SQL Server 2016 offers Row Level Security, which sounds awfully cool. It’s apparently been available in Azure for a while, but the on-prem version is getting it, now. Securing Rows Okay, so: row level security (or RLS as the MSDN article so groovily puts it). What’s that, then? In short,…

Read more

4 comments, 1,080 reads

Posted in SQL Awesomesauce on 25 February 2016

Older posts