Loading XML data into SQL Server 2008
This article provides a step by step guide on how to create and configure an SSIS package which can be used to import XML data
The July Car Update (2008)
With the price of gas rising and no end in sight. Steve Jones steps back to talk a bit about what solutions there might be to ease the burdens on everyone.
The July Car Update (2008)
With the price of gas rising and no end in sight. Steve Jones steps back to talk a bit about what solutions there might be to ease the burdens on everyone.
The July Car Update (2008)
With the price of gas rising and no end in sight. Steve Jones steps back to talk a bit about what solutions there might be to ease the burdens on everyone.
The Myth of Over-Normalization
Too often, denormalization is suggested as the first thing to consider when tackling query performance problems. It is said to be a necessary compromise to be made when a rigorous logical design hits an inadequate database system. As the saying goes, “Normalize ‘til it hurts, then denormalize ‘til it works”. In reality, Denormalization always leads eventually to tears.
The More Things Change ...
Steve Jones talks about how IT hasn't changed very much over the years and how your career might not be that different in ten years.
The More Things Change ...
Steve Jones talks about how IT hasn't changed very much over the years and how your career might not be that different in ten years.
Service Accounts
A Friday poll from Steve Jones looks at service accounts and how you deal with passwords.
SQL Server Security: Pros and Cons of Application Roles
Application roles often interesting possibilities in theory. In practice? Brian explores how they work and some of the pros/cons you should consider before selecting them for use in your applications.
How to configure and Use Database Backup Compression in SQL Server 2008
SQL Server 2008 introduces the Database Backup Compression feature. This article describes how to take advantage of this new feature
Blogs
Programmatically Retrieving MLV Lineage and Refresh Times
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Upgrading SQL Server Containers on the Laptop
By Steve Jones
I don’t have SQL Server installed on my laptop. In an effort to keep...
Forums
BCA KCP Altira Sunter Tlpn/Wa 0853.7373.7551
Altira Bussiness Park, Jl. Yos Sudarso Kav 85 Blok B No.1-2, Sunter Jaya, Kec....
BCA KCP Soepomo Telpon/WA:08137887595
BCA KCP Soepomo Telpon/WA:08137887595.Alun Graha, Jl. Prof. DR. Soepomo SH No.233 Lt. Dasar, RT.007/RW.1,...
BCA KCP Teluk Mas Tlpn/Wa 0853.7373.7551
Komplek Ruko, Jl. Soka 1 Jl. Terusan Bandengan Utara No. 95 G-H, Pejagalan, Kecamatan...
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