Correct SQL Server Transactional Replication Issues with T-SQL and SSMS
Learn how to address SQL Server transactional replication issues with these easy-to-follow steps using T-SQL and SSMS to troubleshoot and fix issues.
Give It Away
Tech conference season is in full swing, and it’s only the middle of March. Between Grant, Steve, and I, we’ve attended or presented at about 10 events so far. And within my community of developers and database folks, I’ve seen pictures and posts of many more. As I’ve said a few times in previous editorials, […]
Growing Skills at Work
We all need to grow our skills at work. It can be challenging, but we can find ways, as well as advocate to management that resources are needed.
The difference between BIN2 and Case-Sensitive collations in SQL
Here you will learn about the key differences between the binary and SQL/Windows collations. You will see that even with all sensitivity flags enabled, SQL/Windows collation cannot behave the same way as the binary collations.
Automating BCP with PowerShell
I was talking with a good friend that has an environment with terabytes of information and to create a homolog or dev environment to him is a pain. He comes to me with a solution : A PowerShell script that gets only the first 1000 lines of each table, creates the inserts and schema files
Navigating the Database Landscape
Today Steve has a few thoughts on his keynote topic today at the Redgate Summit.
Stairway to Advanced T-SQL Level 2: Using the APPLY Operator
The APPLY operator allows you to join a record set with a function, and apply the function to every qualifying row of the table (or view). The APPLY operator takes on two formats: CROSS APPLY, or OUTER APPLY. This article will explain the differences between these two formats, and show you examples of how each of these formats work.
SQL Server to PostgreSQL Database Schema Conversion
In this tip, I will demonstrate how to migrate an existing database schema from SQL Server to PostgreSQL.
Have You Deployed an Availability Group?
Learning about the Availability Group technology can be valuable for your career. Today Steve asks if you've deployed one, and if not, perhaps you want to try.
Oops! Apologies
So, I messed up. In my calendar on Friday were the words, "Database Weekly." That's because I was supposed to put this editorial together and put out the Database Weekly. But I messed up. I was traveling on Friday. Not an excuse, but it's why I messed up. I'm sorry. However, what I did this […]
Blogs
A New Word: Anderance
By Steve Jones
anderance – n. the awareness that your partner perceives the relationship from a totally...
Troubleshooting SQL Server – Starting with the Error Log
By gbargsley
We’ve all been there. Someone walks up and asks, “Is SQL Server having issues?”...
From OLTP to Analytics: Bridging the Gap with Modern SQL Architectures
By Chris Yates
In the beginning, there was OLTP – Online Transaction Processing. Fast, reliable, and ruthlessly...
Forums
Parameter Sensitive Plan Optimization in SQL Server 2022
Comments posted to this topic are about the item Parameter Sensitive Plan Optimization in...
Minimum Change Tracking Retention
Comments posted to this topic are about the item Minimum Change Tracking Retention
AI Steals Joy
Comments posted to this topic are about the item AI Steals Joy
Question of the Day
Minimum Change Tracking Retention
If I am running this code:
ALTER DATABASE AdventureWorks2017 SET CHANGE_TRACKING = ON (CHANGE_RETENTION=xxx);What is the minimum amount of time I can set? See possible answers