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
154 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,581 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,107 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,872 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
167 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
630 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
131 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
567 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,747 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,636 reads
Blogs
T-SQL Tuesday #196 – Two risky career decisions I made
By DataOnWheels
The T-SQL Tuesday topic this month comes James Serra. What career risks have you...
T-SQL Tuesday #192: What career risks have you taken?
This T-SQL Tuesday is hosted by the one and only James Serra – literally...
T-SQL Tuesday #196: Taking Risks
By Steve Jones
This month we have a new host, James Serra. I’ve been trying to find...
Forums
OPENQUERY Flexibility
Comments posted to this topic are about the item OPENQUERY Flexibility
A Full Shutdown
Comments posted to this topic are about the item A Full Shutdown
Going Native with Fabric Spark Pools: The Fabric Modern Data Platform
Comments posted to this topic are about the item Going Native with Fabric Spark...
Question of the Day
OPENQUERY Flexibility
Which of these are valid OPENQUERY() uses?
See possible answers