SQL Server Password Management:
Improving SQL Server password management includes thorough password testing and securing SQL Server installations beyond the main database server.
2007-07-31
2,653 reads
Additional Articles
AJAX Stock Symbol Drop-down List
A web look up of a huge list of stock symbols from an MS SQL database.
2007-07-30
2,817 reads
10 tips for sorting, grouping, and summarizing SQL data
Arranging SQL data that you can effectively analyse requires an understanding of how to use certain SQL clauses and operators. These tips will help you figure out how to build statements that will give you the results you want.
2007-07-27
5,433 reads
A Discount on SQL Populator
Software Development Innovations is offering SQLServerCentral.com members a 20% discount on their products with a coupon of "sqlservercentral" used in their cart.
2007-07-27
2,309 reads
CLR: 9 Reusable Parallel Data Structures and Algorithms
This column is less about the mechanics of a common language runtime (CLR) feature and more about how to efficiently use what you’ve got at your disposal.
2007-07-27
2,632 reads
Keep a check on your IDENTITY columns in SQL Server
Be sure you don't end up with arithmatic errors in your identity columns from a SQL Server MVP.
2007-07-26
2,984 reads
A T-SQL Regular Expression Library for SQL Server 2005
This article shows the reader how to construct a library of scalar and table valued functions for SQL Server 2005 to perform regular expression analysis.
2007-07-25
4,024 reads
ADO.NET Entity Framework Overview
ADO.NET in the next release of Visual Studio® code-named "Orcas" features the new Entity Framework.
2007-07-25
2,551 reads
Microsoft Windows Power Shell and SQL Server 2005 SMO – Part 4
Part 3 of this series discussed how to script PowerShell and connect to SQL Server. This installment illustrates how to use a PowerShell script to loop through the content of a file and connect to different servers.
2007-07-24
2,479 reads
SQL Server 2005 Express Edition - Part 2
Express Edition remains the primary choice for deployments of a full-fledged database engine in less demanding environments. Part two of this series explores its features in more detail in order to better understand its unique role in SQL Server 2005 portfolio.
2007-07-24
2,562 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