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, 621 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, 610 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,214 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,254 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, 697 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, 853 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, 735 reads
Posted in Ed Elliott's Sql Developer Blog on 27 November 2015
Find duplicate indexes in SSDT
0 comments, 7 reads
Posted in Ed Elliott's Sql Developer Blog on 27 November 2015
Find duplicate indexes in SSDT
0 comments, 7 reads
Posted in Ed Elliott's Sql Developer Blog on 27 November 2015
SQL Server – DROP IF EXISTS in SQL Server 2016
0 comments, 893 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, 994 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, 648 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, 212 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,641 reads
Posted in The Smiling DBA on 26 November 2015
Steps to create SQL database at Azure
0 comments, 663 reads
Posted in Kapil Blogs on 26 November 2015
Complete DAX Function Reference
9 comments, 732 reads
Posted in SQL Server BI Blog on 26 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, 639 reads
Posted in Ed Elliott's Sql Developer Blog on 25 November 2015
Convert select statements in scripts into Inline-TVFs automatically
0 comments, 7 reads
Posted in Ed Elliott's Sql Developer Blog on 25 November 2015
Convert select statements in scripts into Inline-TVFs automatically
0 comments, 7 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, 687 reads
Posted in Ed Elliott's Sql Developer Blog on 25 November 2015