The Data Stewardship Approach to Data Governance: Chapter 5
Part 5 looks at beginning with a Data Governance Best Practice Assessment
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.
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.
Blogs
Houston AI-Lytics 2026–Powerpoint Slides
By Steve Jones
Thanks to everyone for attending my session on running a Local LLM. If you...
The Book of Redgate: Do the Right Things
By Steve Jones
I do believe that Redgate has been very customer focused since it’s inception. I’ve...
GenAI vs Dashboards: Not the Same (And Never Will Be)
By James Serra
There’s a question I’ve been hearing more and more lately, especially as Copilot, Fabric,...
Forums
T-SQL in SQL Server 2025: JSON_ARRAYAGG
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Spring Connections and Learning at PASS On Tour
Comments posted to this topic are about the item Spring Connections and Learning at...
Multiple Sequence Values
Comments posted to this topic are about the item Multiple Sequence Values
Question of the Day
Multiple Sequence Values
How do I easily get the next 12 sequence values from a sequence object?
See possible answers