SQL Server Community Activities under Surat User Group
I am very pleased to announce that I will be speaking about SQL Server Storage Structure, Level 100 session on...
2016-01-20
344 reads
T-SQL Tuesday #74: Be the Change Round-up
Thanks to everybody that participated in this month’s T-SQL Tuesday. A big thanks to everyone who wrote a participating blog...
2016-01-20
666 reads
Change Availability Group Endpoint Port
Let’s say you have a port conflict and need to change the port on your Availability Group endpoint. How can...
2016-01-19
1,738 reads
New SQL Blogging Challenge
I recently came across Tim Ford’s (B|T) challenge to the technical blogging community. The challenge is to write one introductory...
2016-01-19
410 reads
Stop using Task Manager to check SQL’s memory usage!
There’s two fairly common questions I see on the forums around SQL Server’s memory usage. Either the question asks why...
2016-01-19
2,020 reads
Shrinking Database Data Files
Normal DBAs will sum up shrinking a database data file in one word: NO! I’ll talk to you about this subject because I’m not normal. Still, my goal is that...
2016-01-19
49 reads
Shrinking Database Data Files
Normal DBAs will sum up shrinking a database data file in one word: NO!
I’ll talk to you about this subject because...
2016-01-19
1,701 reads
How to Solve the Tail Insert Problem
In the previous post, we talked about when you should use identity/sequence as a clustered index key and when it’s...
2016-01-19
1,351 reads
Advent of Code – Day 1 – Parsing a variable
I have been following the series of posts written by my friend and SQL MCM Wayne Sheffield on some TSQL...
2016-01-19
277 reads
Name Your Defaults So SQL Server Doesn't
Something in SQL Server that isn’t always obvious to beginners is that when you create a default value for a column on a table, SQL Server creates a constraint...
2016-01-19
15 reads
Blogs
Keeping Redshift System Table History Past 7 Days with S3 Tables
Redshift keeps its SYS_* monitoring views for seven days in cluster, which is fine...
Updating the Data API Builder
By Steve Jones
I was updating my session for the Data API Builder (DAB) recently, mostly to...
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...
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