What permissions do I need?
Ever wondered how to tell what permissions are required to run a statement or perform a task? Well, sometimes it...
2016-03-16
479 reads
Catch The Enterprise Scripting Workshop in Orange County, Baton Rouge, Albany, or Atlanta this year!
Sean and I have put together our bazillion (read: like 30 combined) years of SQL Server DBA-ing into one big,...
2016-03-16
486 reads
Time Management–Leadership
To many times data professionals flounder in what some call a pool of uncertainty. The countless tasks, tickets, projects, and emails...
2016-03-16
488 reads
Nested Display Folders in SSAS
Recently it was announced that Power BI would now support the SSAS display folders in “exploration mode”. Exploration mode is...
2016-03-16
1,112 reads
SQL Server 2016 RC0–Management Studio install option has disappeared
If you are trying to install SQL Server 2016 RC0 – which I’m sure you are all doing looking at the...
2016-03-16
727 reads
SQL Server articles
Between attending SQL SKILLS immersion events, trying out for the PFE role at Microsoft I have managed to write some...
2016-03-16
189 reads
Analysis Services: Solving Hierarchy Errors of Uniqueness
Multidimensional Cubes provide speed when it comes to retrieving aggregations that are important to business decisions. Being able to slice...
2016-03-16
572 reads
Index Cannot Be Reorganized…
Working diligently as any good DBA might, you have established maintenance routines for each of the SQL Servers under your purview. Then a small problem occurs: Index Cannot Be...
2016-03-16
31 reads
Index Cannot Be Reorganized…
Working diligently as any good DBA might, you have established maintenance routines for each of the SQL Servers under your...
2016-03-16
542 reads
Compression Performance with Low Key Selectivity
[read this post on Mr. Fox SQL blog] When it comes to enabling data compression in SQL Server I suspect most people don’t do a lot of testing as to the impacts of...
2016-03-15
15 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
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...
Tracking All the Queries
Comments posted to this topic are about the item Tracking All the Queries
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