Essential Steps for the Integrated Enterprise Data Warehouse, Part 1
This article provides guidance to what an integrated EDW is and what design elements are needed to achieve integration.
2008-05-13
2,998 reads
Additional Articles
SQL Server Management Studio Reports and Dashboard
This article examines the built in reports called SQL Server Management Studio Reports and an additional add-on called Performance Dashboard.
2008-05-13
5,062 reads
Screencast: SQL PerfMon counters for buffer manager
SQL Server MVP Kevin Kline focuses on PerfMon counters for SQL Server and shares best practices for tracking IO intensive access methods and buffer manager activity.
2008-05-12
2,558 reads
Tuning the Performance of Backup Compression in SQL Server 2008
ckup compression is a new feature in SQL Server 2008 that can help provide smaller sized backups and reduce backup time. This document provides guidance related to tuning options for backup performance. All of the information and test results presented here were done specifically by using the backup compression feature of SQL Server 2008; however, they apply broadly to any backup scenario whether backup compression is used or not
2008-05-12
2,214 reads
Scalability and Goal Testing for Developers
Often developers are tasked with not only developing functional code, but also with ensuring that the code they develop scales well and performs in the application environment.
2008-05-09
2,508 reads
Best Practices for Troubleshooting Slow Running Queries
In this article we will share some of the common reasons for slow-running queries and what your approach should be for identifying and fixing them.
2008-05-08
8,233 reads
Testing SQL Stored Procedures Using LINQ
The need to test a program that accesses and manipulates a back-end SQL Server® database is very common. In many such cases, the application interacts with the back-end data through the use of SQL stored procedures. In this type of scenario, you can think of the stored procedures as auxiliary methods of the system under test; and they must therefore be tested just like any other module in the system.
2008-05-08
4,526 reads
Constructing XML using 'FOR XML'
Over the past few years, software developers have used various kinds of technologies to retrieve data from relational databases. SQL Server 2000 is the first Microsoft DBMS to fully support XML. In this article the author concentrates on the FOR XML clause in SQL Server versions, 2000 and 2005. Click on title for more
2008-05-07
2,498 reads
Slowly Changing Dimensions in SQL Server 2005
This article explores the options available in SQL Server 2005 for Slowly Changing Dimensions.
2008-05-07
3,048 reads
Simplify SQL Server 2005 queries with a Dates table
Learn what a Dates table is and how to create one, and then try it out for yourself
2008-05-06
5,831 reads
Blogs
A Pursuit of Lifelong Learning
By Brian Kelley
The following came across my YouTube feed today. It’s an interview with General James...
Advice I Like: Time and Focus
By Steve Jones
“You don’t need more time because you already have all the time that you...
Book Review: Microsoft 365 Copilot and Agent Administration Fundamentals
I don’t currently manage Microsoft 365 Copilot in an enterprise environment, but it is...
Forums
Alamat Telp BCA KCP Cipanas Cs 0823-7497-7784
Wa:082374977784 Jl. Raya Cipanas, Gadog, Kec. Pacet, Kabupaten Cianjur, Jawa Barat 43253
Alamat dan Kontak J&T Cargo Makassar
•Nama Mitra: J&T Cargo UPG013A •Alamat: jl. Kerung kerung no 7 A •Kota Makassar...
Alamat dan Kontak J&T Cargo Makassar
•Nama Mitra: J&T Cargo UPG001A • Alamat: BTP Blok E No.6, Tamalanrea, Kec. Tamalanrea,...
Question of the Day
DML Trigger Types
How many types of DML triggers are there?
See possible answers