Drop and Recreate all Synonyms
Had a quick job the other day restoring a pair of databases under different names which is all straight forward...
2014-10-27
151 reads
Art
Convert UK Postcode to Latitude/Longitude/Northing/Easting using SQL CLR
Just a quick post this time. I had a requirement to convert a small number of UK based postcodes to...
2014-09-25
2,406 reads
Convert UK Postcode to Latitude/Longitude/Northing/Easting using SQL CLR
Just a quick post this time. I had a requirement to convert a small number of UK based postcodes to...
2014-09-25
1,046 reads
Using indexed views on ANY core SQL server edition
I was having a discussion the other day and was quite surprised to hear that there still appears to be...
2014-09-02 (first published: 2014-08-26)
7,858 reads
Using indexed views on ANY core SQL server edition
I was having a discussion the other day and was quite surprised to hear that there still appears to be...
2014-08-26
157 reads
Thank You SQLBits!
Just a very quick post to say thank you to all the organisers, speakers, helpers, sponsors, venue staff, caterers, party...
2014-07-25
624 reads
Thank You SQLBits!
Just a very quick post to say thank you to all the organisers, speakers, helpers, sponsors, venue staff, caterers, party...
2014-07-25
127 reads
Time for a change in career
A few months back I made the decision to leave the relative comfort and security of my permanent role and...
2014-07-09
563 reads
Deferred-drop tipping point
I was intrigued by the deferred-drop feature that has been inside SQL since SQL Server 2000 SP3 after watching one...
2014-05-31
1,693 reads
Most important feature of SQL 2014
There are a whole raft of cool new features in 2014 including things like In-Memory OLTP, increased Azure integration/options and...
2014-04-29
1,616 reads
Blogs
Connect With More Clients: Our Partner Directory Has Arrived
By Rob Sewell
The partner directory connects your agency with new customers.
Can You See Who Forced a Plan
I had an excellent group of people in Gothenburg Sweden when I taught there...
Monday Monitor Tips–Finding CUs for My Instance
By Steve Jones
How can I quickly get a CU patch for a system that’s out of...
Forums
GIT Configuration and Automated Release for Azure Data Factory
Comments posted to this topic are about the item GIT Configuration and Automated Release...
Reliable Provider of 95% Accurate India Phone Numbers for Marketing
If you’re looking for a trustworthy source of India phone numbers for your marketing...
Concat Addition
Comments posted to this topic are about the item Concat Addition
Question of the Day
Concat Addition
What is the result of this code?
SELECT CONCAT(1, 2, 3) + 4See possible answers