Default Backups and Feature Awareness
Default backup schemes for databases would be a nice enhancement.
Stairway to T-SQL: Beyond The Basics Level 3: Building a Correlated Subquery
This stairway level will expand on the subquery topic by discussing a type of subquery known as a correlated subquery, and explores what a correlated subquery is and how it is different from a normal subquery.
How to Build an Efficient Request Process for SQL Server DBAs
Take a look at some of these DBA request examples and things you could do to improve your request process.
A tour of the Execute Package Task
Introduces modular programming with the Execute Package task, and shows bi-directional parameter passing.
MDX (MultiDimensional Expressions) in 148 minutes
If you want to understand the fundamentals of MDX in less than 3 hours - this article can be helpful.
Using Azure Data Studio with TFVC
Azure Data Studio (ADS) is a lightweight IDE built on Visual Studio Code. I've written a few articles on how ADS works, shown here: Getting Started with Azure Data Studio Getting Comfortable Writing Code in Azure Data Studio Using Notebooks in Azure Data Studio Using Azure Data Studio with TFVC Using Azure Data Studio with […]
Microsoft SQL Server: Current Identify Column Value in a Table
Learn how to find the current identify column value in your Microsoft SQL Server tables.
Really Important Software
Software often controls hardware, which can make it the critical part of a system. That's something we should be learning from the Boeing 737-Max crashes.
Writing R Code in SQL Server - Level 3 of the Stairway to Machine Learning Services
In this level, learn about how to get the tools needing for coding in R and how to execute some code that connects to SQL Server.
Enable SQL Server Agent Mail Profile
Learn how to configure SQL Server Agent to allow emails to be sent for job notifications and alerts.
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