Azure Data Studio and Version Control
This article examines how you can use Azure Data Studio with your git Version Control System.
Gathering Data Through Life
Every once in a while, I find a list of places posted on the Internet with a "how many have you visited?" question attached. This might be US states, countries, cities, or even attractions. I love traveling with my wife and having new experiences, and as we've gotten older, we value the experiences more than […]
Finding deeper insights with Topic Modeling
Topic modeling can be used to find more detailed insights into text than a word cloud can provide. Sanil Mhatre walks you through an example using Python.
Webinar | Gain the competitive edge with a monitoring tool
Robust database monitoring is at the heart of ensuring business continuity, customer satisfaction and protected revenue, and this webinar with Chris Yates, Senior Vice President, Managing Director of Data and Architecture at Republic Bank, will clearly demonstrate why.
7 DB Forge SQL Studio Features Discovered in Less Than 2 Hours
dbForge SQL Studio gives you a few advantages over SSMS. See what Kenneth discovered during his first use of the tool.
Migrating a Large Database
Large database upgrades are stressful, but a little planning and practice can help things go smooth.
SQL Server Crib Sheet Compendium
As a developer, DBA or manager, you may not really want to know all about XML, replication or Reporting Services, but if your next project uses one or more of these technologies heavily then the best place to start is with the 'jungle roof' view of each topic that this Crib Sheet compendium provides.
Continuous Data Protection with SQL Data Catalog 2.0 and Data Masking
SQL Data Catalog 2.0 provides a simple, policy-driven approach to data protection, through data masking. It can now automatically generate the static masking sets that Data Masker will use to protect your entire database, directly from the data classification metadata held within the catalog.
Why your PL/SQL needs to be testable – and how to do it: Part 1
Part 1: What is testable code, why is it important, and first glimpses on practices that can help
The Best of SQLServerCentral, Vol.7
The seventh volume in this collection brings you a compilation of the best articles we've seen over the past year, from over 50 authors.
Blogs
PASS Data Community Summit 2024 Day 3 Keynote
By Steve Jones
It’s been an amazing week here, as well as a long week. I’m tired,...
A New Word: Skidding
By Steve Jones
skidding – v. intr. the practice of making offhand comments that sound sarcastic but...
PASS Summit – Thursday
By Brian Kelley
Let’s start with the keynote. The biggest take away was how having to support...
Forums
Step by step guide to setup PostgreSQL on Docker
Comments posted to this topic are about the item Step by step guide to...
Backing up the Database Encryption Key
Comments posted to this topic are about the item Backing up the Database Encryption...
Technology Fears
Comments posted to this topic are about the item Technology Fears
Question of the Day
Backing up the Database Encryption Key
In my SQL Server 2022 database, I run this:
USE Sales; GO CREATE DATABASE ENCRYPTION KEY WITH ALGORITHM = AES_256 ENCRYPTION BY SERVER CERTIFICATE MyServerCert; GOThis works, but I want to prepare for the future and potential issues. How do I back up my DEK? See possible answers