Subscribe to latest posts
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, 547 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, 507 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, 2,115 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…
0 comments, 2,041 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, 575 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, 734 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…
0 comments, 616 reads
Posted in Ed Elliott's Sql Developer Blog on 27 November 2015
SQL Server – DROP IF EXISTS in SQL Server 2016
0 comments, 785 reads
Posted in Kapil Blogs on 27 November 2015
Value can not be null Parameter Name:store TFS WorkItem Store Error
Description:
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)
…
0 comments, 827 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, 554 reads
Posted in SQL Server Rocks! 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, 127 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,481 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, 1,136 reads
Posted in Zora's SQL Tips on 26 November 2015
Steps to create SQL database at Azure
0 comments, 582 reads
Posted in Kapil Blogs on 26 November 2015
Complete DAX Function Reference
8 comments, 621 reads
Posted in SQL Server BI Blog on 26 November 2015
Know More About SQL Server Error number 6401
Introduction
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, 1,221 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…
0 comments, 505 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…
0 comments, 580 reads
Posted in Ed Elliott's Sql Developer Blog on 25 November 2015
Issues and opinions on the PASS anti-harassment policy (#sqlpass)
4 comments, 820 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, 862 reads
Posted in The Voice of the DBA on 25 November 2015