Assumptions
For this Friday poll, Steve Jones asks about assumptions that cause you problems at work.
Dynamic creation of Insert, Update, Delete Stored procedures
Automates the creation of INSERT, UPDATE & DELETE stored procedure of a table
Building a Data Warehouse Blueprint for Success
One of the most integral components and critical success factors of any enterprise data warehousing initiative is the Solutions Architecture document, a high-level conceptual model of a data warehousing solution. Learn why this collaborative effort that addresses the needs of all major stakeholders, including both the business units and Information Technology (IT), is essential.
Developing Modifications that Survive Concurrency
You can create a database under the assumption that SQL looks after all the problems of concurrency. It will probably work fine under test conditions: then, in the production environment, it starts losing data in subtle ways that defy repetition. It is every Database Developer's nightmare. In an excerpt from his acclaimed book, Alex Kuznetsov explains why it happens, and how you can avoid such problems.
How well do you really know your colleagues?
Take your peers out of their comfort zone and do you know how well they'll perform?
SQL Server 2008 Table Valued Parameters Performance
An article from Scott Zurolo tests the terformance of SQL Server 2008 Table Valued Parameters against more traditional methods of updating many rows at once.
How to add NULL Defense to your SSIS packages using scripting
In this part of NULL Defense series, we will discuss how to create NULL Defense in Script Transformation.
Find the Port a Connection is Using
If you have multiple ports, this article from Mark Greenbaum will tell you which port a connection is using
Leanring from Experts
A guest editorial from Andy Warren. Experience helps us do a better job, and one way you can get that is learning from experts.
Data Warehousing Architecture - Designing the Data Staging Area
The staging area tends to be one of the more overlooked components of a data warehouse architecture, and yet it is an integral part of the ETL component design. Learn why it is best to design the staging layer right the first time, enabling support of various ETL processes and related methodology, recoverability and scalability.
Blogs
PlanTrace Now Supports PostgreSQL
PlanTrace Now Supports PostgreSQL The same plan analysis you know from...
A New Word: the Kinder Surprise
By Steve Jones
the kinder surprise – . the point in your early adolescence when you realize...
Crash-Consistent Snapshot Cloning - Hyper-V Edition
If you’ve been following my T-SQL Snapshot Backup series, most of what I’ve covered...
Forums
Alamat kantor BCA KCU ASEMKA Telp/WA.0821°3111°179
Telp/WA.0821°3111°179 Jl. Asemka No.27-30, Pinangsia, Kec. Taman Sari, Kota Jakarta Barat, Daerah Khusus Ibukota...
BCA KCU ASIA CSTelpon : 0853-73737551
Jl. Asia, Simpang, Jl. Bakaran Batu No.1 C, Sei Rengas II, Kec. Medan Area,...
BCA KCP Tebet Barat 2 Telpon/wa.085373737699
BCA KCP Tebet Barat 2 Telpon/wa.085373737699.Jl. Tebet Raya No.25 B Blok CI, Tebet Tim.,...
Question of the Day
SSoL Support on the OS
On which Linux versions is SQL Server 2025 on Linux supported?
See possible answers