Simple Steps in SQL Change Automation Scripting

• by Additional Articles

• Redgate

• Automation
• SQL Change Automation

Phil Factor demonstrates the bare essentials of SCA PowerShell scripts that can form the basis for an automated process for database delivery or help improve your current process.

SQL Server Reporting Services: What I wish I knew when I started?

• by Additional Articles

• MSSQLTips.com

• Reporting Services (SSRS)

In this article Scott Murray covers some lessons learned over the years when working with SQL Server Reporting Services that he wish he knew when he started with SSRS.

The Clear Cloudy Future of Databases

• by Steve Jones

• SQLServerCentral

• Cloud Computing

The future of databases is in the cloud. Maybe not for everyone, but it is becoming a trend.

The Dangers When Changing Database File Names

• by Steve Jones

• SQLServerCentral

• Administration

Recently a friend had an issue with their SQL Server as a result of a file change in their SQL Server database. In this short piece, I want to highlight the dangers of making some changes to an online database that might cause an unexpected outage. This is really the same whether you are changing […]

Refactoring Databases with SQL Prompt

• by Additional Articles

• Redgate

• Refactoring

Louis Davidson demonstrates how SQL Prompt can significantly lessen the pain involved in occasional, 'heavyweight' database refactoring processes, such as renaming modules, tables and columns (Smart Rename), or splitting tables (Split Table).

The Demise of the DBA

• by Additional Articles

• Database Journal

• DBA

Today most of the tasks done by traditional DBAs are performed by artificial intelligence systems or the database itself. With so few important tasks left to perform, are DBAs really needed anymore?

Building Helpful Commit Messages

• by Steve Jones

• SQLServerCentral

• Azure DevOps
• Career
• Git
• Version Control Systems (VCS)

Using a VCS is a core skill, according to Steve. One part of that is learning to write better commit messages.

COLUMNS_UPDATED() and Triggers

• by habib

• SQLServerCentral

• T-SQL

This article will examine how the COLUMNS_UPDATED(...

A MongoDB to SQL Server Migration: Data Typing and Un-nesting

• by Additional Articles

• SimpleTalk

• Database Development

Importing data from one system to another is a common task for database professionals. It’s possible to spend a lot of time figuring out what the schema should be for the target table. In this article, Rodney Landrum demonstrates an interesting solution to automatically figure out the data types and un-nest delimited data.

Download your free copy of the 2019 State of SQL Server Monitoring Report

• by Additional Articles

• Redgate

• SQL Monitoring

Over 800 SQL Server Professionals took part in the State of SQL Server Monitoring survey. Providing insights into how they monitor their SQL Server estates, the technologies they work with, what their biggest challenges are, and what the future trends for the industry are likely to be. For the detailed analysis of the responses, download your free copy of the report.