Follow @SQLPoolBoy

[Jonathan Kehayias @SQLPoolBoy]

[Blog]: What's New in SQL Server 2022: GENERATE_SERIES - a great addition to the TSQL language to generate numeric series on the fly!
#SQLskills #SQLServer https://t.co/54fgmCNqW8

[Jonathan Kehayias @SQLPoolBoy]

[Blog] Logging Database Scoped Configuration Changes - https://t.co/W4BluZSRW7 #SQLskills #SQLServer

[Jonathan Kehayias @SQLPoolBoy]

[Blog] - ICMYI - SqlClient Configurable Retry Logic - New in https://t.co/Vshry5EmZT.SqlClient v3.0 - it even allows zero code configuration file based retry implementation for existing applications. #sqlserver #SQLskills

https://t.co/idGeRbdiLD

[Jonathan Kehayias @SQLPoolBoy]

[Blog]: Upgrading/Migrating Large Replicated Databases without Reinitializing - The steps for a side-by-side hardware update or SQL Server upgrade of large replicated databases without reinitializing subscribers fully.

https://t.co/Hvj278pSpf

#SQLskills #sqlserver

[Jonathan Kehayias @SQLPoolBoy]

Blog: More About AT TIME ZONE - A follow up on the slow performance of AT TIME ZONE correcting an oversight in my original post and providing a solution for proper time zone offset adjustments without the performance overheads.

https://t.co/DVZLZ0durh

#SQLServer #SQLskills

[Jonathan Kehayias @SQLPoolBoy]

Blog: AT TIME ZONE Performance Issues - Inside the slow performance of AT TIME ZONE in SQL Server using xperf, and how to work around it for faster queries.

https://t.co/ZbbEHgXjiS

#SQLServer #SQLskills

[Jonathan Kehayias @SQLPoolBoy]

Blog: Stop Planning a Backup Strategy

https://t.co/i8LjbjdSqH

#SQLServer #SQLskills

[Jonathan Kehayias @SQLPoolBoy]

Getting Maximum Performance From Always On Availability Groups - A look at the performance implications and considerations for using Always On Availability Groups in SQL Server

https://t.co/kEqTZNoGyC

#SQLskills #SQLServer

[Jonathan Kehayias @SQLPoolBoy]

[New Blog Post]: Bitten by SSD Bit Rot!

https://t.co/I0epdBQtJC

#SQLskills #SQLServer #BACKUP #SQL #sqlpass

[Jonathan Kehayias @SQLPoolBoy]

Just as I am about to start teaching CPU Scheduling and Performance Tuning for #SQLskills IEPTO2 today, so it's an extra example/demo I'll add now to show that's not useful without further information on activity, runnable tasks counts, etc.

[Jonathan Kehayias @SQLPoolBoy]

Watching @erinstellato teach Backup/Restore in our #sqlskills IE0 class

[Jonathan Kehayias @SQLPoolBoy]

[Blog] Recovering Scripts After SSMS Crash: Shout out to @MladenPrajdic and SSMSToolsPack
https://t.co/cXMDslNFRr #sqlskills #sqlserver

[Jonathan Kehayias @SQLPoolBoy]

Service Broker FTW!!!! Parallel loading data so fast I am getting PAGELATCH_UP waits on GAM pages on a database with 8 data files pushing 1.2GB/sec on Azure VM to disk. Gotta love the ability to queue commands and make them run at a scale that taxes SQL Servers limits #sqlskills

[Jonathan Kehayias @SQLPoolBoy]

This is a new record for me. 3hrs 36 min 52 secs to generate an estimated execution plan for a query. I didn't know it could take that long and not timeout to be perfectly honest. Fun times at #sqlskills

[Jonathan Kehayias @SQLPoolBoy]

Here's a script that implements FTI log rollovers for all databases based on my last blog post! #sqlskills

[Jonathan Kehayias @SQLPoolBoy]

[Blog] Recycle Fulltext Catalog Log Files - Don't end up with a 4GB Log file you can't read through. https://t.co/8ZNNZFyIc9 #sqlserver #sqlskills

[Jonathan Kehayias @SQLPoolBoy]

Anyone else excited about the new features in @SentryOne Plan Explorer Build 2020.8.7? https://t.co/1Tc6QDbpyW #sqlserver #sqlskills I got to see a early demo of the tipping point range series data and have been chomping at the bit for it's release!

[Jonathan Kehayias @SQLPoolBoy]

[Blog] Transactional Replication Use Cases - Common use cases as well as scenarios where it can be used to solve a business problem a different way. https://t.co/0abAtl41jG #sql #sqlserver #SQLskills

[Jonathan Kehayias @SQLPoolBoy]

Lovely... What happens at #SQLskills, gets published on FB, IG, and Twitter for all eternity... LOL!

[Jonathan Kehayias @SQLPoolBoy]

[Blog] Understanding #SQL Server Replication https://t.co/l0LyRFKfVy #SQLskills #sqlserver

An introductory post to a new series on Transactional Replication in SQL Server and how to add this tool to your toolbox