The Woes of Cloud Computing
Steve Jones talks about the problems you might face when moving to cloud computing and the fact that you ought to be prepared to move at some point.
Bookmarks in SQL Server Indexes: Stairway to SQL Server Indexes Level 6
A nonclustered index entry consists of search key columns, included columns, and the bookmark. The bookmark value will be either a RID or the clustered index's key, depending upon whether the table is a heap or a clustered index. Choosing the best clustered index for a table requires that you follow three guidelines to ensure that the index key will make a good bookmark.
It’s Good to Eat Alone
Today we have a guest editorial from Andy Warren that looks at the choice of eating with someone else, or alone and the benefits of each.
Down the Rabbit Hole – A Study in PowerShell Pipelines, Functions, and Parameters
For an experienced programmer to learn a new language can be a journey quite like Alice's in wonderland. Paradoxes, unexpected twists, blind tangents, bafflements and nice surprises. Michael Sorens comes to the rescue of anyone learning PowerShell with an explanation of how to use PowerShell functions.
Jobs for Data Scientists
Steve Jones talks about data science and the growing number of jobs that are available in this field.
Speeding Up Database Access Part 3 - Fixing Missing Indexes
Learn how to add those indexes you need in part 3 of Matt Perdeck's 8 part series on improving data access. This is based on the book ASP.NET Site Performance Secrets.
SQLServerCentral.com Best Practices Clinic: Part 5
In this article, Brad McGehee takes a brief look at four resource intensive queries that are running on the SQL Server instance that runs the SQLServerCentral.com website. Don't miss out on the competition in this article.
Blogs
A Career of Memories
By Steve Jones
Annabel retired from Redgate Software this week. Across most of my career at Redgate,...
Rethinking Index Maintenance: Why avg_fragmentation_in_percent Is Outdated and What You Should Do Instead
By Tim Radney
As a SQL Server DBA with years of experience tuning production environments, I’ve seen...
Microsoft Build 2026 announcements
By James Serra
Once again there were a number of Microsoft Build announcements related to data and...
Forums
Changes, Happiness, and a Few Tears
Comments posted to this topic are about the item Changes, Happiness, and a Few...
BCP on Linux
Comments posted to this topic are about the item BCP on Linux
You Probably Don't Need a Vector Database
Comments posted to this topic are about the item You Probably Don't Need a...
Question of the Day
BCP on Linux
When running bcp on Linux, what is the field terminator?
See possible answers