Black Friday Wishes
Today Steve asks if there are things you might wish your employer would do for you this holiday season.
BMWs SQL Server Enterprise Architect on the challenges of monitoring
Tony Maddonna, BMW’s SQL Server Enterprise Architect, writes about the challenges of database monitoring. Drawing on experiences throughout his career, this blog covers manual vs third party, proactive monitoring in dev and test, and managing expectations of the cloud. To learn more, and read his tips on how to build a business case for third-party tooling, check out his blog.
Continuous deployment at scale
More organisations are adopting DevOps, but what happens as the codebase grows? In this article, Siddharth Rao gives advice on how to implement continuous deployment at scale.
Exporting Stored Procedure Results to a Table
A quick trick from Pamela Mooney for getting results from a proc into a table.
Monitoring SQL Server Instance Version and Builds with PowerShell
In this article we continue our PowerShell monitoring series with scripts that check the current version and build for all SQL Server instances in your environment.
Win a three-month subscription to Pluralsight
Redgate is giving you the chance to win a three-month subscription to Pluralsight (the technical skills training platform) in this month’s forum competition. To enter, simply share ‘how SQL Compare has helped you’.
Getting Informative SQL Agent Notifications from Failed SSIS Packages
Getting informative error messages when something goes wrong with an SSIS package is critical, especially if you are not in front of your computer.
Exploring errors to reveal unauthorized information
Database administrators can never stop thinking about security. In this article, Fabiano Amorim shows how data can be revealed through error messages when views are used to secure rows.
Blogs
Designing a Storage Load Test for SQL Server
I’ve been doing storage load tests for SQL Server for a long time, both...
Questions and Answers from Running a Local LLM
By Steve Jones
I had a few random questions from my Running a Local LLM on Your...
Overview of Claude AI Models: Which One to Choose?
By Arun Sirpal
For those entering the AI space whether professionally or personally I wanted to give...
Forums
A question about how to store the address in the database
I have an app that has an address field on the customer and the...
SSIS package failing intermittently on last Excel Component
Good Afternoon, I have a Job which "fires" off an SSIS package (that is...
T-SQL in SQL Server 2025: JSON_ARRAYAGG
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Question of the Day
Multiple Sequence Values
How do I easily get the next 12 sequence values from a sequence object?
See possible answers