Expect the Unexpected with DiRT

• by Steve Jones

• SQLServerCentral

• Disaster Recovery (DR)

Disaster recovery is no joke at Google, where they really test their systems, people, and processes.

Migrating Column Level Encryption from 2008R2 to Azure SQL Database

• by Gareth Barnes

• SQLServerCentral

A migration to Azure is stuck because of an encryption change in SQL Server. Learn how to get around this by using a certificate for encryption.

Take the 2020 State of Database DevOps Survey – win a new iPad

• by Additional Articles

• Redgate

• DevOps and Continuous Delivery (CI/CD)

Redgate’s 2020 State of Database DevOps Survey is open now. Share your views on Database DevOps today for a chance to win a new 65GB iPad Air. Plus, for every entry, Redgate will donate $1 to UNICEF. Take the survey now.

UNION vs. UNION ALL in SQL Server

• by Additional Articles

• MSSQLTips.com

• UNION
• UNION ALL

Sometimes there is a need to combine data from multiple tables or views into one comprehensive dataset. This may be for like tables within the same database or maybe there is a need to combine like data across databases or even across servers. I have read about the UNION and UNION ALL commands, but how do these work and how do they differ?

Proactive Performance Tuning

• by Steve Jones

• SQLServerCentral

• Administration

Being proactive in trying to improve your system is good, but sometimes your team might cause you problems with their efforts.

Stairway to Biml 9 – Refactoring a Simple Custom Biml Framework

• by Andy Leonard

• SQLServerCentral.com

This level of the Stairway to Biml examines how to refactor your Biml into an easier to maintain format.

Free eBook: Performance Tuning with SQL Server Dynamic Management Views

• by Additional Articles

• Redgate

• Performance Tuning

Dynamic Management Views (DMVs) are a significant and valuable addition to the DBA's troubleshooting armory, laying bare previously unavailable information regarding the under-the-covers activity of your database sessions and transactions.

HSA for Training

• by Steve Jones

• SQLServerCentral

• Career

Is there a good way to ensure employees get trained? Steve has a few thoughts today on an idea that could help.

It's More Than What You Know

• by MVDBA (Mike Vessey)

• SQLServerCentral

• Career
• career networking

I'm a firm believer in keeping your tech skills up to date, as well as your social skills, What better way than attending or presenting at a conference or group meeting. The reason to attend an event I'm very fortunate that my company allows me training days and time for personal development, covering all expenses […]

SQL Database Project Code Branching in Git

• by Additional Articles

• MSSQLTips.com

• Git

Source Control | Git | Branching - In this article...