Migrating Databases to Azure SQL Database Tim Radney of SQLskills discusses strategy and some available tools for helping migrate your databases to Azure SQL Database. Tim Radney ◆ October 25, 2016 0
Implementing a custom sort Rob Farley (@rob_farley) discusses some solutions and gotchas for implementing a custom sort using ORDER BY in T-SQL queries. Rob Farley ◆ October 17, 2016 9
SQL Sentry is now SentryOne As part of our effort to consolidate our offering, and to reflect that we aren't just about SQL Server, we have changed our company name to SentryOne. Aaron Bertrand ◆ October 5, 2016 0
The Sort that Spills to Level 15,000 Paul White shows that SQL Server sometimes produces very misleading information about the impact of sort operations. Paul White ◆ September 27, 2016 7
Memory/Storage Technology Hierarchy and SQL Server Glenn Berry discusses the ever-changing landscape of memory/storage technology, and how it relates to SQL Server workloads on Windows servers. Glenn Berry ◆ September 21, 2016 1
Plan Explorer 3.0 Webinar – Samples and Q & A Aaron Bertrand (@AaronBertrand) follows up a recent webinar on Plan Explorer 3.0 with answers to about two dozen audience questions. Aaron Bertrand ◆ September 15, 2016 0
Pattern Matching : More Fun When I Was a Kid Aaron Bertrand (@AaronBertrand) runs some tests to challenge an assertion that CHARINDEX is always faster at pattern matching than LEFT and LIKE. Aaron Bertrand ◆ September 6, 2016 10
Expanding the uses of DBCC CLONEDATABASE Erin Stellato (@erinstellato) goes into detail about some practical use cases for a new DBCC command in SQL Server 2014 SP2 : DBCC CLONEDATABASE. Erin Stellato ◆ August 29, 2016 12
Minimizing impact of widening an IDENTITY column – part 4 Aaron Bertrand (@AaronBertrand) continues his series on widening an IDENTITY column, showing how he would attack the problem directly. Aaron Bertrand ◆ August 4, 2016 3
AT TIME ZONE – a new favourite feature in SQL Server 2016 Rob Farley explains why AT TIME ZONE is his new favourite feature in SQL Server 2016, but also shows that it can make a mess of cardinality estimates. Rob Farley ◆ July 28, 2016 34
Trace Flag 2389 and the new Cardinality Estimator Erin Stellato shows the combined effect of different versions of the cardinality estimator and trace flag 2389 on an ascending key model. Erin Stellato ◆ July 21, 2016 6
