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.
SQL Server non-clustered indexes for query optimization
Optimize SQL Server non-clustered indexes and queries by considering index fields, compound indexes and SQL Server statistics' impact on non-clustered indexes.
Using the script task to dynamically build SSIS package variables
Expressions can be used to dynamically build an output file. Here we will show you another way to do this using the script task.
Blogs
Fabric Mirroring doesn’t start copying Rows
A short blog post about an issue with Fabric Mirroring (with Azure SQL DB...
JSON_OBJECTAGG is an Aggregate: #SQLNewBlogger
By Steve Jones
I wrote an article recently on the JSON_OBJECTAGG function, but neglected to include an...
Cultural Change: Fostering a Cost-Aware Culture in Your Organisation
By HeyMo0sh
After working deep in cloud operations, I’ve learned that FinOps isn’t really about dashboards...
Forums
Creating a JSON Document I
Comments posted to this topic are about the item Creating a JSON Document I
Who is Irresponsible?
Comments posted to this topic are about the item Who is Irresponsible?
Designing Database Changes Before Deployment: Level 1 of the Stairway to Reliable Database Deployments
Comments posted to this topic are about the item Designing Database Changes Before Deployment:...
Question of the Day
Creating a JSON Document I
I want to create a JSON document that contains data from this table:
TeamID TeamName City YearEstablished 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933If I run this code, what is returned?
SELECT json_objectagg('Team' : TeamName)
FROM dbo.NFLTeams;
See possible answers