Masking Data
As DBAs we go to great lengths to ensure the security of our production data. But what happens when it moves off of a production server?
Masking Data
As DBAs we go to great lengths to ensure the security of our production data. But what happens when it moves off of a production server?
The Stewardship Approach to Data Governance: Chapter 8
This is the eighth article in a continuing series, and this installment discusses the Data Steward Coordinator.
Backing Up a Database with SMO
In SQL Server 2005, the management object framework changed substantially from the DMO framework in prior verisons. Now we have SMO, RMO, and other .NET assemblies that can be used to manage SQL Server. New author Brandie Tarvin brings us a short look at how SMO can be used to perform one of those critical tasks in SQL Server.
Simple Method for Importing Ragged files
This article explains how to import text files using SSIS in those cases where the text files have different formatted data on different rows. The solution recommended involves minimal coding and is highly maintainable.
Terry-bites
A new technology could be a boon for database servers, dramatically increasing the amount of memory available for SQL Server.
Dreams of the Future
Steve Jones looks ahead to an interesting trip for the future of a couple of technical geeks.
Dreams of the Future
Steve Jones looks ahead to an interesting trip for the future of a couple of technical geeks.
Dreams of the Future
Steve Jones looks ahead to an interesting trip for the future of a couple of technical geeks.
How Much Training Data Is Enough?
This tip shows you how you can apply the cross-validation feature in the upcoming SQL Server 2008 release to estimate if the training set size is sufficient for a given model.
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 Pantai Indah Kapuk Tlpn/Wa 0853.7373.7551
Jl. Pantai Indah Selatan Blok DF No.1 & 2, Kapuk Muara, Kecamatan Penjaringan, Jkt...
BCA KCP Tebet Barat 2 Telpon/WA:08137887595
BCA KCP Tebet Barat 2 Telpon/WA:08137887595.Jl. Tebet Raya No.25 B Blok CI, Tebet Tim.,...
BCA KCP Puri Deltamas Tlpn/Wa 0853.7373.7551
Komplek Ruko Puri Deltamas Blok J. 5, Jl. Bandengan Sel. No.43, Daerah Khusus Ibukota...
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