Data with Provenance
File systems and document databases are the wild lands of data privacy. Phil Factor explains the value of JSON Schema in adding provenance to your document data.
Adding a Primary Key to a Prepopulated Table using a SQL Server Integration Services Package
In this tip we look at how you can use SSIS to build a package to add a primary key to an existing table that does not already have a primary key.
The Curse of Cursor Options
Books Online says the FAST_FORWARD option has "performance optimizations enabled," but they didn't say if they were good. It turns out they're not.
T-SQL Decommenter Part IV
Examination of the comprehensive test suite for the T-SQL Decommenter, along with explanation of the modifications made to produce the production version.
Meeting Preparation for SQL Server Projects
Learn how to prepare for technical meetings including knowing your environment, being calm, business values, solution focus and more.
Mitigate Issues Early
When you know there's a problem, it's better to solve it early rather than late.
SQL Server on Amazon Web Services (AWS)
Relational Database Service (RDS) and Amazon Elastic Compute Cloud (EC2) are two different approaches, with their own advantages and limitations, for making Microsoft SQL Server (MS SQL Server) available and maintaining MS SQL Server databases on Amazon Web Services (AWS).
Building Better Training Opportunities
Finding training opportunities can be a challenge in many organizations.
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
BCA KCU WAHID HASYIM Tlpn/wa0853.7373-7551
Tlpn/wa0853.7373-7551 Jl. K.H. Wahid Hasyim No.183 A-B, Kb. Kacang, Kecamatan Tanah Abang, Kota Jakarta...
Bagaimana Cara menghubungi CS Transnusa
Hubungi Layanan Call Center Transnusa melalui di nomor WhatsApp 0821-3111°157. Layanan Bantuan Tersedia 24/7...
BCA KCP Senayan City Tlpn/wa0853.7373-7551
Mall Senayan City Unit 6-09A, Jl. Asia Afrika Lot 19, Daerah Khusus Ibukota Jakarta...
Question of the Day
SSoL Support on the OS
On which Linux versions is SQL Server 2025 on Linux supported?
See possible answers