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 […]
Power BI Auto Detect Relationship Failure
Power BI doesn't always detect relationships, and this article explains a bit about the problem.
Will AI end with SQL, Is this the end of SQL?
An experienced DBA asks an AI to perform some common tasks. Read to see how it fairs and if an AI will impact DBA jobs.
Blogs
Changing the Cardinality of a FK in Redgate Data Modeler
By Steve Jones
One of the things a customer asked recently about Redgate Data Modeler was how...
Future-Proofing: How to Stay Ahead in FinOps
By HeyMo0sh
Cloud environments don’t sit still. Pricing models change, services evolve, workloads grow, and suddenly...
Introducing the SQL Server on Kubernetes Operator
Are you considering replatforming your SQL Server workload due to recent vendor changes, but...
Forums
Removing TDE
Comments posted to this topic are about the item Removing TDE
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
Question of the Day
Removing TDE
How do I remove TDE encryption of data from database xxx?
See possible answers