Explicitly using tempdb with ##tables
I had someone ask me last night if this statement would create a permanent table in tempdb with a strange...
2016-04-25
1,698 reads
Monday Morning SQL Break – April 25, 2016
It’s Monday and if getting a start on the week is as exciting for you as it is for me, it’s...
2016-04-25
515 reads
Upcoming Florida IT Pro Camps
Two IT Pro Camps coming up, register soon!
IT Pro Camp – Jacksonville FL – June 11 at Keiser UniversityIT Pro Camp – Tampa...
2016-05-05 (first published: 2016-04-25)
1,033 reads
Get your SQL Server MCSA without taking the BI exam.
I’m a big fan of certifications as a training exercise. However not everyone has the same interests. With the new...
2016-04-25
1,837 reads
Partition to Filegroup Mapping in SQL Server
Suppose you have a partition function and a corresponding partition scheme in SQL Server. The partition scheme maps each partition...
2016-05-05 (first published: 2016-04-25)
2,838 reads
Speaking at SQLSaturday Pensacola
I’m proud to announce that I will be speaking at SQLSaturday Pensacola on June 4th 2016! This will be my second SQLSaturday event and I’m really excited that I get to...
2016-04-23
10 reads
Speaking at SQLSaturday Pensacola
I’m proud to announce that I will be speaking at SQLSaturday Pensacola on June 4th 2016! This will be my second SQLSaturday...
2016-04-23
403 reads
SQLSaturday Atlanta #521 May 19th & 20th 2016
SQLSaturday events are a pleasure to be a part of whether it involves speaking or volunteering. Volunteering definitely takes more...
2016-04-23
638 reads
Colorblind Awareness and Power BI KPIs
Update: The ability to change the color of a KPI was delivered in August 2016!
Color blindness, or color vision deficiency (CVD)...
2016-04-23
597 reads
Upcoming Webinars
Next week I am participating in two exciting webinars that I want to share with you!
Improve App Uptime: Tips from MVP...
2016-04-22
530 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