Determining SQL Server database storage requirements
Determine accurate storage requirements for a SQL Server database with these methods. Calculate how to set storage requirements for a database application.
Introduction to SSIS in SQL Server 2005
DTS was one of the true innovations in SQL Server 7. SQL Server 2000 greatly enhanced this tool and SQL Server 2005 makes it truly a programming environment, well beyond the ETL functions of DTS in SQL Server 2000. New author Vinod Kumar gives a brief introduction to this new environment.
More Layers - iPod
Less CIOs are reporting to CEOs this past year. Is that a problem? Steve Jones offers some comments.
More Layers - MP3
Less CIOs are reporting to CEOs this past year. Is that a problem? Steve Jones offers some comments.
More Layers - WMV
Less CIOs are reporting to CEOs this past year. Is that a problem? Steve Jones offers some comments.
Copyright at SQLServerCentral.com
Just to set the record straight, if you submit something you keep the copyright.
Designing an Entity Data Model
The Entity Framework is an exciting new technology being developed for ADO.NET. It allows developers to view data using a logical model instead of a physical model, offering more flexibility.
Solving the "Running Total" & "Ordinal Rank" Problems in SS 2k/2k5
Learn how to solve a couple of common T-SQL issues with MVP Jeff Moden.
SQL Server 2005: Intro to XQuery
Longtime SQL Server expert Michael Coles brings us the second part of his his introductory look at XML in SQL Server 2005 with a short examination of XQuery, the way in which you can write queries on XML data.
Blogs
How to Find Expensive Queries in Amazon Redshift
Slow-running queries can degrade your Redshift cluster’s performance and lead to increased costs. Identifying...
The Notification Trap: How Input Fatigue Is Killing Deep Work in Tech
By gbargsley
If you've been here before, you know this blog is usually about SQL Server,...
Designing a Storage Load Test for SQL Server
I’ve been doing storage load tests for SQL Server for a long time, both...
Forums
SQL 2019 instance with AG, across 2 Windows 2016 OS servers - OSin-place upgrade
Hi all Can I get some perspective from the community please on performing in-place...
How Long is a Long I/O?
Comments posted to this topic are about the item How Long is a Long...
T-SQL Trigonometric Functions in SQL Server
Comments posted to this topic are about the item T-SQL Trigonometric Functions in SQL...
Question of the Day
How Long is a Long I/O?
In SQL Server 2025, a long I/O is recorded in the error log with message 833. How long much an I/O request be outstanding before this message is written to the log?
See possible answers