Deploying Databases From Visual Studio Team System Database Edition
With the GDR release, a whole new set of deployment functionality has become available to VSTS: DB.
2009-06-24
5,536 reads
Articles
Practical Database Change Management (Part 1)
Changing a database an integral and crucial part in every application's life cycle. Part 1 of this series looks at the steps and procedures prior to implementing the change
2009-06-24
3,907 reads
Retaining historical index usage statistics for SQL Server - Part 2
We look at performing the same task for the sys.dm_db_index_operational_stats Dynamic Management Function (or DMF.) The process is identical, the code is however quite different due to the structural differences between sys.dm_db_index_usage_stats and sys.dm_db_index_operational_stats.
2009-06-24
2,265 reads
Tips on Getting HIred – Part 3
Part 1 discussed ways to find opportunities, Part 2 was about how to get more interviews, and today we’ll cover some tips from the employer perspective. Don’t use an AOL.com email address. Seriously. Gmail, Live, Yahoo, all are good, but AOL.com makes...
2009-06-24
2,538 reads
Adding a Computed Column to a Table (1) - SQL School Video
In this SQL School video, Andy Warren shows how you can alter a table to add a computed column. This is part 1 of 2.
2009-06-23
4,650 reads
Capturing I/O patterns using Process Monitor
In this article, Edward Elliot shows us how to capture the types, size and location of SQL Server I/O requests.
2009-06-23
9,815 reads
Expect an Attack
Most companies in a recent survey expect to get hacked this year. Steve Jones wishes that the technological leaders would help everyone develop more secure code by publishing more information.
2009-06-23
927 reads
Expect an Attack
Most companies in a recent survey expect to get hacked this year. Steve Jones wishes that the technological leaders would help everyone develop more secure code by publishing more information.
2009-06-23
734 reads
Expect an Attack
Most companies in a recent survey expect to get hacked this year. Steve Jones wishes that the technological leaders would help everyone develop more secure code by publishing more information.
2009-06-23
683 reads
Introducing Change Tracking in SQL Server 2008
Yan Pan demonstrates how to set up Change Tracking on a table in the AdventureWorks2008 database and how to query the changed data.
2009-06-23
3,681 reads
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
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...
Half of All Engineers
Comments posted to this topic are about the item Half of All Engineers
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