This year, 2020, has been crazy. What started as a normal year for me, including a sabbatical, turned into a crazy, shutdown, lockdown, stuck at home pandemic around the...
2020-11-17 (first published: 2020-11-10)
222 reads
I was watching the GroupBy talk the other day and noticed that Cláudio Silva was using arrays, or what appeared to be arrays, in his talk. That was an...
2020-11-18 (first published: 2020-11-09)
370 reads
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2020-11-09
4 reads
I can’t remember where I saw this, but it made an interesting Question of the Day: select * from Sales where Profit !< 10000; I had never seen anything...
2020-11-09
54 reads
The PASS election slate was released for 2020. The candidates and their statements are:: Hamish Watson (@thehybriddba) Joey D’Antoni (@jdanton) – Community Matters–Why I’m Running for the PASS Board...
2020-11-07
38 reads
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2020-11-06
26 reads
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2020-11-05
16 reads
This is a quick blog to help me remember what is going on with the Data Masker product. This is for the SQL Server version, but I believe the...
2020-11-04
31 reads
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2020-11-04
16 reads
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2020-11-03
13 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;