Articles

Technical Article

Michael Rys on XML in SQL Server 2005

Michael Rys is one of two program managers responsible for the XML features in SQL Server. He also represents Microsoft on the W3C XQuery Working Group, and on the ANSI working group for SQL. I asked him what is distinctive about the XML support in SQL Server 2005, as opposed to that found in rival database management systems. As Rys acknowledges, "all the three major vendors, Oracle, IBM and Microsoft, are moving towards second or third generation suppor

2005-08-04

1,979 reads

External Article

SQL Server Integration Services - Part 5

We will continue our review of Foreach enumerators starting with Foreach ADO, since this one probably qualifies as the most popular choice in its category. This is due to the fact that ADO recordsets offer a convenient way of dealing with data sources, regardless of their type (for example, within SSIS, you can easily populate a recordset by executing a SQL query or by reading the content of a flat file)

2005-08-01

1,791 reads

External Article

Attack of the predatory sales force

Most skilled professionals—be they butchers, bakers or software makers—take pride in selecting their own tools of the trade. Why is it then that developers and DBAs in large corporations often are not afforded the same professional courtesy or opportunity? The tools they use are just as vital to their livelihood, yet when it comes to high-cost software, developers and DBAs often have no input into what is purchased for their use.

2005-07-29

2,572 reads

External Article

The identity crisis in replication

This article discusses three common problems DBAs are likely to encounter when columns have the identity property, which is defined as an attribute of int, smallint, bigint, decimal, numeric or tinyint columns that will auto-increment their value when data is inserted. These problems are humorously referred to as the identity crisis.

2005-07-28

3,765 reads

SQLServerCentral Article

Employee Retention

A SQL Server DBA seems to be a stable job and many of us stick with the same job for an above average length of time. However employee retention in general is important to a strong and healthy company. Steve Jones starts a new series looking at this topic and why an employer might want to worry about retention.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(1)

You rated this post out of 5. Change rating

2005-07-27

12,923 reads

Blogs

Overcoming Imposter Syndrome: A Plan

By

My most recent bout with imposter syndrome was with ISACA’s Digital Trust Ecosystem Framework...

Advice I Like: Celebrate Success

By

“On the way to a grand goal, celebrate the smallest victories as if each...

Programmatically Retrieving MLV Lineage and Refresh Times

By

Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...

Read the latest Blogs

Forums

BCA KCP Utan Kayu No tlpon:083138717148

By labmate

Whatsapp:083138717148.Jl. Utan Kayu Raya No.94, RT.12/RW.10, Utan Kayu Utara, Kec. Matraman, Kota Jakarta Timur,...

BCA KCP Kas Pegambiran Telp:Cs.WA:0831•7943•7466

By imranali1290

WhatsApp 0831•7943•7466 Jl. Pegambiran No.2B, RT.12/RW.7, Jati, Kec. Pulo Gadung, Kota Jakarta Timur, Daerah...

BCA KCP Anyer Telpon. 08388331767

By janehui

WhatsApp 08388331767 Jl. Raya Anyer-Sirih Kp. Gudang Areng, RT.04/RW.05, Anyar, Kec. Anyar, Kabupaten Serang,...

Visit the forum

Question of the Day

Increase Deadlock Detection

How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?

See possible answers