Transparent Data Encryption Using Certificates and EKM - Level 1 of the Stairway to TDE
The first level of the Stairway to TDE will explain how the feature works and how to set this up on one of your instances and databases.
Where to Test Your Code
When and where should you test code? Steve has a few thoughts when we consider the database as a crucial part of our software.
Two Tweaks for Faster Backups with Ola Hallengren’s Scripts
Ola Hallengren’s free maintenance solution is widely used as a replacement for SQL Server maintenance plans. It’s a more powerful, flexible tool for backups, corruption checking, and index & statistics updates. If you’re using it for backups, there are two quick, easy changes that can dramatically reduce your nightly job runtimes.
How to Rename a Column in SQL Server
Learn how to effectively rename columns in SQL Server using our comprehensive guide. Explore the use of sp_rename, limitations, and best practices
What Do You Want to Learn?
There's a survey available to give your input for what topics you'd like to learn about at the next SQL Saturday.
Effective Strategies for Storing and Parsing XML in SQL Server
XML is a common storage format for data, metadata, parameters, or other semi-structured data. Because of this, it often finds its way into SQL Server databases and needs to be managed alongside other data types.
Cloud Transformation
There are lots of companies moving databases to the cloud. Steve has a few thoughts on how to evaluate this for your company.
How I Used PostgreSQL RLS To Avoid Code Changes During a Migration
This article discusses how one person implemented Row Level Security in PostgreSQL to help with a data migration from a single tenant to a multi-tenant database structure.
Query Exercise: Beat ChatGPT at Finding Good Question Times
What are the best days of the week and times of the day to post a question at StackOverflow.com?
SQL Injection Is Not Acceptable
An alert from the US government says that SQL Injection isn't an acceptable problem.
Blogs
Monday Monitor Tips: AI Query Analysis
By Steve Jones
AI is everywhere. It’s in the news, it’s being added to every product, management...
AI: Blog a Day – Day 8: RAG – Retrieval Augmented Generation
By Vinay Thakur
RAG — Retrieval Augmented Generation. we have covered so far — embeddings, vectors, vector...
AI: Blog a Day – Day 7: Vector and Vector Databases
By Vinay Thakur
Continuing from Day 6 we learned Embeddings, Semantic Search and Checks, on Day 7...
Forums
I'm thinking about submitting some articles
I've written some documentation on using different Markdown types of files on GitHub. It's...
Not Just an Upgrade
Comments posted to this topic are about the item Not Just an Upgrade
Restoring On Top I
Comments posted to this topic are about the item Restoring On Top I
Question of the Day
Restoring On Top I
I am doing development work on a database and want to keep a backup so I can reset my database. I make some changes and want to restore over top of my changes. When I run this code, what happens?
USE Master BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO USE DNRTest GO CREATE TABLE MyTest(myid INT) GO USE master RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACESee possible answers