Jonathan Kehayias (@sqlpoolboy) 's Twitter Profile
Jonathan Kehayias

@sqlpoolboy

Principal Consultant for SQLskills.com, SQL Server MCM and MVP, Rambling DBA, Husband, Father, and general goofball.

ID: 17456436

linkhttp://sqlskills.com/blogs/jonathan/ calendar_today18-11-2008 02:14:57

35,35K Tweet

9,9K Followers

691 Following

Jonathan Kehayias (@sqlpoolboy) 's Twitter Profile Photo

HCSO who is your off duty deputy driving aggressive, tailgating,and flashing their brights at 6am on Veterans Expwy in a 60 mph zone because me doing 65 wasn’t fast enough for him, then tailgates on my rear bumper all the way to SR54, where he exited, from Gunn Hwy?

Jonathan Kehayias (@sqlpoolboy) 's Twitter Profile Photo

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 sentryone.com/blog/getting-m… #SQLskills #SQLServer

Jonathan Kehayias (@sqlpoolboy) 's Twitter Profile Photo

This statement is 2100 characters for the same equivalent as 200 characters. WTF!!! I LOVE ME SOME ORM GENERATED SQL CODE!!! Said no DBA ever!

Jonathan Kehayias (@sqlpoolboy) 's Twitter Profile Photo

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. sqlskills.com/blogs/jonathan… #SQLServer #SQLskills

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. 

sqlskills.com/blogs/jonathan…

#SQLServer #SQLskills
Jonathan Kehayias (@sqlpoolboy) 's Twitter Profile Photo

[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. sqlskills.com/blogs/jonathan… #SQLskills #sqlserver

Jonathan Kehayias (@sqlpoolboy) 's Twitter Profile Photo

[Blog] - ICMYI - SqlClient Configurable Retry Logic - New in Microsoft.Data.SqlClient v3.0 - it even allows zero code configuration file based retry implementation for existing applications. #sqlserver #SQLskills sqlskills.com/blogs/jonathan…

Jonathan Kehayias (@sqlpoolboy) 's Twitter Profile Photo

Any MARS experts out there that can explain how it works when Attention is raised by one of the connections on a session with 10-12 connections associated with it? #sqlhelp Would it abort just one connection or all on the session under MARS?

Jonathan Kehayias (@sqlpoolboy) 's Twitter Profile Photo

Does anyone have a method to create multiple CSV aggregate columns similar to what STRING_AGG() does using FOR XML without having multiple scans of the table for inner and outer references? My TSQL foo and google foo is failing me this afternoon, or its not possible #sqlhelp

Jonathan Kehayias (@sqlpoolboy) 's Twitter Profile Photo

[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 sqlskills.com/blogs/jonathan…

Jonathan Kehayias (@sqlpoolboy) 's Twitter Profile Photo

[Blog]: SQL Server 2022: Measuring Extended Events Performance Impacts - Easily determine if Extended Events is negatively affecting your workloads performance #SQLskills #SQL sqlskills.com/blogs/jonathan…

Jonathan Kehayias (@sqlpoolboy) 's Twitter Profile Photo

[Blog]: Event exceeds the number of allowable bound actions sqlskills.com/blogs/jonathan… Did you know there was a limit on the number of Actions allowed in Extended Events? #SQLskills #sqlserver

Jonathan Kehayias (@sqlpoolboy) 's Twitter Profile Photo

[Blog]: Do you need Trace Flag 460? sqlskills.com/blogs/jonathan… You might if you get the dreaded "String or binary data truncation" error during a data load. #SQLskills #sql #sqlserver

Desideria (Desi) Mesa (@desideriamesa) 's Twitter Profile Photo

Many have asked if they can send letters of encouragement. ABSOLUTELY. You can send your words, resource ideas and links, and love to [email protected] ❤️❤️❤️

Jonathan Kehayias (@sqlpoolboy) 's Twitter Profile Photo

I asked a FrontierFios support agent to explain why my bill went up twice in the last 6 months and they entered a change order to my account, adding a $10 delivery fee for equipment I've had for 7+ yrs, that isn't changing, and transferred me to retention without even telling me.