Latest Blog Posts
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?
User: Oh noes! The web sites down!
One quick call later
Developer: Hmm, it looks… Read more
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 in Azure SQL Databases V12 only. Let’s see how that works.
Filtering and Blocking
The… Read more
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
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 SSDT Dev Pack adds a menu…
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)
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
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
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
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
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 ScriptDom so here is another tool…
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…
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
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
I wrote Early Adopters for SQLServerCentral after seeing a comment elsewhere that basically lumped all MVP’s into one category as ‘early adopters’. There’s some truth to that, but not all MVP’s are early adopters and not all early adopters are MVP’s. What interested me more was the attitude, that… Read more
You’re back? Good. So, her article got me… Read more