Is There a Best?
We all want the best. Whether it's a new stereo or a high availability solution for your database server. Steve Jones talks about the need for us to learn more in order to make the best decision for ourselves.
Linear Gauge Control: A Practical Use
SQL Server Reporting Services 2008 introduced several new features. One key feature was the inclusion of the Gauge Controls. I...
SQL Server Encryption Symmetric vs. Asymmetric Keys
I need to encrypt my data within SQL Server and I plan on using the built-in encryption functionality in SQL Server 2005 and 2008. However, I'm looking at symmetric and asymmetric key algorithms and while I see information saying to use symmetric keys, I don't understand why. What's the difference between the two and why is a symmetric key algorithm preferred over the asymmetric key ones?
Using Server Side Traces for Dynamic Performance Evaluation
This article describes a method of gathering and analyzing performance data using SQL Trace.
Why I Run SQLServerCentral
After the holiday, Steve Jones gives a little insight into his job, and what he likes about running SQLServerCentral.
Keeping Track of Virtual Databases
Are your database servers not performing well? Have you discovered two or more virtual servers running on the same node? Shailesh Khanal shows you how to generate a status report for multiple database servers and services, schedule it to run automatically and send it out via email.
Limit Your Data Liability
We aren't necessarily liable for data breaches at our company, but will that last forever? Steve Jones talks about some things that you might want implement to ensure that you aren't liable if there ever is a security issue.
Are You a Giver or a Taker?
A guest editorial from Brad McGehee today examines the way in which DBAs interact with the community. Do you take from the community, learning from others? Or do you give back more? Both are a part of many DBAs' careers. Brad talks about the importance of giving back when you can.
Best of SQLServerCentral, Volumes 1 - 4
Best of SQLServerCentral vols 1-4 pulls together some of the best contributions to SQLServerCentral.com between 2002 & 2006.
Get Rid of Duplicates!
This article contains instructions on how to use some of my favorite methods to remove duplicate fields from a table.
Blogs
Microsoft Fabric OneLake Shortcuts: When to Use Them and When Not To
By James Serra
An architecture scenario Imagine separate Sales, Finance, Shared Data, and Executive Analytics workspaces. Sales...
SQL Server Security Hardening Guide Using the DoD STIG Checklist
Security on your SQL Server is important. That doesn’t need any explaining. But where...
EightKB 2026: Registration is Open!
It’s that time of year again! EightKB is back on August 20th at 13:00...
Forums
Are You Working More Hours?
Comments posted to this topic are about the item Are You Working More Hours?
Stairway to Reliable Database Deployments Level 6 – Managing Changesets Over Time
Comments posted to this topic are about the item Stairway to Reliable Database Deployments...
A Limited Startup
Comments posted to this topic are about the item A Limited Startup
Question of the Day
A Limited Startup
I add this parameter to SQL Server 2025 in the Configuration Manager:
-mDynamicsWhat does this do? See possible answers