New Class: Fundamentals of TempDB – Instant Replays Ready Now
Yesterday, I taught my first Fundamentals of TempDB class, and as always, you can watch the Instant Replays right after class completes. Here’s the abstract: You’ve been working with Microsoft SQL Server for a couple of years, and you know …
Boost performance of your SQL Server tables with a TURBO button
Introduction Performance, performance, performance. While performance in SQL Server can be achieved with code improvement and proper infrastructure maintenance, both tasks require an effort. Code reviews and deep index analysis would take time, but som …
Azure SQL Database TDE Customer Managed Keys
The post Azure SQL Database TDE Customer Managed Keys appeared first on SQLServerCentral.
SQL ConstantCare® Population Report: Fall 2020
Ever wonder how fast people are adopting new versions of SQL Server, or what’s “normal” out there for SQL Server adoption rates, hardware sizes, or numbers of databases? Let’s find out in the summer 2020 version of our SQL Const …
Ten tips for attracting and retaining DevOps talent
DevOps can help organizations become more agile and responsive to their customers, but it’s only as effective as the individuals who participate on the DevOps teams. Getting the right people in place is paramount to a successful DevOps implementa …
Feature branches and pull requests with Git to manage conflicts
I’ve recently fielded two questions from different customers regarding how to best work as a team committing database changes to Git. While there are a wide variety of branching models which work well for databases with Git — Release Flow, …
Steps for Installing AlwaysOn Availability Groups – SQL 2019
With SQL Server 2012 Microsoft introduced the AlwaysOn Availability Group feature, and since then many changes and improvements have been made. This article is an update to another article, and will cover the prerequisites and steps for installin …
Export SQL Server Data to Multiple Excel Worksheets with C#
The post Export SQL Server Data to Multiple Excel Worksheets with C# appeared first on SQLServerCentral.
Optimize SQL Server estate monitoring with Redgate’s SQL Monitor
The post Optimize SQL Server estate monitoring with Redgate’s SQL Monitor appeared first on SQLServerCentral.
Autoparameterized Trivial Queries May Not Get Partition Elimination
How’s that for a niche topic? You’re probably never going to know this, but since I had to figure it out the hard way, I’m writing this down so I don’t forget it: queries that get trivial optimization may not get partition elimi …
Rules in PostgreSQL
We sometimes need to perform a different/alternative actions during database queries. We need it for data protection or data abstraction. The PostgreSQL rule system allows to define an alternative action on insert, update or delete. A rule generates an …
Why you should include the database in your 2021 IT strategy
The post Why you should include the database in your 2021 IT strategy appeared first on SQLServerCentral.
Configure SQL Server Database Mail on Amazon RDS
The post Configure SQL Server Database Mail on Amazon RDS appeared first on SQLServerCentral.
Join us for this year’s final Redgate Summit
The post Join us for this year’s final Redgate Summit appeared first on SQLServerCentral.
How to Execute SSIS Packages from SQL Server Agent
The post How to Execute SSIS Packages from SQL Server Agent appeared first on SQLServerCentral.