Writing a Technical Article – Where to Publish
This is part three of a series on writing a technical article. The advice might apply to non-technical articles, but...
A Good Word for ODBC
A guest editorial from Phil Factor puts in a good word for ODBC. This is the standard for Windows machines to connect to all kinds of data sources, and is both loved and hated by developers of all kinds.
Less Than a Week - PASS 2009 Summit
A last push for the 2009 PASS Summit before registration goes up.
Managing Free Space
A new article from Paul Els looks at managing free space on your database servers by finding detached databases and old backup files.
Date Expression Compilation in SSIS
There are many different ways to manipulate dates when working with them in SSIS. Many great examples have been posted...
PASS Connector Editorial for Sep 9, 2009
I currently write the editorial for the PASS Connector which is published every two weeks as part of my role...
Understanding Scans And Seeks
Whether a query uses Scan or Seek can have a big impact on the cost of excuting that query. This article examines when each is used and which is optimal.
Using Star Join and Few-Outer-Row Optimizations to Improve Data Warehousing Queries
In this white paper we discuss two of the new features in SQL Server 2008, Star Join and Few-Outer-Row optimizations. We test the performance of SQL Server 2008 on a set of complex data warehouse queries designed to highlight the effect of these two features and observed a significant performance gain over SQL Server 2005 (without these two features).
Finding Passwords
There was a vulnerability announced in the SQL Server password system last week, but Steve Jones doesn't see this as much of an issue. Read his thoughts and see if you agree.
Returning full error details from SQL Server Agent jobs
Tired of the truncated error history that is available for SQL Server Agent jobs in SSMS, here is a way to get deeper information - easily!
Blogs
Ramblings about data communities and your contributions, no excuses
By DataOnWheels
I have been active in the data community throughout my career. I have met...
SQL Server Journey till 2025 (brief)
By Vinay Thakur
Quick Summary for Microsoft SQL Server till 2025, I am fortunate to be part...
Building Power BI Reports: Desktop vs Fabric
By James Serra
Why this comparison feels confusing If you’re a Power BI report author who’s just...
Forums
Azure SQL Database | CREATE EVENT SESSION [Blocking_Capture] ON DATABASE
Hello, Is there a way in Azure SQL Database to change the 'Blocking Process...
Having a Little Fun at SQL Server Central
Comments posted to this topic are about the item Having a Little Fun at...
Designing SQL Server Pipelines That Are Ready for AI Before You Actually Need AI
Comments posted to this topic are about the item Designing SQL Server Pipelines That...
Question of the Day
String Similarity I
On SQL Server 2025, when I run this, what is returned?
SELECT EDIT_DISTANCE_SIMILARITY('SQL Server', 'MySQL') See possible answers