Data Thoughts – T-SQL Tuesday #147 – Upgrade Strategies
G’day, This months T-SQL Tuesday (January 2022) invite is brought to you by Steve Jones – @way0utwest Steve’s asked us to write about “Planning for upgrades“ In the not...
2022-02-08
6 reads
G’day, This months T-SQL Tuesday (January 2022) invite is brought to you by Steve Jones – @way0utwest Steve’s asked us to write about “Planning for upgrades“ In the not...
2022-02-08
6 reads
(NOTE: I have returned to Microsoft and am working as a Solution Architect in Microsoft Industry Solutions, formally known as Microsoft Consulting Services (MCS), where I help customers build...
2022-02-08
57 reads
Want to learn how to set up a PowerShell DBA environment? Here's how to configure it for SQL Server backups. T
2022-02-08
41 reads
This month’s T-SQL Tuesday is about how we look at SQL Server upgrades, hosted by Steve Jones. My experience of SQL upgrades is that they tend to be largely...
2022-02-08
5 reads
When it comes to MySQL and storage you will normally have to decide on 3 options: basic, general purpose v1 or v2. Basic does support up to 1TB and...
2022-02-07
17 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...
2022-02-07
5 reads
Database servers are used for storing vast amounts of data. It is essential to know when any user last used the database. This blog will cov
2022-02-07 (first published: 2022-01-24)
1,342 reads
This is part of a series on my preparation for the DP-900 exam. This is the Microsoft Azure Data Fundamentals, part of a number of certification paths. You can...
2022-02-07
90 reads
A common issue in performance is the lookup, key or RID, but the question frequently asked is, which columns are looked up? You need to know in order to...
2022-02-07 (first published: 2022-01-24)
430 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...
2022-02-04
8 reads
Welcome back, my fellow sleuths, to my mystery-inspired blog series! I’m having a ton...
By Steve Jones
This was one of the original values: The facing page has this text: No...
By Chris Yates
For decades, enterprises have thought about data like plumbers think about water: you build...
Comments posted to this topic are about the item Create an HTML Report on...
Comments posted to this topic are about the item I Love Editorials
Hi everyone I have a 1000 plus line query and I am getting an...
What happens when I run this code:
DECLARE @s VARCHAR(1000) = 'apple, pear, peach' SELECT * FROM STRING_SPLIT(@s, ', ')See possible answers