Yukon Info from Microsoft
Nothing super new here that has been rumored, this article outlines some of the changes we'll get to see in the next SQL release!
2003-04-08
3,523 reads
Articles
Auditing Your SQL Server - Part 3
This article expands Steve Jones' look at ways to audit changes by examing how you can deal with the large amounts of data generated.
2003-04-07
10,586 reads
mssqlXpress v1.02 Released
This is a product we haven't reviewed yet, but looks interesting. A SQL editor type app, features listed include integration with Visual SourceSafe, 'intellisense' statement completion, and keyboard macro's.
2003-04-04
1,037 reads
Managing Jobs Using TSQL
We've had a good run of jobs about job management lately, Randy sent us another one that looks at the job of job management and shows us how he tackled the problem.
2003-04-02
24,098 reads
Free Webcast Today: SQL Server Security Best Practices
Join SQLServerCentral.com co-founder Brian Knight for this free webcast on SQL Server security best practices. In this session on Technet, we will look at how to protect your system from internal and external security factors. We will look at the types of permissions in your database objects, implementing column and row-level security, and protecting yourself from SQL Injection attacks. We'll also cover best practices for basic and advanced protection for your SQL Server system.
2003-04-02
1,994 reads
Identifying performance issues using Profiler
It is always better to be proactive than reactive, when it comes to identifying and eliminating SQL Server performance issues. This article shows you how to analyze the data gathered by Profiler, to identify the performance issues. This article also provides four generic stored procedures for analyzing Profiler output.
2003-04-01
2,688 reads
Worst Practices - Blank Passwords
Not even worth talking about, right? Probably, but they still exist. Read about this worst practice and pass it along.
2003-03-31
5,381 reads
Cluster That Index!
Quite a while back Andy wrote an article about why not using primary keys and clustered indexes was a worst practice. Chris weighs in this week with a great article that gives some more in depth info on clustered indexes and why he thinks they should be used on every table.
2003-03-30
18,801 reads
Should you buy a SAN?
Andy recently implemented a SAN and shares some of the info he picked up during the purchase and implementation. This article also discusses briefly the differences between SAN and NAS, and has some links to other sites for more info as well.
2003-03-28
8,103 reads
Free Webcast: SQL Server 2000 Security Best Practices
Join SQLServerCentral.com co-founder for this free webcast on SQL Server security best practices. In this session, we will look at how to protect your system from internal and external security factors. We will look at the types of permissions in your database objects, implementing column and row-level security, and protecting yourself from SQL Injection attacks. We'll also cover best practices for basic and advanced protection for your SQL Server system.
2003-03-27
413 reads
Blogs
Shifting Mindsets: Why FinOps is Essential for Cloud Efficiency
By HeyMo0sh
As a DevOps practitioner, I’ve always focused on performance, scalability, and automation. But as...
March 2026 SQL Server Security Updates
By Brian Kelley
On Patch Tuesday, in addition to OS and Office security patches, Microsoft also released...
How Fabric Mirroring Transformed with SQL Server 2025
When mirroring was first released for Azure SQL Database, it used Change Data Capture...
Forums
Multiple Deployment Processes
Comments posted to this topic are about the item Multiple Deployment Processes
How to Use sqlpackage to Detect Schema Drift Between Azure SQL Databases
Comments posted to this topic are about the item How to Use sqlpackage to...
Upgrading Admin Queries
Comments posted to this topic are about the item Upgrading Admin Queries
Question of the Day
Upgrading Admin Queries
I have a query from a former DBA that we run on SQL Server 2025 to check on database metadata. This query references sys.sysaltfiles. I want to refactor this code to be more modern. Which DMV should I reference instead?
See possible answers