Skip to content

Clive Roberts

SQL Server DBA

Menu
  • Setup
  • Performance
  • Health Check
  • Troubleshooting
  • T-SQL
  • Patches
  • News

SQL Server News

Clive Roberts, SQL Server DBA: SQL Server versions, licensing and new features from the Microsoft SQL Server Blog, Brent Ozar and SQLskills, plus Ola Hallengren’s Maintenance Solution releases, checked every 6 hours. Each item links to the full article. Subscribe with the SQL Server News RSS feed.

Microsoft SQL Server Blog

  • SQLCon Barcelona 2026: Advancing SQL with greater control, scale, and intelligence (29 September 2026)
    We're bringing the Azure control plane and management to wherever you are, providing a consistent SQL and Azure experience. The post SQLCon Barcelona 2026: Advancing SQL with greater control, scale,…
  • SQL Server on Azure Local is now generally available (29 September 2026)
    With SQL Server on Azure Local, customers can modernize where their data resides while maintaining control over infrastructure, connectivity, and data placement. The post SQL Server on Azure Local is…
  • What’s next for SQL? Performance, scale, AI, and developer productivity at the European SQL Community Conference (13 August 2026)
    Join Microsoft Fabric and SQL Community Conference 2026 in Barcelona to explore SQL Server 2025, Azure SQL Database Hyperscale, developer productivity tools, and the future of AI-powered data platforms. The…
  • SQL Server 2016 end of support is here: Plan your next steps (14 July 2026)
    See what changes as SQL Server 2016 reaches end of support. Choose between cloud migration, upgrading SQL Server, and Extended Security Updates (ESU). The post SQL Server 2016 end of…
  • FabCon and SQLCon 2026: Unifying databases and Fabric on a single data platform (18 March 2026)
    Welcome to the third annual FabCon and our first ever SQLCon here in Atlanta, Georgia. With nearly 300 workshops and sessions, this joint event will highlight how they are bringing…
  • Advancing agentic AI with Microsoft databases across a unified data estate (18 March 2026)
    Built on a consistent Microsoft SQL foundation from on premises to the cloud, Azure SQL brings AI capabilities directly into your database experience. The post Advancing agentic AI with Microsoft…
  • How the Microsoft SQL team is investing in SQL tools and experiences (05 December 2025)
    Microsoft is modernizing SQL tools with AI, SSMS, Visual Studio Code, and DevOps features to boost productivity and future-proof development. The post How the Microsoft SQL team is investing in…
  • One consistent SQL: The launchpad from legacy to innovation (18 November 2025)
    One consistent SQL delivers the agility and consistency needed to modernize data systems and unlock new innovation opportunities. The post One consistent SQL: The launchpad from legacy to innovation appeared…

Brent Ozar

  • I’m Probably Not Supposed To Show You Microsoft’s Auto-Indexing Tool. (20 October 2026)
    This needs to just stay between you and me, okay? Microsoft’s been working on automatically indexing SQL Server databases. No, not that Azure SQL DB feature, but one that actually…
  • Thoughts on AI After My Panel Discussion (17 October 2026)
    Today at Day of Data Orlando, I moderated a panel discussion with Bob Ward, Celia Brusatori, Kevin Feasel, Rob Volk, and Tim Radney talking about AI in your career, and…
  • [Video] Office Hours on the Last Alaskan Cruise of the Season (15 October 2026)
    It’s a cold, gloomy day on the very last Alaskan cruise of the season. Yes, I picked this on purpose! While I talk about why this is a fun cruise…
  • Breaking News: Hold Off on SSMS 22.11.0 (14 October 2026)
    There’s a new SQL Server Management Studio update out today. I’d hold off on it for now. I had problems with the upgrade, and when I mentioned it on LinkedIn,…

