Redgate is offering a 1-day public workshop for anyone who’s interested in automated deployments for SQL Server databases. In the hands-on exercises, you’ll learn how to deploy with PowerShell and Octopus Deploy, work with NuGet packages, handle unexpected changes in your production database (database drift), test your changes with dry run releases, add review and rollback steps, check your deployments have worked, and how to fix things if your deployment fails. Find a workshop near you.

CONCAT and STUFF Functions in SQL Server 2012

by Additional Articles

Database Journal

CONCAT()

The difference between the CONCAT function and the STUFF function lies in the fact that CONCAT allows you to append a string value at the end of another string value whereas STUFF allows you insert or replace a string value into or in between another string value. Read on to learn more about these functions and their real life usage.

Is It Time to Upgrade?

by Steve Jones

SQLServerCentral.com

Editorial

Today Steve Jones looks at the reasons for upgrading, or not, from SQL Server 2005.

SQLServerCentral Runs sp_Blitz - The Future

by Steve Jones

SQLServerCentral.com

After examining the SQLServerCentral servers using the sp_Blitz™ script, Steve Jones now looks at how we will use the script moving forward.

Microservices in Promise and Practice

by Additional Articles

SimpleTalk

microservices

Are microservices the cure for the ague of monolithic applications, or do they bring their own problems with them that monolithic architectures have circumvented? Are they capable of delivering applications that are easier to maintain and develop? How can they avoid the failings of service-oriented architectures? Once more, Robert Sheldon gets to the heart of the technical issues.

Byte Me: Slave Drive

by Bob Lang

SQLServerCentral.com

Byte Me

Technical lead.

Automated database deployment workshop: London, UK

by Press Release

Redgate

Events

Join Redgate on May 20th for a 1-day public workshop in London. This event is for anyone who’s interested in automated deployments for SQL Server databases. You'll learn how to: Deploy databases using Redgate's DLM tools; Assess the different requirements of production and non-production deployments, and; Handle database administration tasks, such as backups and security, for automated deployment. Register while space is available.

Disaster Recovery and Big Data

by Additional Articles

Database Journal

Disaster Recovery (DR)

Big data applications are not usually considered mission-critical: while they support sales and marketing decisions, they do not significantly affect core operations such as customer accounts, orders, inventory, and shipping. Why, then, are major IT organizations moving quickly to incorporating big data in their disaster recovery plans?

Tips to Optimize Your SQL Statements - Part 1

by Brian Ellul

SQLServerCentral.com

Don't blame SQL Server if your SQL Statements perform badly! But where do you start to investigate the problem? This article is a primer on were to start looking when your SQL runs slowly.

Mobile BI with SQL Server Reporting Services

by Additional Articles

SimpleTalk

Reporting Services (SSRS)

For users to get the information they need from mobile reports, we frequently have to tailor the way we design those reports to the characteristics of the target device. Adam Aspin demonstrates some of the ways that we can deliver easy-to-use Business Intelligence to tablets and smartphones using Reporting Services.

Automated database deployment workshops

CONCAT and STUFF Functions in SQL Server 2012

Is It Time to Upgrade?

SQLServerCentral Runs sp_Blitz - The Future

Microservices in Promise and Practice

Byte Me: Slave Drive

Automated database deployment workshop: London, UK

Disaster Recovery and Big Data

Tips to Optimize Your SQL Statements - Part 1

Mobile BI with SQL Server Reporting Services

Blogs

Designing a Storage Load Test for SQL Server

Questions and Answers from Running a Local LLM

Overview of Claude AI Models: Which One to Choose?

Forums

A question about how to store the address in the database

SSIS package failing intermittently on last Excel Component

T-SQL in SQL Server 2025: JSON_ARRAYAGG

Question of the Day

Multiple Sequence Values