Querying SQL and Windows Version Info with T-SQL
Just a quick one today - I see questions sometimes about polling Windows information from inside SQL Server itself. There are...
2017-04-10 (first published: 2017-03-24)
31,911 reads
A Note on Configuring HP SSD’s
Sharing this without a supporting link, might help someone. During a recent move from SAN to local SSD the storage...
2017-03-24
434 reads
Answer to “Could not locate file ‘xxx_Log’ for database ‘xxx’ in sys.database_files”
This blog post is a form of resolution to the issue of not being able to shrink a transaction log...
2017-03-24
232 reads
Why did my SQL Server database just go offline?
Note: This post contains a video clip where I show quirky behaviour of the scripted offline task. Personally I rarely...
2017-03-24
385 reads
Configuring KDIFF With GitHub
Posting this mostly in case I need it again. I needed a merge tool for Git, Kdiff is free and...
2017-04-12 (first published: 2017-03-23)
878 reads
U-SQL Defined
Azure Data Lake Analytics (ADLA) is a distributed analytics service built on Apache YARN that allows developers to be productive immediately...
2017-03-23
502 reads
vNext has AG
Now vNext SQL Server on Linux supports Availability Group HA/DR functionality supported. https://blogs.technet.microsoft.com/dataplatforminsider/2017/02/17/sql-server-on-linux-mission-critical-hadr-with-always-on-availability-groups/
2017-03-23
322 reads
SQL Agent on vNext – Linux
SQL Server is running on Linux now with SQLPAL- SQL Platform Abstraction Layer(SQLPAL) -it will work as a virtual Windows server on...
2017-03-23
432 reads
Updated SQL Server on VMware Best Practices Guide
I am proud to announce that we contributed to the latest revision of the Microsoft SQL Server on VMware best practices...
2017-04-10 (first published: 2017-03-23)
2,652 reads
Illustration of an example availability monitoring service Using PowerShell and SQL
This article discusses a simple solution of how to monitor SQL service availability across multiple servers and reporting. To build...
2017-03-23
388 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