Physical Database Storage
This article provides a guide for physical storage design and gives recommendations and trade-offs for physical hardware design and file architecture.
2006-06-29
3,858 reads
Additional Articles
BlackBelt Administration: Linked Reports in Report Manager
Use Linked Reports to provide multiple "versions" of a single source report, as a mechanism for restricting consumer groups to their respective data in accordance with a "need to know."
2006-06-28
2,200 reads
Creating usable applications
If I had a penny for every person who said "usability is just common sense", I'd have a pretty reasonable stack of pennies – maybe 30 or so. Clearly I'm not going to be able to retire on this, but at least it demonstrates that many people have misconceptions about how usable interfaces are designed.
2006-06-27
2,601 reads
Working with TempDB
This white paper describes how SQL Server 2005 uses tempdb. Many improvements in SQL Server 2005 optimize tempdb usage and make it easier to manage and to troubleshoot. A case study that uses a workload similar to TPC Benchmark H (TPC-H) shows new ways to manage and troubleshoot tempdb resources. This paper also includes items to consider when upgrading to SQL Server 2005 and configuring tempdb
2006-06-26
3,001 reads
Database Geek of the Week - Glenn Johnson
The latest GotW award goes to Glenn Johnson, .NET trainer and author of Programming Microsoft ADO.NET Applications:
2006-06-23
3,168 reads
Building Database Applications with Remote Support in Mind
Although the challenges of designing and developing an embedded software package are obvious, the effort of providing remote support for the deployed application is often underestimated.
2006-06-22
2,581 reads
Web Parts in ASP.NET 2.0
Damon Armstrong demonstrates how to personalize the look-and-feel of multiple pages in your ASP.NET 2.0 applications.
2006-06-21
2,747 reads
Powerful, Flexible Text-Formatting Solutions in SQL Server
You can build very powerful and flexible text-formatting solutions in SQL Server. Learn how to apply techniques that handle the simplest to the more complex text-formatting tasks.
2006-06-20
3,557 reads
SQL Server 2005 - Unattended installation - Part I
Automating the installation of SQL Server was made simple in SQL Server 2005. SQL Server 2005 can be installed using a GUI, an ini file or just run setup.exe with a bunch of parameters.
2006-06-19
2,304 reads
Executing SQL Stored Procedures from inside a Web Application
This article, the last in the Stored Procedure series, will focus on RETURN parameters.
2006-06-16
4,328 reads
Blogs
“We love to debate minutiae”
By Brian Kelley
I am guilty as charged. The quote was in reference to how people argue...
Advice I Like: Knots
By Steve Jones
Learn how to tie a bowline knot. Practice in the dark. With one hand....
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...
Forums
Windows logins for users migrated from DomainA to DomainB
Hi, I have a SQL Server instance where users connect to via Windows Authentication,...
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...
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