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
Articles
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,788 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
SSIS At Christmas
Due to overwhelming demand, we've opened up another Integration Services class. Start Christmas vacation early in Orlando on Dec 18.
2006-08-28
2,171 reads
The Report Builder
Andy Warren brings us an introduction the the Report Builder in SQL Server 2005. It's the less often used tool for developing and customizing reports that you can give to end users and lower the number of requests your developers receive.
2006-08-28
7,922 reads
SQL Server 2005 Integration Services - Performance - Part 30
The superiority of SSIS over DTS goes beyond functionality alone, providing numerous efficiency benefits, which we will present in more detail in this article.
2006-08-28
2,056 reads
Using the OUTPUT Clause to Capture Identity Values on Multi-Row Insert
SQL Server 2005 introducted the OUTPUT clause which we can use to capture values from the inserted and deleted virtual tables.
2006-08-25
4,352 reads
SQL Server Spotlight on Eric Lee
A slight departure from the usual Spotlight series. We have Eric Lee, project leader for the Team Foundation Server. It's not a part of SQL Server, but it's a product that many DBAs will get exposed to. Read on about another interesting member of the Microsoft development team.
2006-08-24
3,071 reads
Blogs
Advice I Like: Respect
By Steve Jones
“Don’t aim to have others like you; aim to have them respect you.” –...
Blue Sky Programming – The Optimism Trap
Many years ago, before I joined Oracle, I was working on a major modernisation...
Setting Up a Mac for Data Engineering and AI Work
If you work with data pipelines, SQL, notebooks, or machine learning models, a Mac...
Forums
SQL Art, Part 4: Happy 4th of July — A British DBA's Guide to Celebrating a War We Don't Talk About
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
Alamat kantor BCA KCP Galuh Mas Telp:0817866887
WhatsApp:0817-866-887 Area Street Festival, Ruko No 1 & 1A, CBD, Jl. Galuh Mas Raya,...
Is Fabric a Reliable Service or a Ripped Resource?
Comments posted to this topic are about the item Is Fabric a Reliable Service...
Question of the Day
BIT_COUNT I
In SQL Server 2025, I have a table (dbo.UserPermission) that contains this data:
UserID UserPermissions 15 23 37What is returned when I run this code:
select bit_count(UserPermissions) as PermissionCount from dbo.UserPermission where UserID = 3;See possible answers