Shared Datasets in SQL Server 2008 R2
Shared Datasets are one of the features introduced in SQL Server 2008 R2. This article demonstrates how to implement Shared Datasets as well their use-case scenarios.
ANSI PADDING, Trailing Whitespace, and Variable Character Columns
What does ANSI_PADDING mean and how does it affect my SQL Server database?
Collective Intelligence
Trying to keep up with all the learning going on in the SQL Community can be frustrating. Or is it? Give us your answer in this week's Friday poll.
Extending Hierarchical Data Modeling Demonstrated in SQL
The capability of extending the limits of combining multiple node hierarchical structures has not been fully explored. Michael M. David presents a solution to advanced structure combining that is simple to use, generic and freely extends the way hierarchical structures can be semantically combined to produce advanced new hierarchical data structure mashups that dynamically increase the value of the data.
From “One of the Pack” to “Top Dog”
A guest editorial today from Justin H-Davies examines the change to management from the perspective of someone going through the transition. How do you deal with those former co-workers?
Achieve Spatial Data Support in SSIS
Spatial data support in SSIS is weak in comparison to SQL Server. This article demonstrates how to use the CLR to achieve the SQL Server levels of spatial data support in SSIS.
How to Increase Query Speed With a Little Communication
How my former boss solved a performance issue by changing the business rules, instead of query optimization.
Is it Time to Switch to ELT?
Extract-load-transform integration can offer performance and cost advantages over ETL. Here's how to pick the right approach.
Early July 2010 PASS VC Presentations
In July start with the following presentations from the AppDev and DBA Virtual Chapters of PASS:
Loops, Lookups and Splits: SSIS Beyond the Basics
Why Should I use Stored Procedures?
The Private Cloud
Cloud computing is becoming more and more prevalent in technology. However most people think of a public cloud on the Internet. Steve Jones says a private cloud might be a better idea for many companies.
Blogs
Funny Money: #SQLNewBlogger
By Steve Jones
While wandering around the documentation looking for some Question of the Day topics, I...
Why Database AI Agents need Layers?
By Arun Sirpal
Third part in my Ai series with databases. When building AI solutions within the...
Un-Migrating From the Cloud: T-SQL Tuesday #199
By Steve Jones
This month we have a very interesting invitation from Koen Verbeeck. He has hosted...
Forums
How Do the Experts Become Experts?
Comments posted to this topic are about the item How Do the Experts Become...
Stairway to Reliable Database Deployments Level 4 – Preparing for Production Deployment
Comments posted to this topic are about the item Stairway to Reliable Database Deployments...
Secure Communications
Comments posted to this topic are about the item Secure Communications
Question of the Day
Secure Communications
As of June 2026, what is the best version of TLS to use with SQL Server?
See possible answers