-->
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, 1,610 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, 1,640 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,078 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, 464 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, 854 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.


To…

Read more

3 comments, 539 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, 488 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

3 comments, 1,634 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, 528 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,104 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

0 comments, 323 reads

Posted in Guy Glantser on 28 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, 109 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, 151 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

1 comments, 1,200 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,085 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, 517 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, 851 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, 278 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, 686 reads

Posted in SQL Awesomesauce on 25 February 2016

SQL Filegroup/File Proportional Fill Algorithm

I had a question at work recently where there was some confusion around how SQL Server allocates data across data files within a filegroup in a user database.  There was a mention that data was not being distributed evenly across files and also that a trace flag was needed… Read more

1 comments, 1,879 reads

Posted in Mr. Fox SQL on 24 February 2016

Older posts