DBA in training: SQL Server under the hood
In this article of the series, Pamela Mooney explains the architecture of SQL Server under the hood, including some query anti-patterns to avoid.
2021-02-23
Additional Articles
Resolve Git Merge Conflict for SSIS Projects
When working on an SSIS project with multiple developers, a merge conflict can occur in the git repository. In this tip we'll show you how to resolve this type of conflict and provide alternative options.
2021-02-22
Securing SQL Server with DoD guidelines
Making sure your SQL Servers are secured against malicious users is difficult. The United States Defense Information Systems Agency (DISA) publishes a set of guidelines for organizations securing different pieces of software that connect to the US Department of Defense’s networks (DoD). Whether you’re working with the DoD or not, these Security Technical Implementation Guides (STIGs) are a good resource to help you understand potential security vulnerabilities and mitigate them.
2021-02-22
Mastering TempDB: The basics
Mastering TempDB is a critical skills for SQL Server DBAs. In this article, Monica Rathbun explains the basics of TempDB including configuration.
2021-02-19
SQL Server triggers: The good and the scary
SQL Server triggers are another tool in your DBA or Dev toolbox. Edward Pollack explains what can go wrong with triggers and how to correct those issues.
2021-02-18
Product Training Sessions from Redgate University
In 2020 Redgate introduced a series of live training sessions on a selection of their most popular tools, offering customers top tips and demonstrations of new features. If you didn't get a chance to join then check out the recordings available here and be sure to subscribe for news about upcoming sessions.
2021-02-17 (first published: 2021-02-01)
SQL Server SET STATISTICS IO ON Deep Dive
In this article we look at how to interpret and use the results of STATISTICS IO when tuning SQL Server queries.
2021-02-17
Azure Data Factory Pipeline Logging Error Details
In this article we will cover how to capture and persist Azure Data Factory pipeline errors to an Azure SQL Database table.
2021-02-16
Execute Dynamic SQL commands in SQL Server
In some applications having hard coded SQL statements is not appealing, because of the dynamic nature of the queries being issued against the database server. This is where dynamically building SQL statements can be useful.
2021-02-15
The Future of Database DevOps
Join Pramod Sadalage, Director at Thoughtworks, and a stellar line up of speakers for Redgate Summit: The Future of Database DevOps on February 17 & 18. You’ll discover the latest trends in DevOps, brand new insights from the 2021 State of Database DevOps report, an introduction and technical demos of Redgate’s solutions for Database DevOps, and more.
2021-02-15 (first published: 2021-01-29)
Blogs
T-SQL Tuesday #192: SQL Server 2025 Backup Changes
By Steve Jones
I hosted this month, but I decided to put my own entry in as...
Why Databases Still Fascinate Me
By Chris Yates
I get asked a lot about why or how I began working with databases...
Monday Monitor Tips: ServiceNow Integration
By Steve Jones
Earlier this year I visited a customer that was using the Redgate Monitor webhook...
Forums
Member was not found in the cube when the string
Hey, I've not done a cube for many years but I find myself supporting...
Implementing PostgreSQL with Python for Real-Time Logging and Monitoring
Comments posted to this topic are about the item Implementing PostgreSQL with Python for...
Identify a Slipstream Installation
Comments posted to this topic are about the item Identify a Slipstream Installation
Question of the Day
Identify a Slipstream Installation
I get a new SQL Server instance from my build team. How can I tell if the instance was installed using a slipstream installation later?
See possible answers