Speaking at SQL Saturday Boston 2023
I’m heading to Boston next week for SQL Saturday Boston 2023. I went to this event last year and I’m glad to be going again. It’s a great event,...
2023-10-03
10 reads
I’m heading to Boston next week for SQL Saturday Boston 2023. I went to this event last year and I’m glad to be going again. It’s a great event,...
2023-10-03
10 reads
Last week we discussed advantages of recompilation in Common Mistakes in SQL Server – Part 2. This week in this article Common Mistakes in SQL Server - Part 3 I...
2023-10-02
28 reads
Introduction
Power Query is a versatile tool found in both Power BI and Excel, facilitating data transformation and manipulation. Despite its efficiency in numerous data tasks, managing decimal values can...
2023-10-02 (first published: 2023-09-07)
362 reads
Microsoft SQL Server, like most modern database systems, can convert a query into a set of parallel instructions to improve efficiency. This is map-reduce before map-reduce was a popular...
2023-10-02 (first published: 2023-09-06)
439 reads
While working with WordPress and MySQL databases, users might occasionally encounter import errors during site migration. These errors may compromise the integrity of the database and disrupt the site’s...
2023-10-02
162 reads
I’m happy to announce that I will be speaking at SQL Saturday Boston on October 14th, 2023. This year’s session is Answering the Auditor’s Call with Automation
As DBAs, we’re...
2023-10-02
11 reads
ghough – n. a hollow place in your psyche that can never be filled; a bottomless hunger for more food, more praise, more attention, more affection, more job, more...
2023-09-29
41 reads
Working with various Flyway configuration options used to be a pain since they were either CLI parameters or in a text files. We’ve made editing these easier in Flyway...
2023-09-29 (first published: 2023-08-25)
132 reads
I found myself in a situation where I needed to modify temporal tables. We do this outside business hours because we don’t want clients changing data while versioning is...
2023-09-29 (first published: 2023-09-05)
584 reads
I have the honour of hosting this month’s T-SQL Tuesday. In case there’s any doubt that’s for October 2023, I’m posting this invitation a little early as I got...
2023-09-29
23 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...
Hi. I hope someone can give some useful suggestions. My workplace have a suite...
The SQLPS.exe file has gone AWOL on 2 of my 4 SQL servers, ie,...
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;