The Stewardship Approach to Data Governance: Ch 7
This is the seventh article in a continuing series, and this installment discusses the tactical layer of the Data Governance Framework.
2008-02-28
1,423 reads
Articles
Coping with No Column Names in the SSIS OLEDB Data Source Editor
Longtime author Paul Ibison brings us a short look at a common problem in Integration Services: your source has no column names.
2008-02-27
7,479 reads
New Isolation Levels Available in SQL Server 2005
One of the more mysterious features of SQL Server is isolation levels. Whenever a statement is executed, or a data modification is made, it runs under the influence of an isolation level. Traditionally, SQL Server has supported four isolation levels. In SQL Server 2005, two new isolation levels are introduced.
2008-02-27 (first published: 2007-03-05)
3,652 reads
SQL Server 2008 - Table Valued Parameters
In this screencast, we look at Table Valued Parameters from both the server side and client side perspectives.
2008-02-27
2,499 reads
Writing Outer Joins in T-SQL
Occasionally someone will ask for my help with a query and say that both a right outer join and a left outer join was tried, and still the expected results were not achieved. That made me realize that some developers do not completely understand outer joins and that an article explaining how to use them might help.
2008-02-27
7,220 reads
Ideas for SQLServerCentral.com
We're embarking upon a rebuild of the site and we're looking for input from those of you that use the site.
2008-02-26 (first published: 2007-02-26)
1,736 reads
Snapshots - Part 1
Longtime replication expert Andy Warren takes a look at the initial snapshots involved with replication and dives into an explanation of what's involved.
2008-02-26
2,642 reads
Using the ReportViewer Control in a WebForm with Parameters
A short article by Darren Herbold, reporting services trainer and consultant that shows how you can easily use a Report Viewer on a web page.
2008-02-26
11,544 reads
Blast Off
SQL Server 2008 launches today and there's are additional events all across the country coming up.
2008-02-26
29 reads
Blast Off
SQL Server 2008 launches today and there's are additional events all across the country coming up.
2008-02-26
38 reads
Blogs
Measuring RAG Solutions: Are We Retrieving the Right Information?
A RAG pipeline that answers questions in the demo is not the same thing...
Advice I Like: Lots of Ideas
By Steve Jones
“A multitude of bad ideas is necessary for one good idea” – from Excellent...
Building a DBA Agent for Your SQL Server Estate with MCP
Yesterday I gave a talk for MSSQLTips called “Building a DBA Agent for Your...
Forums
How do I connect to a SQL Server database on my ISP?
I've got a web application for my side business. I've added a SQL Server...
Looking for New Blood
Comments posted to this topic are about the item Looking for New Blood
Server-Level Row Counts for Tables and Views
Comments posted to this topic are about the item Server-Level Row Counts for Tables...
Question of the Day
Hyperscale Replicas I
What types of secondary replicas are available for the Azure SQL Database Hyperscale edition?
See possible answers