Need to run multiple scripts against multiple servers?
Let Chris Yates give you a quick overview of Redgate's SQL Multi Script to learn more about a quick and easy way to solve the problem.
2017-01-23
3,164 reads
Articles
Development Delusions: That it is Enough to Build a Better Mousetrap
You've written a superb, clever, application that you are trying to encourage your colleagues to use. They're not interested. Why? You've neglected the documentation. Surely, the saying goes 'Build a better mousetrap and the world will beat a path to your door'? Nope, not without comprehensive and complete documentation and marketing, it won't. Documentation is the secret of ensuring that good software will succeed.
2017-01-20
3,650 reads
Keeping Fact Tables Online while Loading via Partition Switching
Provides overview of steps that can be used to keep fact tables online during loading process.
2017-01-19
5,046 reads
What's New in Reporting Services 2016 Service Pack 1
SQL Server 2016 was been released the first of June 2016, but at the recent Connect event Microsoft announced the first service pack. Aside from numerous fixes, this service pack also comes packed with some notable enhancements for Reporting Services. Koen Verbeeck gives you an overview of these enhancements.
2017-01-19
5,038 reads
Five Useful SQL Server Management Practices
This article outlines five SQL Server capabilities you can use to enhance your efficiency as a DBA.
2017-01-18
3,772 reads
Put your Database under Source Control
This article will walk you through a demostration on linking your DB to SubVersion with RedGate SQL Source Control.
2017-01-18
4,667 reads
SQL Server v.Next : STRING_AGG() performance
Aaron Bertrand takes an initial look at the performance of a new function, STRING_AGG, in SQL Server v.Next CTP 1.1.
2017-01-18
3,620 reads
SQL Server in Azure Virtual Machines - Performance Optimizations
When deploying SQL Server in an Azure virtual machine, you can take advantage of several Azure Infrastructure-as-a-Service (IaaS) features that enhance performance of the SQL Server database engine. This article explores a couple of these enhancements, with a particular focus on increased I/O throughput facilitated by the Solid State Drive (SSD) storage available on most Azure virtual machines (VMs).
2017-01-17
5,354 reads
A Possible Alternative to SQL UNPIVOT
Understand how to use the SQL UNPIVOT statement and then an equivalent using XML and XPath Querying in SQL Server.
2017-01-16
5,022 reads
Free Webinar – Database DevOps Demo
Learn how to extend DevOps practices to SQL Server databases in our free demo webinar on January 17th. Microsoft Data Platform MVP, Steve Jones will demonstrate how Redgate’s database automation tools plug into Git, Jenkins & Octopus Deploy. Learn how to branch and merge with SQL Source Control then automate the build and deployment of changes with DLM Automation. Register now.
2017-01-16 (first published: 2017-01-11)
5,646 reads
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