Query Optimizer Suggests Wrong Index and Query Plan -- Why?
A good example where the Query optimizer picks the wrong query plan and suggested index.
2021-02-25
5,055 reads
Articles
Ten tips for building a collaborative DevOps culture
There is more to DevOps than tools and automation. In this article, Robert Sheldon explains how to create a DevOps culture based on collaboration.
2021-02-25
Comparing and Syncing Data using SQL Data Compare Command Line
Robert Sheldon demonstrates how to start automating data comparisons between two databases, from the Windows command line or PowerShell. With a single command, you can easily compare and sync data such as test data sets, or static data used for reference or lookup purposes.
2021-02-24
Learning SQL Server
Learn about the core SQL Server concepts to build your skill set including the architecture, database design, development, administration and more.
2021-02-24
Discussion on Normalization and Database Design Concepts
Introduction Relational database design helps to create a set of relations and tables, which are connected with each other through some defined relationships. The main purpose of relational database design is to preserve the information and minimize data redundancy. We need to follow some design guidelines for relational schemas to maintain the quality of the […]
2021-02-23
5,314 reads
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
Implementation of Normalization in SQL Server
Introduction In my last article, Discussion on Normalization and Database Design Concepts, I discussed about the normalization concepts. Here, I will take one table in SQL Server and implement different normal forms. As we move up the higher normal forms, we end up on more number of tables. Implementation of Normal Forms Let us start […]
2021-02-22
4,559 reads
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
Dynamically Generate Replication Tasks with Biml and Custom Connectors
This article walks through using Biml with 3rd party connectors to replicate external data to SQL Server in SSIS.
2021-02-19 (first published: 2019-03-21)
1,813 reads
Blogs
2025 Wrapped for Steve
By Steve Jones
I’ve often done some analysis of my year in different ways. Last year I...
The Book of Redgate: Spread across the world
By Steve Jones
This was Redgate in 2010, spread across the globe. First the EU/US Here’s Asia...
Merry Christmas
By John
Today is Christmas and while I do not expect anybody to actual be reading...
Forums
SQL Server 2019 - Agent job PowerShell step issue
I have a couple of SQL Agent job steps which run PowerShell commands of...
Database security permissions save script
Comments posted to this topic are about the item Database security permissions save script
Database backup job steps
I have a SQL Agent job for backing up a set of Analysis Services...
Question of the Day
The Large Encoded Value
I want to use the new BASE64_ENCODE() function in SQL Server 2025, but return a string that isn't large type. What is the longest varbinary string I can pass in and still get a varchar(8000) returned?
See possible answers