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,978 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
435 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
234 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
386 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)
883 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
505 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
323 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,654 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
The Book of Redgate:A Prehistory
By Steve Jones
I’ve covered the values in a number of previous posts on the Book of...
Evidence-bound: what AgentDBA will and won’t link
By Arun Sirpal
When the evidence names the database, it says so. When it doesn’t, it stops....
Prep data for AI vs. Fabric Data Agent Instructions: What Goes Where?
By James Serra
Making Data AI-Ready, Part 3 (This is the final article in a three-part series...
Forums
Four Rules for Adding AI Without Breaking What Already Works
Comments posted to this topic are about the item Four Rules for Adding AI...
SQL Server 2025 section missing?
Hello, the title says it all. Is the SQL Server 2025 section missing?
A design question in a parent child relationship
I am not sure which is the best way to proceed. I have parent...
Question of the Day
Hyperscale Replicas III
In an Azure SQL Database Hyperscale Edition, how many named replicas can be configured?
See possible answers