January 1st is the beginning of a new year thanks to Julius Caesar and Pope Gregory XIII. This date is somewhat arbitrary, and many religions and cultures celebrate their own beginning of a new year at different times. Even though these celebrations don’t fall at the same time, I think the sentiment is similar. The […]
2019-12-28
111 reads
This week Grant talks about the need for change and growth to adapt to the changing world.
2019-12-21
154 reads
Steve looks at a number of tools that you should spend time learning and building a level of comfort that enables you to use them in your daily work.
2019-12-07
311 reads
It’s rare to get a call from a customer telling you that the application is fast today and thanks for taking such good care of the database. Instead, you are more likely to hear complaints when things go wrong like slow running queries and timeouts. There is a lot to consider when trying to figure […]
2019-11-30
565 reads
Steve highlights a few items from a busy Microsoft and SQL Server news week.
2019-11-09
222 reads
I like to call tempdb the “workhorse” of SQL Server. I’ve heard some other people call it other terms that were not so flattering, but since I like to keep things positive, I’ll stick with workhorse. SQL Server uses tempdb for many things. The obvious uses are temp tables and table variables, but tempdb is […]
2019-11-02
1,116 reads
This week Grant muses on how history can impact our decisions moving forward, and having a little empathy can be useful when re-examining the past.
2019-10-26
132 reads
2019-10-12
213 reads
I remember when Azure SQL Database was first released in 2010. Microsoft has tweaked the name a couple of times over the years, and back then it was called SQL Azure. The largest database you could create was just 50 GB, and there were quite a few restrictions, such as heaps not being supported. Since […]
2019-10-05
421 reads
Today Grant reminds us to not only think about the things we can do better, but remember the good things that we accomplish.
2019-09-28
151 reads
By Steve Jones
It’s been an amazing week here, as well as a long week. I’m tired,...
By Steve Jones
skidding – v. intr. the practice of making offhand comments that sound sarcastic but...
By Brian Kelley
Let’s start with the keynote. The biggest take away was how having to support...
Comments posted to this topic are about the item Step by step guide to...
Comments posted to this topic are about the item Backing up the Database Encryption...
Comments posted to this topic are about the item Technology Fears
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