Random Blog Post Challenge
OK, for no particular reason at all or maybe because I had too much food at lunch or just because...
2017-03-02
396 reads
The Psychology of Value
J.C. Penney is one of the oldest and most storied retailers still in existence in the United States. For years,...
2017-03-02
381 reads
Tempdb settings in SQL Server 2016
A nice little error log feature that I noticed in SQL Server 2016 regarding tempdb. Tempdb, a system database in...
2017-03-02
415 reads
Do you need a degree to be DBA?
This question gets asked a lot and reoccurs over the years. Do you need a degree to be DBA? I have seen...
2017-03-02
434 reads
Power BI Hands-On Workshops in April, 2017
During the month of April, I will be delivering three full-day Power BI hands-On workshops. Each of these events will...
2017-03-02
363 reads
ERRORLOG records max out at 2049 characters
Stupid question… what's the schema of a table with sys.sp_readerrorlog output? Well you might be surprised if you're used to...
2017-03-02
139 reads
SSDT Deploy / Publish Performance
Publishing dacpac's is a little bit of a pain when you have multiple databases, it can easily start to take...
2017-03-01
1,268 reads
SSDT Deploy / Publish Performance
Publishing dacpac's is a little bit of a pain when you have multiple databases, it can easily start to take minutes to hours to deploy changes depending on how...
2017-03-01
12 reads
SSDT Deploy / Publish Performance
Publishing dacpac’s is a little bit of a pain when you have multiple databases, it can easily start to take...
2017-03-01
14 reads
SSDT Deploy / Publish Performance
Publishing dacpac’s is a little bit of a pain when you have multiple databases, it can easily start to take...
2017-03-01
39 reads
Blogs
T-SQL Tuesday #202 Invitation: That One SQL Server Outage You’ll Never Forget
I am excited to host T-SQL Tuesday for the first time. I want to...
A Daily Report from Claude
By Steve Jones
Redgate had some Claude training recently, which I went through as my knowledge has...
A New Word: Gnossienne
By Steve Jones
gnossienne– n. the awareness that someone you’ve known for years still has a private...
Forums
Practical Ways to Approach SQL Server Problems and Case Studies
Working with SQL Server can involve more than just writing queries. Understanding database design,...
Measuring Productivity
Comments posted to this topic are about the item Measuring Productivity
Importing Excel files into SQL Server using DuckDB and Python
Comments posted to this topic are about the item Importing Excel files into SQL...
Question of the Day
Tracking All the Queries
I have 3 instances of a brand new long running query that are executing on a SQL Server 2025 instance. Query store is enabled. One of the queries is killed by the administrator, one is cancelled by the user. The other runs to completion. How many rows are in Query Store for this query?
See possible answers