Automating Replication On Your Server
If you use replication, you have had the situation occur where you had to restore a replicated database. You’ve have doubtless been paged to restore a replicated database. You...
2019-07-31
59 reads
If you use replication, you have had the situation occur where you had to restore a replicated database. You’ve have doubtless been paged to restore a replicated database. You...
2019-07-31
59 reads
2019-07-22
10 reads
Before we approached our last major SQL Server upgrade, I was curious about what might break. Yes, I had used the DEA to check our code against deprecated or...
2019-07-19
42 reads
Why do I take pictures of screens at conferences? Let me count them up for you! Read on...
2019-07-05
96 reads
It's SQLIntersection time, and also time to meet a new member of the family. He's old enough for social media, though...
2019-06-07
13 reads
I was recently asked in a Service Broker class that I was teaching why we would use it. Good question! Read on....
2019-05-15 (first published: 2019-05-03)
1,247 reads
Dread the drop no more! Part 2 of the rename/drop process.
2019-05-06 (first published: 2019-04-22)
440 reads
Oh, the dreaded string search (on an entire instance). What to do?
2019-04-11
178 reads
Ever tried to drop a user/login, only to find that they owned a schema? Here's how I do it...
2019-04-08
150 reads
Let's be honest - some of our best learning experiences come from our mistakes. Here's one of mine....
2019-04-05
11 reads
By Steve Jones
I needed to test a striped backup, so I decided to ask the AI’s...
By gbargsley
In SQL Server environments where transactional replication runs alongside Always On Availability Groups (AGs),...
Disable the sa login in SQL Server (and sleep better)If you run SQL Server...
Comments posted to this topic are about the item Create an HTML Report on...
The SQLPS.exe file has gone AWOL on 2 of my 4 SQL servers, ie,...
Comments posted to this topic are about the item Be Wary of Data
You have a table [dbo].[orders] without a Clustered Index (Heap). The table does not have any other nonclustered indexes! You rund the following command in Read Committed Isolation Level:
SELECTo_orderdate, o_orderkey, o_custkey, o_storekey FROMdbo.orders WHEREo_orderkey = 3877;