SQL Server DB Migration – Cloning a database to another collation
Database migration is a vital task in any environment, complex or otherwise. Seamless migrations are the goal but the efforts...
2017-09-19
332 reads
Blog Posts
When Deadlocks Become Art
We’ve all had to solve deadlock issues. Identify the two conflicting pieces of code, work out an appropriate change to...
2017-09-19
694 reads
Adding Replicas into existing Availability Groups
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the...
2017-09-18
354 reads
dataMinds Connect 2017 (win a ticket!)
Within two weeks the wait is over: the first edition of dataMinds Connect! For those of you wondering what I’m...
2017-09-18
329 reads
DevOps Basics–Git Clients
This is also a part of a basic series on git and how to use it.
There are lots of git...
2017-09-18 (first published: 2017-09-07)
1,880 reads
Experimenting with VSCode instead of the ISE
I’ve been playing with PowerShell here and there, learning a few things. As I use the dbatools project, or
I...
2017-09-18
531 reads
Generate Markdown Table of Contents based on files within a folder with PowerShell
Last week I was talking with Constantine Kokkinos (b | t) about generating a Table Of Contents (TOC) for a GitHub repository.
He wrote a cool blog post - Generating...
2017-09-18
7 reads
Monday Coffee: Should I learn powershell?
This month’s T-SQL Tuesday’s topic was set by Rob Sewell (b|t) and entitled Let’s all get PoSH
It had a massive...
2017-09-18
810 reads
Please Don’t Do This!
Please, please, please Admins do not leave your default index fill factor at 0. This means you are telling SQL...
2017-09-18 (first published: 2017-09-06)
3,890 reads
SQL Server Schema Compare
A very common requirement which can be satisfied by various tools. Personally I like using Visual Studio 2017 Community Edition...
2017-09-18
599 reads
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