Protecting Off Hours
There is new legislation in Australia that is supposed to allow employees to ignore messages outside of working hours. Steve has a few thoughts on how he balances his workload.
There is new legislation in Australia that is supposed to allow employees to ignore messages outside of working hours. Steve has a few thoughts on how he balances his workload.
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.
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, […]
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.
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.
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
Today Steve has a few thoughts on his keynote topic today at the Redgate Summit.
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.
In this tip, I will demonstrate how to migrate an existing database schema from SQL Server to PostgreSQL.
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.
By HeyMo0sh
Test Data Management (TDM) is essential in software development to ensure your application runs...
By Rohit Garg
Introduction Full-Text Search in SQL Server is a feature that provides linguistic search capabilities...
By Steve Jones
Recently I’ve been looking at archiving some data at SQL Saturday. As a start,...
Greetings, I need to transform data returned in a query from several tables as...
Hi Replication and publisher configured on the same sql server 2022 version. Subscription to...
Hello, I am trying to firgure out how to merge duplicate indexes using a...
If I want to enable a trace flag for a specific query, how do I do it?
See possible answers