Hands-On Data Analysis With Power BI Desktop at PASS BA Marathon
I’m delighted to announce I’ll give a session at the next PASS BA webinar marathon. The topic of this marathon...
2017-03-06
407 reads
Generating Frequency Table
This week’s blog post is rather simple. One of the main characteristics of a data set involving classes, or discrete...
2017-03-20 (first published: 2017-03-06)
8,487 reads
Quickly Creating Test Users in SQL Server with PowerShell using the sqlserver module and dbatools
One of the most visited posts on my blog is nearly two and half years old now – Add User to...
2017-03-16 (first published: 2017-03-06)
1,733 reads
Monday Coffee 2017-03-06
Last week Docker announced the availablity of Docker Enterprise Edition. The existing version of Docker that I’ve been using has...
2017-03-06
348 reads
The Ebb & Flow of Community Participation
It’s an interesting moment when you discover the SQL community (or any other I suppose). It’s the moment of finding the...
2017-03-05
434 reads
Using dbatools for automated restore and CHECKDB
OK, so if you haven’t heard of the dbatools.io project run by Chrissy LeMaire and company…you’ve likely been living under a rock. I strongly encourage you to check it out...
2017-03-04
10 reads
Using dbatools for automated restore and CHECKDB
OK, so if you haven’t heard of the dbatools.io project run by Chrissy LeMaire and company…you’ve likely been living under a...
2017-03-22 (first published: 2017-03-04)
4,161 reads
Copying data from On Prem SQL to ADLS with ADF and Biml – Part 1
Apologies for the overly acronym-laden title as I was trying to keep it concise but descriptive. And we all know...
2017-03-03
623 reads
DBA 101: File growth
Maintaining a database is an important job of the DBA role. One of the many maintenance tasks is ensuring that...
2017-03-03
473 reads
DBA 101: Unique Constraint vs Unique Index
Designing a rock solid application and database can be difficult. New features and overlapping features mean that you’re able to...
2017-03-21 (first published: 2017-03-03)
3,567 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