Top 10 Enhancements in SQL 2005 Notification Services
In this article, we examine some of the best new features and characteristics available in the 2005 version.
2006-09-04
1,994 reads
Articles
Save and Retrieve Datasheet Layout with the Windows Registry
Danny Lesandrini shares a block of code that will allow users to modify (and save) datasheet layout when they are using a compiled MDE version of your Access applications.
2006-09-01
2,257 reads
Spotlight on SQL Server with Slava Oks
The next installment of our series on the developers behind SQL Server takes a few minutes with SQL Server Storage Engine export Slava Oks.
2006-08-31
4,584 reads
Mastering OLAP Reporting: Prototype KPIs in Reporting Services
Need a quick KPI prototype, using Reporting Services / Analysis Services 2000 or 2005? BI Architect Bill Pearson leads hands-on practice in presenting simple KPIs to management with Reporting Services.
2006-08-31
2,834 reads
A Technique for Determining the I/O Hog in your Database
Performance Tuning can be as much an art as a science when working with SQL Server, but there are many fine techniques that can help you get started. New author Michael Morin brings a great new technique helping you get started on determining where the heavy I/O users are in your database.
2006-08-30
22,767 reads
Getting Warmer - How to Implement Hot Failover in .NET 1.1 with SQL 20
What happens if you try to specify a Failover Partner in .NET 1.1?
2006-08-30
1,245 reads
Looping Through and Loading Files with SSIS
In this presentation, you'll learn how to use the ForEach Loop Container to loop through a folder and load each file in the directory. This presentation uses variables to dynamically configure the package so nothing is hard coded.
2006-08-30
2,171 reads
Building Automated Backups
Backups are the foundation of any well run database server, or even any computer system. Numerous articles have been written about SQL Server backups and new author Paulo Luis brings us a new twist on building automated backups using devices.
2006-08-29
12,747 reads
Career Paths for Programmers
The key to maintaining a good employment outlook in IT, it seems, is to move out of programming and up into more business-oriented IT positions such as systems analyst, business analyst, project manager, or systems architect. However, a computer programmer can't just decide to become a systems analyst or project manager overnight.
2006-08-29
3,402 reads
Clustering SQL Server 2005
With Windows 2003 now clustered, you're ready to begin to clustering SQL Server 2005. In this presentation, you'll see how to cluster SQL Server 2005 and some best practices in how to configure the SQL Server cluster after the fact.
2006-08-29
2,982 reads
Blogs
Attacking the Weakest Link
By Brian Kelley
When I look at a system and think about its security model, the first...
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...
Forums
Multiple processes accessing the same table. some to write others to read / Lock
Dears, Hope this message finds you well We have a log table which is...
The Backup File Extension
Comments posted to this topic are about the item The Backup File Extension
Ingest and Retrieve data from an ADX Cluster Using Python
Comments posted to this topic are about the item Ingest and Retrieve data from...
Question of the Day
The Backup File Extension
I run this command in SQL Server 2022. What is the extension of the backup file?
BACKUP DATABASE HerdofTwo TO DISK = 'HerdOfTwo_20240501'See possible answers