FOR XML PATH using node tests in column aliases
I've used SQL to generate countless blobs of xml over the years and one feature that I have come to...
2011-12-20 (first published: 2011-12-15)
8,817 reads
Blog Posts
Full Load. Incremental Load. Whaaat?
Back when i was in school, me and a bunch of friends used to hangout at a diner. The diner was...
2011-12-20
6,651 reads
How I Got Started in Software Development-A Tribute to Ed
A tribute is an expression of gratitude or praise. As I head into this holiday season I wanted to express...
2011-12-20
510 reads
Mark a Disk Partition as Inactive
If you are like me then you like to reinstall Windows on your laptop every few months to keep things...
2011-12-20
897 reads
Modifying SQL Server Synonyms
One task that often needs to be done when migrating a database to production for the first time is to...
2011-12-20
1,356 reads
Public Role and Security
A good rule of thumb with the public role is to leave it be. Do not add permissions to this role. Add permissions on a per database and per...
2011-12-20
15 reads
SQL Server 2012 – new conversion functions
With SQL Server 2012 comes a new set of conversion functions, that will certainly help doing type casts and conversions...
2011-12-20
1,190 reads
SQLSaturday Goes International
Looking at 2011 and the planned events so far for 2012 it’s easy to see that SQLSaturday is starting to...
2011-12-20
654 reads
Contracting is business not employment: Read the small print
This post is about a contracting in UK. Some of terms mentioned here will not mean a great deal to...
2011-12-19
1,193 reads
Creating a Service Master Key in SQL Server
The basis for all the encryption in SQL Server is the Service Master Key, which is the top of the...
2011-12-19
4,512 reads
Blogs
Are you getting value from your reporting?
By ChrisJenkins
Do you spend so long manipulating your data into something vaguely useful that you...
The Book of Redgate: SQL Server Central
By Steve Jones
It was neat to stumble on this in the book, a piece by me,...
Git forked
Forgive me for the title. Mentally I’m 12. When I started my current day...
Forums
Microsoft Security Changes and SQL Server
Comments posted to this topic are about the item Microsoft Security Changes and SQL...
Expanding into Print
Comments posted to this topic are about the item Expanding into Print
Downtime Caused by the Postgres Transaction ID Wraparound Problem
Comments posted to this topic are about the item Downtime Caused by the Postgres...
Question of the Day
The String Distance I
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('Steve', 'Stan')
Assume preview features are enabled. See possible answers