Fine Tuning your Database Design in SQL 2005
Sanchan Saxena gets to grips with the new index-tuning tools and features in SQL 2005
2006-10-17
3,510 reads
Additional Articles
Design Challenge: Global Address
Are you up to the latest design challenge? A great way to sharpen our analysis and modeling skills is to continuously address real-world scenarios. A modeling scenario with suggested solutions appears each month in this Design Challenge column. The scenario is emailed to more than 1,000 modelers. The responses are then consolidated into this column.
2006-10-16
2,039 reads
Executing all SSIS packages in a folder: three methods
This article examines a variety of ways in which you can execute all the SSIS packages in a folder.
2006-10-13
1,958 reads
Rename DTS Tasks for Clear Log Text
This Script will create a copy of your DTS Package; append "_Renamed" to the end of the package name; and rename every task and step in the copied package to Task/Step_TaskType_DescriptionText_Sequence. The resulting package will lose all of it's text annotations, the layout will be the designer default rather than the original latout. It can […]
2006-10-12 (first published: 2005-01-05)
126 reads
Anticipate the worst when developing SQL Server databases
Arthur Fuller advises DBAs to try to break their software in order to make sure their SQL Server databases can withstand potential attacks. See if your code can hold up to his suggested tests.
2006-10-12
3,499 reads
Dealing with Database Concurrency Conflicts in the Real World
Database concurrency conflicts are somewhat of a plague in software development because they're hard to predict and handle. Unfortunately, they're also hard to prevent.
2006-10-11
2,638 reads
Executing predictions from the SQL Server relational engine
This tip shows you how to execute and use the results of prediction queries in multiple ways within the SQL Server relational database engine.
2006-10-10
2,466 reads
SQL Server 2005 Large Value Data Types
Microsoft has come to the rescue for managing large text fields in SQL Server 2005, by creating a few new large value data types. This article explores these new data types.
2006-10-09
2,297 reads
Beginning SQL Server 2005 Reporting
In Part 1 of this article, we looked at the basics of SQL Server Reporting Services 2005 (SSRS). We built one report with the Report Wizard, and one report using the Report Designer. In Part 2, we are going to look in more depth at the features that you can use everyday as an SSRS developer.
2006-10-06
3,902 reads
Configuring Design DB for Team Edition for Database Professionals
This video by Richard Waymire will describe how to install and configure SQL Server 2005 to support Visual Studio Team Edition for Database Professionals database projects.
2006-10-06
2,081 reads
Blogs
Migrate datetime data to datetimeoffset with AT TIME ZONE
By Will Assaf
I recently reviewed, worked on, and added a similar example to the DATETIMEOFFSET Microsoft...
The Comprehensive Guide to Mastering Your SQL DBA Skills
Database administrators (DBAs) are the backbone of data-driven organizations. If you're looking to break...
Friday Basics: Authentication vs. Authorization
By Brian Kelley
Another security fundamentals topic is authentication versus authorization. For those who have a clear...
Forums
The OS returned the error '(null)' while attempting 'DeleteFile' filestream.hdr
I have a SQL Server 2019 Enterprise Edition on CU 25. It has in-memory...
Performance
Experts, I am learning some skills so I can troubleshoot some performance-related issues. I...
Question of the Day
Two Table Hints
What happens when I run this code:
SELECT p.ProductName , p.ProductCategory FROM dbo.Product AS p WITH (NOLOCK, TABLOCK);See possible answers