SQL Server Phantom Reads
With Halloween around the corner what better topic to discuss than phantom reads. A phantom read occurs when rows have...
2017-11-08 (first published: 2017-10-26)
1,623 reads
SQL Server – Concat_WS function in SQL Server 2017
Hello friends, Please find the link for my new article at below url – https://social.technet.microsoft.com/wiki/contents/articles/44327.sql-server-concat-ws-function-in-sql-server-2017.aspx Regards Kapil
2017-10-26
560 reads
IT Dev Connections 2017
The IT Dev Connections conference was in San Francisco, CA this week. While I did not spend any time as a tourist, I did mingle with attendees and speakers....
2017-10-25
12 reads
Configuring a Subscription to an Azure SQL
This is my first post where I utilize an hybrid cloud, item that I personally find very interesting and useful so expect more posts like this to come.Microsoft Azure...
2017-10-25
27 reads
Necessity is the Mother of Automation
If you have worked with me or are a frequent reader of my blogs or a frequent attendee of my...
2017-10-25
503 reads
Repair a Windows Server 2016 installation
This is more for my benefit in the future, but hopefully it can help someone else too. We recently had...
2017-10-25
4,494 reads
PASS Summit and Redgate Software
Next week is the PASS Summit. I’m so excited about it I could pop. Part of why I’m excited is...
2017-10-25
322 reads
Synchronous VS Asynchronous Statistics Updates
One of the things I’ve been able to implement to help with performance is changing from Update Statistics Synchronous to...
2017-11-07 (first published: 2017-10-25)
1,996 reads
Basic FORMATting– #SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2017-10-25
1,184 reads
Schema only backup or schema only DB copy
Every now and again you have a database where you don’t necessarily need the data. It can easily be re-loaded...
2017-10-25
1,170 reads
Blogs
The Book of Redgate:A Prehistory
By Steve Jones
I’ve covered the values in a number of previous posts on the Book of...
Evidence-bound: what AgentDBA will and won’t link
By Arun Sirpal
When the evidence names the database, it says so. When it doesn’t, it stops....
Prep data for AI vs. Fabric Data Agent Instructions: What Goes Where?
By James Serra
Making Data AI-Ready, Part 3 (This is the final article in a three-part series...
Forums
Four Rules for Adding AI Without Breaking What Already Works
Comments posted to this topic are about the item Four Rules for Adding AI...
SQL Server 2025 section missing?
Hello, the title says it all. Is the SQL Server 2025 section missing?
A design question in a parent child relationship
I am not sure which is the best way to proceed. I have parent...
Question of the Day
Hyperscale Replicas III
In an Azure SQL Database Hyperscale Edition, how many named replicas can be configured?
See possible answers