Create a Custom Test Interface Provider for Team Sytem
This article looks at fuzzy testing and how to build a provider for your own use.
SQL Server 2005 Database Options and Configuration Performance Audit Checklist
As part of your performance audit, you will need to examine each database located on each of your SQL Server instances and examine some basic database settings.
Rethinking Analysis Services
Integrate SQL 2005, ASP.NET, Reporting Service and Analysis Services to rapidly develop and deploy a survey application for data entry and results analysis.
Brad McGehee On Being a Better DBA!
Brad McGehee discusses the career path of a professional database administrator. Often the DBA role is thrust upon an IT professional or developer without much in the way of specific training. Growing into the role is largely a self-motivated exercise. Brad talks about the habits that successful DBAs have, focused on on-going education and working to protect their organizations data.
Calculate Percentiles with SQL Server 2005
Learn one of the techniques for calculating percentiles with SQL Server 2005 using the new SQL Server Common Table Expression and the latest ROW_NUMBER function.
Incommunicado
Communication is important, and it's a real problem when people can't reach you. Read about an interesting phone accident the some hints for better communication.
TSQL Lab I - Playing around with ROW_NUMBER
Real world solutions are key and having different techniques can sometimes help you code quicker. Longtime author Jacob Sebastian shows us how to solve a few problems with different techniques.
Populating Dimension Tables with the SCD Task
ETLing dimensions through SQL Server 2000 DTS, has more or less been quite a hassle, what with the lengthy ActiveX scripts and lookups that have to be performed. Enter SQL Server 2005 Integration Services: The Slowly Changing Dimension task has made it much simpler.
Snapshot Reports I: Report Manager Perspective
BI Architect Bill Pearson continues his subseries surrounding Caching Options, examining the use of Report Manager to configure Snapshot Caching.
Blogs
T-SQL Tuesday #198 Invitation: How Do You Detect Data Changes?
It's time for T-SQL Tuesday #198! This month's topic is change detection. The post T-SQL...
Understanding Fabric MCP
By James Serra
Model Context Protocol, or MCP, is one of those technical ideas that sounds more...
AWS RDS Aurora - our first approach
When starting with AWS RDS Aurora for managing relational databases in the cloud, many...
Forums
BCA KCP Sunrise Garden TLP/WA 08216366654
Blok V, Jl. Surya Utama No.31, Kedoya Utara, Kec. Kb. Jeruk, Kota Jakarta Barat,...
Alamat kantor resmi BCA KCP Dakota Telp:083178278662
Wa:083178278662Jl. Dakota No.Raya 42, H dan 46, Sukaraja, Kec. Cicendo, Kota Bandung, Jawa Barat...
BCA KCP Taman Permata Buana TLP/WA 08216366654
Blok D1, Ruko Taman Permata Buana, Jl. Pulau Bira III 36-37, Kembangan Utara, Kec....
Question of the Day
May the Fourth Be With You Fun
In honor of May the fourth and Star Wars (may the force be with you), finish this quote:
"Do, or do not. ..."See possible answers