SQLskills

  • AI Stories and Thoughts (20 October 2026)
    AI is obviously the hot new thing and prognostications for the future range from the unicorns-and-rainbows life of idleness for us all to the post-apocalyptic killer robots hunting down the…
  • Reflections on 15 Years (11 August 2026)
    (This was the editorial for my 300th SQLskills Insider newsletter last week, that I’ve been producing since March 2011! See bottom of browser window to subscribe.) I was torn between…
  • Presenting a workshop at PASS Summit West in Seattle! (07 July 2026)
    I’m excited to be presenting at the Pass Summit in November! My pre-con workshop is my absolute favorite to teach Performance Tuning with Waits and Latches and I’ll also be…
  • Summer Sale: $699 Blackbelt Bundle! (23 June 2026)
    Summer Sale time! Hundreds of dollars lower-than-ever prices on our signature 158-hour Blackbelt training bundle: US$699 for one-year access (or to upgrade) – $200 lower than ever before! – US$1,299…
  • The SQL Server Transaction Log, Part 4: Log Records (16 June 2026)
    (This post first appeared on SQLperformance.com four years ago as part of a blog series, before that website was mothballed later in 2022 and the series was curtailed. Reposted here…
  • SQL101: Application data consistency checking (23 April 2026)
    It’s quite common for a company that experiences a corruption-causing disaster, but has no valid backups to restore from and no ability to fail over to a redundant secondary, to…
  • SQL101: Phishing attacks (02 April 2026)
    I thought it was bad previously, but in 2026 I’ve noticed a big rise in emails trying to scam me into clicking a link – known as phishing. Phishing describes…
  • SQL101: Top Ten SQL Server Performance Tuning Best Practices (25 March 2026)
    There are a huge number of best practices around SQL Server performance tuning – I could easily write a whole book on the topic, especially when you consider the number…

Maintenance Scripts: Ola Hallengren’s Maintenance Solution

Latest release 20260912_150238 (12 September 2026): download the zip, release notes, or get MaintenanceSolution.sql from ola.hallengren.com.

  • 20260823_144645 (23 August 2026), zip
  • 20260823_143411 (23 August 2026), zip
  • 20260823_141417 (23 August 2026), zip
  • 20260823_123941 (23 August 2026), zip

Last updated 20 October 2026 at 21:40 by my assistant, Athena.

SQL Server DBA Handbook

Setup, backup and high availability (37)
  • Backing Up and Restoring a Database
  • Restoring a Full Database Backup (SSMS)
  • Restoring a Database to a New Location
  • Backup and Restore with T-SQL
  • Disaster Recovery Planning
  • Basic vs Advanced High Availability
  • Adding a Database to an Availability Group
  • Suspending and Resuming Data Movement
  • Availability Group Health Troubleshooting
  • Quorum Failure
  • Log Shipping
  • Database Mail Setup and Troubleshooting
  • Moving TempDB
  • Database Snapshots
  • Server Build Checklist
  • Encryption
  • TDE: Backing Up the Certificate
  • Data Obfuscation and Masking
  • SQL Server Audit
  • FILESTREAM
  • Orphaned SQL Logins
  • Replicating SQL Server Logins with Their SIDs
  • Login Failures (Error 18456)
  • Random Password Generator
  • Generating the SPNs (Kerberos)
  • SQL Server Replication: Setup, Types and Pitfalls
  • Adding an Article to a Publication
  • Enabling Change Tracking: Good and Bad Points
  • Migrating a Reporting Services Installation (Native Mode)
  • Upgrading SSRS 2005 to 2012 (Quick and Dirty)
  • Azure SQL Options
  • Migrating SQL Server to Azure
  • Building an Availability Group
  • Failover Cluster Instances and Distributed Availability Groups
  • Backup to URL and Backup Encryption
  • PowerShell and dbatools
  • SQL Server Trace Flags
Performance (16)
  • Database Performance Tuning and Index Strategy
  • Data Compression
  • Forwarded Records
  • NUMA
  • Common Memory Issues
  • Average Write Performance
  • Stress Testing the I/O Subsystem with SQLIO
  • When the SQL Server Cache Needs to Be Cleared
  • Parameter Sniffing
  • Table Partitioning
  • Resource Governor
  • What Happens During a Data Change: Buffer Pool, Write-Ahead Log and Durability
  • Measuring Query Performance and Taking a Baseline
  • Reading Execution Plans
  • Plan Caching and Parameterization
  • Statistics Problem or Caching Problem?
Troubleshooting (21)
  • Database Suspect, Recovery Pending or Stuck Recovering
  • Shrinking Databases
  • Transaction Log Full
  • Data File Full and Disk Space (Error 1105)
  • Shrinking Transaction Logs
  • Stopping a Running Job in Job Activity Monitor
  • Failed SQL Agent Job Triage
  • Single-User Mode
  • Tempdb Full or Contention
  • Repairing the WMI Provider (mofcomp)
  • SQL Server Referencing the Wrong Disk Drives
  • Performance Troubleshooting Queries
  • High CPU Troubleshooting
  • SQL Locks
  • SQL Server Error Numbers
  • Monitoring Deadlocks
  • Sleeping Processes
  • DMVs and Session Monitoring
  • Collecting Data with Performance Monitor
  • Collecting a Trace with SQL Profiler
  • Schema Locks and Online Index Maintenance
T-SQL (17)
  • SQL Best Practices
  • T-SQL Coding Conventions and Programming Guidelines
  • Common Table Expressions (CTEs)
  • CROSS APPLY and OUTER APPLY
  • Exporting Data to a File
  • SET IDENTITY_INSERT
  • OPENQUERY with Linked Servers
  • Service Broker in SQL Server
  • Enabling and Resetting Service Broker
  • Change Data Capture (CDC)
  • Extended Events
  • Temporal Tables
  • DDL and DML Audit Triggers
  • Transaction Modes: Autocommit, Explicit and Implicit
  • Error Handling in Transactions: TRY/CATCH, @@TRANCOUNT and XACT_STATE()
  • Read Consistency: Read Committed, RCSI and Snapshot Isolation
  • T-SQL Performance Anti-Patterns

Sidebar

  • Handbook, news and patches (121)
  • Regain sysadmin access (1)
  • Kill SQL processes (1)
  • Configure MSDB (13)
  • TempDB in use (1)
  • Connected to SQL (1)
  • Move backups (2)
  • VLF details (1)
  • Config Manager error (1)
  • Fill factor (1)
  • Missing indexes (1)
  • Number of cores (1)
  • DBCC CHECKDB (1)
  • Wait times (7)
  • Tail-log backup (1)
  • STUFF function (6)
  • Blocking and deadlocks (2)
  • Locking hints (2)
  • Errors 823, 824, 825 (1)
  • DBCC commands (1)
  • Transaction counts (1)
  • Database details (1)
  • Replication (1)
  • Find jobs (1)
  • Backup progress (1)
  • Pivot table (1)
  • Replication objects (1)
  • Tables with no PK (1)
  • Who dropped the database (1)
  • last_value (1)
  • Parse XML (1)
  • Search a string (1)
  • DATETIME difference (1)
  • Error 3707 (1)
  • SHRINKDATABASE (1)
  • Express backup (1)
  • Enable xp_cmdshell (1)
  • Output a file (1)
  • Start of the month (1)
  • Setup
  • Performance
  • Health Check
  • Troubleshooting
  • T-SQL
  • Patches
  • News

Precious Lite 2025 | All Rights Reserved. Precious Lite theme by Flythemes