Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Archives: November 2015

Summon Blue Screens of Death (for testing purposes only, of course)

Today I had a need to manually trigger and sustain a Blue Screen of Death (BSOD) inside a Windows Server VM. The goal was to be able to trigger a BSOD so that I could work on the detection of powered on but failed VMs inside a server environment. All… Read more

1 comments, 402 reads

Posted in Technobabble by Klee from @kleegeek on 30 November 2015

Monday Morning SQL Break – November 30, 2015

It’s Monday time for this week’s blog and twitter round-up for last week. If you haven’t already, follow me on twitter (@StrateSQL). This is a good chance to catch up on data platform technology and career related information I’ve shared in the last week and activity on this… Read more

0 comments, 333 reads

Posted in StrateSQL on 30 November 2015

You should always have an “I got hit by a bus” backup plan

You have an on call, you have a business continuity plan, you have a disaster recovery plan but what happens when your developer, DBA or whoever is hit by a bus?

The situation

User: Oh noes! The web sites down!

One quick call later

Developer: Hmm, it looks… Read more

8 comments, 1,959 reads

Posted in SQLStudies on 30 November 2015

Row-Level Security part 2 – Controlling Write Access

My previous post was focused on controlling read operations. With the latest enhancements to the row-level security, it is now possible to restrict write operations as well. This feature is currently available as a preview now generally available in Azure SQL Database V12. Let’s see how that works.

Filtering and…

Read more

0 comments, 1,662 reads

Posted in Gorandalf's SQL Blog on 29 November 2015

Columnstore Indexes – part 73 (“Big Delta-Stores with Nonclustered Columnstore”)

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

Since the very first version of SQL Server the maximum size for the Delta-Stores as well as the compressed Row Groups was limited to 1048567 Rows. This number represents the power of 2 in exponent… Read more

0 comments, 388 reads

Posted in Niko's blog on 28 November 2015

Python Command Line Calls

There was a time I worked in a company any we lived in the command line. This was in the early 90s, prior to Windows v3.1 being released and we primarily used DOS on a Novell network.

We also had paper phone books on every desk for the 1,000+ people… Read more

2 comments, 565 reads

Posted in The Voice of the DBA on 27 November 2015

Find duplicate indexes in SSDT

Update new download location is https://visualstudiogallery.msdn.microsoft.com/435e7238-0e64-4667-8980-5...

Duplicate indexes, one of the most pointless things you can do to a table that just adds pure overhead. No one likes them so SQL Developers do your DBA's a favour and stop them from ever being deployed :)

This new tool for the…

Read more

0 comments, 471 reads

Posted in Ed Elliott's Sql Developer Blog on 27 November 2015

SQL Server – DROP IF EXISTS in SQL Server 2016

Hi friends, in SQL Server 2016 to check the existence of the object a new optional clause IF EXISTS gets …

Continue reading Read more

0 comments, 597 reads

Posted in Kapil Blogs on 27 November 2015

Value can not be null Parameter Name:store TFS WorkItem Store Error

Error HRESULT E_FAIL has been returned from a call to a COM component.

System.Runtime.InteropServices.COMException (0x80004005): Error HRESULT E_FAIL has been returned from a call to a COM component.
   at Microsoft.TeamFoundation.WorkItemTracking.Client.DataStore.DataStoreNative.UpdateMetadata(IntPtr handle, Object rowset, String dbstamp, UInt32& changes)
   at Microsoft.TeamFoundation.WorkItemTracking.Client.DataStore.Datastore.UpdateMetadata(Object rowset, String dbstamp)
   at Microsoft.TeamFoundation.WorkItemTracking.Client.WorkItemStore.EndBackendCall(BackendCallData data)

Read more

0 comments, 542 reads

Posted in Querying Microsoft SQL Server on 26 November 2015

UK Contractors - As you were, for now at least

I think there were are few sighs of relief around the country yesterday after the chancellor finished giving his autumn financial statement to parliament. For the past few weeks there has been plenty of reports of doom and gloom from the various media channels suggesting that the end was nigh… Read more

0 comments, 383 reads

Posted in SQL Server Rocks! on 26 November 2015

Covering Indexes

Microsoft continues to improve indexes and options for additional performance enhancements. One I see frequently is the need for a covering index. Before we look at those options, let’s talk about the need for a covering index.

The term covering index was created probably a decade ago. The idea is… Read more

2 comments, 2,266 reads

Posted in The Smiling DBA on 26 November 2015

Using Stored Procedures in SQL Server For Better Performance

Intoduction to Stored Procedures in SQL Server

SQL Server uses Different types of stored procedures. They are the quickest method of accessing and manipulating database on the server. SPs are codes and scripts that are predefined for repetitive tasks to be performed on the server involving a database/its table/pages,… Read more

0 comments, 823 reads

Posted in Zora's SQL Tips on 26 November 2015

Steps to create SQL database at Azure

Hi friends, in this blog we will learn how we can create the SQL database at Microsoft Azure. Login into …

Continue reading Read more

0 comments, 446 reads

Posted in Kapil Blogs on 26 November 2015

Complete DAX Function Reference

The DAX function documentation in MSDN can be found on separate pages,  organized by function categories and then details for every function.  This is useful but you can’t view all of the functions in one searchable page.  If you don’t know exactly what you’re looking for, it can be a…

Read more

5 comments, 448 reads

Posted in SQL Server BI Blog on 26 November 2015

Know More About SQL Server Error number 6401


The ACID acronym standing for Atomicity, Consistency, Isolation and Durability is the foundation of SQL transactions. Transactions are used when the database has to be modified by using one or more SQL statements and to make sure the security of the database as well. However, at times, this normal… Read more

0 comments, 800 reads

Posted in Zora's SQL Tips on 25 November 2015

Convert select statements in scripts into Inline-TVF's automatically

Update new download location is https://visualstudiogallery.msdn.microsoft.com/435e7238-0e64-4667-8980-5...

In-line TVF's are awesome, they are a great way to reuse T-SQL code without the performance penalties of multi line TVF's or horror of horrors Scalar Functions. Taking select statements and turning them into in-line TVF's is actually really really simple using the TSql…

Read more

0 comments, 354 reads

Posted in Ed Elliott's Sql Developer Blog on 25 November 2015

ScriptDomVisualizer - Now Displays TSqlParserToken's

New ScriptDom visualizer now also shows the tokens that are found in a sql script. It also highlights the part of the query that is covered by the token so it is really easy to see where you are in the script.

Honestly if you are doing anything with the…

Read more

0 comments, 422 reads

Posted in Ed Elliott's Sql Developer Blog on 25 November 2015

Issues and opinions on the PASS anti-harassment policy (#sqlpass)

PASS just published an anti-harassment policy reminder, quickly followed by a  blog by Wendy Pastrick (about a bad experience at last month’s conference, and why it took a while to report it). We’ve had some conversation on Twitter about it all, and a couple of jokes, and some back and…

Read more

4 comments, 691 reads

Posted in SQL Awesomesauce on 25 November 2015

Test if a File Exists with Powershell

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

Awhile back I wrote a PowerShell script (PoSh) to download the SQL Saturday XML files used for the Guidebook application. These contain a bunch of the information that… Read more

4 comments, 638 reads

Posted in The Voice of the DBA on 25 November 2015

Resolved: A Duty to Act

If you are a member of PASS, you probably got an email from our President, Thomas LaRock.  I interpreted his email as essentially a reminder that when attending PASS events we should all be professional and responsible for our actions.   The email was very well written and wasn’t pointed towards… Read more

5 comments, 377 reads

Posted in John Morehouse | Sqlrus.com on 25 November 2015

Older posts