2023-04-29
134 reads
Database Weekly
AI Concerns
With the ChatGPT and AI crazy sweeping through the media, Steve has a few thoughts on what this might mean for data professionals.
2023-04-22
197 reads
Moore's Law: Navigating the Pace of Technological Change
Technology has always been a driving force in shaping our world, propelling us forward into new realms of innovation and progress. One of the most famous concepts in technology is Moore's Law, which suggests that the number of transistors on a microchip doubles approximately every two years, leading to exponential increases in computing power. In […]
2023-04-15
150 reads
The Top SQL Server Engine Errors
The SQL Server Support team published the top errors they see in calls. Steve has a few comments on what they're doing to help customers.
2023-03-04
535 reads
Consider Sharing Your Knowledge At User Groups and Conferences
The first time I spoke in front of a group of people over 20 years ago about a programming topic, I was scared to death. I could barely sleep the night before, obsessing about the material and practicing it repeatedly. When I finally did sleep, it felt like minutes before I awoke, and it was […]
2023-02-25
80 reads
The Home Password Cracker
Passwords cracked in under an hour using modern hardware have Steve shaking his head.
2022-10-22
406 reads
New Cloud Licensing Limits
New licensing rules are coming for using your SQL Server licenses in the cloud.
2022-09-03
187 reads
The Case for Patching
Recently I was testing a feature in SQL Server on 2017 and 2019. There was supposed to be an improvement across versions, but I didn't see it. Then I realized that I was on SQL Server 2019 CU 2 on my laptop, and the current CU is 17. I took a few minutes to download […]
2022-08-20
152 reads
SQL Standard Confusion
The whole universe, the well-guarded people—may they all query databases together in a single language!
2022-08-13
261 reads
Three Mile Island And Your Databases
Grant takes a few lessons for database DR from a nuclear accident in the US.
2022-08-06
99 reads
Blogs
T-SQL Tuesday #193 – A Note to Your Past, and a Warning from Your Future
By DesertDBA
I haven’t posted in a while (well, not here at least since I’ve been...
Keeping MS Docs Up to Date
By Steve Jones
One of the things that I like about the SQL Server docs (MS Learn...
Patch Tuesday – Where to get more information
By Brian Kelley
For a number of years I have subscribed to Randy Franklin Smith's Patch Tuesday...
Forums
Pivot but preserve all rows on Aggregate column
Hello Need help in pivoting this data set, the Pivot takes MIN/MAX on a...
any reason to avoid asking ssis to extract files from ftp
hi we have to replace talend which generally was used to move files. talend's...
MAX_DISPATCH_LATENCY in extended event , is not clearly explained in msdn.
hi, i have checked reducing it increasing it but could not get any...
Question of the Day
What is the PRODUCT
In SQL Server 2025, what does this return?
CREATE TABLE Numbers ( n INT) GO INSERT dbo.Numbers ( n ) VALUES (1), (2), (3) GO SELECT PRODUCT(n) FROM dbo.NumbersSee possible answers