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
153 reads
SQL Server Rocks!
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,573 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,094 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,868 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
165 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
627 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
129 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
564 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,739 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,626 reads
Blogs
T-SQL Tuesday #192: SQL Server 2025 Backup Changes
By Steve Jones
I hosted this month, but I decided to put my own entry in as...
Why Databases Still Fascinate Me
By Chris Yates
I get asked a lot about why or how I began working with databases...
Monday Monitor Tips: ServiceNow Integration
By Steve Jones
Earlier this year I visited a customer that was using the Redgate Monitor webhook...
Forums
Transactional Replication
Recently stood up a 2022 Enterprise server. Have 8 publications with subscriptions on a...
Member was not found in the cube when the string
Hey, I've not done a cube for many years but I find myself supporting...
Implementing PostgreSQL with Python for Real-Time Logging and Monitoring
Comments posted to this topic are about the item Implementing PostgreSQL with Python for...
Question of the Day
Identify a Slipstream Installation
I get a new SQL Server instance from my build team. How can I tell if the instance was installed using a slipstream installation later?
See possible answers