Weekly Roundup–SQL Server and Related News
Welcome to this weeks weekly round up of links, SQL Server and other news. Its been a busy week on...
2016-04-05
408 reads
SQL Server PerfMon Counters Not Listed in dm_os_performance_counters
Had an issue with a new Azure VM install of SQL Server, but have had this issue in other, older...
2016-04-05
1,491 reads
Locking sa
When I started working with SQL Server, the sa account was “the” account used for admin operations. This was the...
2016-04-04
1,044 reads
Don't Use Delimiters In Your Object Names!
It started with a failed backup status check:
Msg 50000, Level 16, State 1, Line 73
** Backups listed in this file...
2016-04-04
2,285 reads
MongoDB – Calculating Document Size
We can get the size of a document is by using the shell’s Object.bsonsize() function.We pass the object_id of the document...
2016-04-04
539 reads
#SQLNewBlogger–Adding Local Accounts
What do you do if you need a process running under Local Service to connect to your SQL Server? Most...
2016-04-04
652 reads
Monday Morning SQL Break – April 4, 2016
It’s Monday time for this week’s weekly blog and twitter round-up for last week. If you haven’t already, follow me...
2016-04-04
461 reads
Complex/Conditional ORDER BYs
Typically it’s considered best to run your queries without an ORDER BY and let the application do any sorting needed....
2016-04-04
482 reads
Use PowerShell to script existing Availability Group creation scripts!
Scripts that write scripts! One of my favorites!
So last night I was up working on an issue with an Availability...
2016-04-07 (first published: 2016-04-04)
7,611 reads
SSC Editorial: Is Powershell Intimidating?
Is Powershell intimidating? It’s an interesting question, though perhaps unfair – TSQL can be intimidating when you first start out too....
2016-04-04
526 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