Avoiding the EAV of Destruction
A forum posting, from someone who wanted a better solution to the common problem of handling global settings in a database, leads Joe Celko into a fascinating discussion of the ramifications of the various solutions.
Move SQL Server transaction log files to a different location via T-SQL and SSMS
I am planning on moving the SQL Server log file of my production database on this drive. I am curious about how it will optimize the performance. What are some of the considerations I should take into account and how can I move the SQL Server database log file to a separate physical location?
What is the Best Way to Test SQL?
Over the past five or so years, encouraging progress has been made with regard to testing .NET application code...I wish I could say that the same progress had been made with testing SQL.
Migrating A SQL Server 2005 Reporting Services Named Instance, The Missing Manual
Microsoft has always been pretty good at one thing, ease on install. One of the things I always says is the greatest thing about SQL Server is any idiot can install it. The other thing I also say is the worst thing about SQL Server is any idiot can install...
Sending E-mail from SQL Server 200X
From monitoring e-mail messages to distributing reports for users, SQL Server's database mail proves quite useful. Learn how to use it in SQL Server 2000 and SQL Server 2005/2008.
Windows Server Virtualization: Hyper-V, an Introduction
For SQL Server and Exchange Server, Windows Server Virtualization is going to be increasingly important as a way for the administrator to allocate hardware resources in the most efficient way, provide more robust services, and deploy services. Jaap Wesselius starts his new series on Hyper-V by explaining what Hyper-V is, how it relates to Windows Server 2008 and how it compares to ESX, Virtual Server and Virtual PC.
Automating tests for T-SQL code
Learn how you can write test automations for T-SQL code using T.S.T. New author Ladislau Molnar has a great project on Codeplex that can help improve your testing.
Creating Indexed Views - SQL School Video
An indexed view is materialized and exists with actual data. Andy Warren shows how to create one in this SQL School video.
Documenting Database Code: Structured Headers
When you're doing any database development work, it won't be long before you need to seriously consider the documentation of your routines. Should we, as a community, propose a common standard for T-SQL headers, and the information that should go into them?
Copy Only Backup for SQL 2005 and SQL 2008
Is there any way that my ad hoc backups will not interrupt the sequence of my backup plan?
Blogs
Redgate and Rome
By Steve Jones
I’m at the UK Redgate office today, meeting with senior leaders in all areas...
Quick Tip: Check Most DTU Expensive Queries in Azure SQL Database
Optimizing Azure SQL Database performance often begins with identifying the most resource-intensive queries. Understanding...
PowerShell Newbie – Variables
By gbargsley
This is Week 2 of PowerShell Strikes Back – a four-week May series for...
Forums
SSRS Is Dead. Here Are Your Real Options
Comments posted to this topic are about the item SSRS Is Dead. Here Are...
The Distance Metric
Comments posted to this topic are about the item The Distance Metric
The New Wave of Security Threats
Comments posted to this topic are about the item The New Wave of Security...
Question of the Day
The Distance Metric
In the new VECTOR_DISTANCE() function in SQL Server 2025, the first parameter is the distance_metric. What is this?
See possible answers