When Would You Go?
This year TechEd is across two weeks, with a different focus for each. Which one would you rather attend.
When Would You Go?
This year TechEd is across two weeks, with a different focus for each. Which one would you rather attend.
How SQL Server Chooses the Type of Join
How many times have you had a stored procedure run quicker in Query Analyzer than it does in the application? Mike Dillon tracked down one possible cause in this article.
Retain NULL values vs Keep NULLs in SSIS Dataflows - Which To Use?
Integration Services allows you to import all kinds of data easily into SQL Server as well as transform is along the way. Longtime author Paul Ibison brings us a look at how you should set your transformations to deal with NULL values.
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.
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.
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.
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.
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.
Ninja's Return
One of our top posters and valuable member of the SQLServerCentral.com community weighs in on his absence.
Blogs
Claude AI Convinced Me Not to Build an iPad App
By Steve Jones
I coach volleyball and I do a lot of stat stuff on paper. I...
A New Word: Dolorblindness
By Steve Jones
dolorblindness – n. the frustration that you’ll never be able to understand another person’s...
Claude Code Helps Analyze Test Data Manager Log Files
By Steve Jones
I had a customer ask about analyzing their Test Data Manager (TDM) usage to...
Forums
Data Warehouse Toolkit meets Star Schema: The Complete Reference
Is there a good syllabus for reading these two together? (Yes, it's called the...
GPX distance and time analysis in SQL Server
Comments posted to this topic are about the item GPX distance and time analysis...
The DBA is Dead; Long Live the DBA
Comments posted to this topic are about the item The DBA is Dead; Long...
Question of the Day
Changing the AG Listener
In SQL Server 2025, if I want to remove an IP from a listener, what do I do?
See possible answers