Improve System Performance in Your Indexing Scheme Using Asynchronous
The Web Data Administrator is a utility program implemented in ASP.NET that enables you to easily manage your SQL data, wherever you are.
2001-10-10
1,911 reads
Articles
A Few Mathematical UDFs
Alexander Chigrik presents a few Math UDFs he has developed for common functions.
2001-10-09
6,009 reads
2001-10-08
1,972 reads
Transactional Replication Performance Tuning and Optimization
This paper examines performance in transactional replication and demonstrates ways in which you can improve the performance of your applications. (30 printed pages)
2001-10-08
1,868 reads
An Alternative Way To Get the Table's Rowcount
This article examines an alternative method for finding the rowcount of a table besides using a select count(*)
2001-10-05
4,779 reads
COM+ Application Guidelines for Visual Basic Development
This 80-page reference article presents guidelines for designing, building, and deploying COM+ applications, with an emphasis on Visual Basic.
2001-10-05
879 reads
Introduction to SQL-DMO
SQL-DMO is a pretty cool way of working with SQL Server. Never tried it? Sean Burke offers a very readable introduction to how it works.
2001-10-04
14,548 reads
More on Returning a Subset of a Recordset
Last week's tip created quite a discussion on different techniques for returning a subset of a recordset.
Here are a few of the alternative solutions offered.
2001-10-03
8,865 reads
Reattaching Databases - Some Code AND a Contest - Follow Up!
Early in September Andy posted an article that explained how to use DMO to reattach a lot of MDF's in a hurry AND challenged our readers to accomplish the same task in T-SQL. Today we announce the winning solution!
2001-10-02
5,663 reads
Update: Guide to Clustering Windows 2000 and SQL Server 2000
This is an update to a recent article that provides a step-by-step guide to clustering SQL Server 2000 and Windows 2000.
2001-10-02
506 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
How Generative AI is Changing the Game for Developers and Businesses
Generative AI is revolutionizing various industries by streamlining operations and enhancing creativity. In marketing,...
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...
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