XML Workshop XIV - Generating an XML Tree
Continuing on with his comprehensive series on XML, Jacob Sebastian shows us how to generate a tree of parent-child data using XML.
2008-02-13
7,842 reads
Articles
Implementing a Generic Data Access Layer in ADO.NET Part 2
In Part 2 of a 3 Part Series Joydip Kanjilal discusses the implementation of a provider independent Data Access Layer in ADO.NET.
2008-02-13
2,643 reads
Operational BI: Getting 'Real Time' About Performance
Operational business intelligence is about delivering information to people when and how they need it in the context of business need. Explore the five best practices best-in-class companies are using to drive faster, better decision making and higher customer satisfaction.
2008-02-13
2,436 reads
Computed Columns
Computed columns are an interesting way to cover some queries that might otherwise require a table scan. SQL Server expert Andy Warren brings us a look at this database design feature.
2008-02-12
13,009 reads
Maximum Row Size in SQL Server 2005
What is the page size in SQL Server 2005? That's an easy question, but what is the maximum row size? They're not the same thing and ANdy Warren shows you why.
2008-02-12 (first published: 2007-02-27)
25,437 reads
Ninja's Return
One of our top posters and valuable member of the SQLServerCentral.com community weighs in on his absence.
2008-02-12
121 reads
Change SQL Server stored procedures with batch editing
Learn how to change a group of SQL Server stored procedures (SPs) that perform tasks in your databases. Edit SQL Server SPs at one time with these steps.
2008-02-12
4,317 reads
More Than One Way to Skin a Cat
There are many ways to accomplish a task in SQL Server, and almost every technology. But too much choice might not be the best thing for beginners.
2008-02-12
92 reads
More Than One Way to Skin a Cat
There are many ways to accomplish a task in SQL Server, and almost every technology. But too much choice might not be the best thing for beginners.
2008-02-12
48 reads
More Than One Way to Skin a Cat
There are many ways to accomplish a task in SQL Server, and almost every technology. But too much choice might not be the best thing for beginners.
2008-02-12
44 reads
Blogs
VPN + SQL Server Connections: Why Long-Working Setups Suddenly Fail with Msg 10054 and “Connection Broken”
By Tim Radney
Over the past few weeks, I’ve been contacted by multiple customers experiencing the same...
Future IT Roles – Agentic Architect and AI Boom!!
By Vinay Thakur
These days everything is changing to AI World, IT roles are getting changed and...
Free Webinar about Columnstore Indexes
I’m doing a small series on indexing basics for SQL Server, and on May...
Forums
There's Too Much to Learn
Comments posted to this topic are about the item There's Too Much to Learn
How to Calculate Distance Between Coordinates in SQL Server
Comments posted to this topic are about the item How to Calculate Distance Between...
SSoL Support on the OS
Comments posted to this topic are about the item SSoL Support on the OS
Question of the Day
SSoL Support on the OS
On which Linux versions is SQL Server 2025 on Linux supported?
See possible answers