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.
This is the eighth article in a continuing series, and this installment discusses the Data Steward Coordinator.
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.
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.
A new technology could be a boon for database servers, dramatically increasing the amount of memory available for SQL Server.
Steve Jones looks ahead to an interesting trip for the future of a couple of technical geeks.
Steve Jones looks ahead to an interesting trip for the future of a couple of technical geeks.
Steve Jones looks ahead to an interesting trip for the future of a couple of technical geeks.
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.
Optimize SQL Server non-clustered indexes and queries by considering index fields, compound indexes and SQL Server statistics' impact on non-clustered indexes.
Expressions can be used to dynamically build an output file. Here we will show you another way to do this using the script task.
By DataOnWheels
Over the past couple of months, I have started losing my ability to talk...
By Steve Jones
apolytus– n. the moment you realize you are changing as a person, finally outgrowing...
If you've ever wrestled with complex SQL code, you know the drill. Hours spent...
Comments posted to this topic are about the item Do you listen to music...
I have a job running each night starting at 4:30AM and usually finishing at...
hi guys, I have a partitioned table AM_ITM_INSTNC_MSS and I want to get...
Our environment runs using SQL Server Standard. We are implementing Availability groups. Our database has been experiencing high read volumes, so I want to let the application read the Synchronized Secondary replica, as I read that HADR does this. Can we implement this?
See possible answers