SSIS At Christmas
Due to overwhelming demand, we've opened up another Integration Services class. Start Christmas vacation early in Orlando on Dec 18.
2006-08-28
2,157 reads
SQLServerCentral
Become an ETL Expert
Learn ETL solutions from SQL Server MVP Brian Knight at the SQLServerCentral.com training center.
2006-08-08
6,248 reads
Contract Work
Make a little extra money and find a contract job through our partnership with HohGigs.
2006-06-14
5,816 reads
PASS 2006 Reception
Once again the SQLServerCentral.com staff is putting on a Tuesday night reception. Read how you can attend this November in Seattle.
2006-06-13
1,865 reads
The May SQL Server Standard
Better late than never, here's a look at the May issue of the SQL Server Standard, now available as a PDF.
2006-06-07
4,102 reads
May SQL Server Standard
The May issue of the SQL Server Standard is out and we're printing as you read this. This month we take a look at the Ovation Research Group.
2006-05-04
2,734 reads
A Contest from APress
Apress, one of the premier techincal publishers, is releasing quite a few titles based on SQL Server 2005. They've agreed to sponsor our Question of the Day and give away some books. Read how you can win and what they're offering.
2006-05-01
2,440 reads
SQL Server 2005 Logon Triggers
One thing that many people tried to implement in SQL Server 2000 is the auditing of logins. However getting this to work was a complex process. In SQL Server 2005, however, there are a few ways you can handle this and new author Frederik Vandeputte brings us a method using Service Broker for handling this.
2006-04-17
25,375 reads
2006-04-11
2,975 reads
SQLServerCentral.com 5 Year Anniversary
It's been 5 years that this community has been live and Steve Jones takes a short look back at the community as well as announcing a few prizes.
2006-04-10
2,970 reads
Blogs
Day 2 at PASS Data Community Summit 2024
By Steve Jones
I missed blogging yesterday as I was on stage/backstage for quite a bit of...
PASS Summit 2024 – Wednesday
By Brian Kelley
A common theme in the PASS Summits I've attended is community and that's definitely...
Taming Database Challenges: Insights from Redgate Keynote
By Chris Yates
I am excited to cover the Microsoft Keynote on Day 2: Redgate Keynote: Simplifying...
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