Documenting SQL Server with PowerShell
SQL Server instances are generally poorly-documented. How easily can you tell if something has changed? How easily can you check that there is adequate space for growth? Are you up-to-date with licenses? What errors are happening? Who has accessing the system? Before PowerShell, it was difficult to be on top of all this. Now you can, with the help of Sander's database documenter.
The Math on Automation
Is it worth automating things? Many people say yes, but Steve Jones says it isn't just about time saved.
Comparing string splitting / concatenation methods
Whenever a query is executed in SQL Server, its execution plan, as well as some useful execution data are placed into the plan cache for future use. This information is a treasure trove of metrics that can allow some very useful insight into your server’s performance and resource consumption - Ed Pollack shares some useful queries to start utilizing it.
SQL Server on Linux
There was an announcement last week that SQL Server can run on Linux. And it's coming next year.
Documenting SQL Server with PowerShell: PosH VC
Virtual Chapter meeting, Mar 16, 12pm EST. Documentation is mostly overlooked and only comes up when a problem arises. What if you'd have a tool or method to generate documentation for all your database servers? In this session, Sander Stad will show you show how easy it is to use PowerShell to retrieve information from your servers. He'll detail what can be used to document your servers, how to retrieve the information and what should be documented. In the end you no longer have an excuse not to document your servers.
Sparse Columns in SQL Server : Impact on Time & Space
Erin Stellato (@erinstellato) looks into sparse columns in SQL Server – the changes to space requirements and the impact on the write portion of your workload.
Releasing Databases in VSTS with Redgate SQL CI and Octopus Deploy
You can still do Database Lifecycle Management (DLM) workflows in the hosted version of Team foundation Server (TFS) in Visual Studio Team Services (VSTS) . If you are doing your database development in SSMS, you can use a mix of tools to set up the functionality in VSTS. Jason Crease demonstrates how to build and deploy a simple database into the test environment using SQL CI, SQL Source Control, Octopus Deploy, tSQLt, SQL Cop and SQL Release, all with the minimum of hassle and effort.
Blogs
Why Database AI Agents need Layers?
By Arun Sirpal
Third part in my Ai series with databases. When building AI solutions within the...
Un-Migrating From the Cloud: T-SQL Tuesday #199
By Steve Jones
This month we have a very interesting invitation from Koen Verbeeck. He has hosted...
T-SQL Tuesday #199: Back to the on-prem
It’s the second tuesday of the month, which means T-SQL Tuesday time! This month’s...
Forums
How Do the Experts Become Experts?
Comments posted to this topic are about the item How Do the Experts Become...
Unable to restrict permission
I have 13 restricted views in my EDW DB. 6 of them are created...
Install SQL Scripts via GUI Wizard
Hallo all! My problem is this: I have quite a bunch of TSQL scripts...
Question of the Day
Secure Communications
As of June 2026, what is the best version of TLS to use with SQL Server?
See possible answers