@SQLPoolBoy profile picture
Jonathan Kehayias @SQLPoolBoy

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

Joined November 2008
  • Tweets 35,120
  • Following 679
  • Followers 8,928
193 Photos and videos
I asked a @FrontFIOS 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.
1
1
932
Jonathan Kehayias retweeted
Desideria (Desi) Mesa
@DesideriaMesa
30 Mar 2023
Many have asked if they can send letters of encouragement. ABSOLUTELY. You can send your words, resource ideas and links, and love to desimesawrites@gmail.com ❤️❤️❤️
257
757
20,222
1,564,835
[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

Do you need Trace Flag 460? - Jonathan Kehayias

For most people that are reading this post, I’d venture to guess that you have no idea what Trace Flag 460 is or when you would use it. Well first off, let me tell you it’s a fully documented and...

sqlskills.com
2
1
2
537
[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

Event exceeds the number of allowable bound actions - Jonathan Kehayias

Did you know that there is a limit to the number of actions you can add to a single event in Extended Events? While I was playing around with Trace Flag 9708 for my previous blog post, one of the...

sqlskills.com
3
522
[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…

SQL Server 2022: Measuring Extended Events Performance Impacts - Jonathan Kehayias

Find out whether Extended Events sessions are negatively affecting performance on SQL Server 2022 quick and easy.

sqlskills.com
11
23
1,474
[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…

What's New in SQL Server 2022: GENERATE_SERIES() - Jonathan Kehayias

Learn about the new GENERATE_SERIES function in SQL Server 2022 for generating numeric series on the fly.

sqlskills.com
4
6
Please help @BJRivera29 out by voting for him in this weeks fan pick!
813Preps@813Preps
13 Apr 2022
Replying to @813Preps
Your Turn! Who will nab our "Fan Pick" for Week 7 813Preps PotW - sponsored by Play-It-Again Sports - Brandon? @Jake_Kulikowski @mcquiston_zack @LucasPhelps19 @BJRivera29 @JesuitBaseball @CCSLancers @BaseballNewsome @LetoHighSchool
1
1
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
2
1
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?
1
1
Awesome weekend at @JAMfestEvents! @StingrayAllstrs @LetsGoRaysTAMPA Wave Level 1 Junior Small B National Champions back to back years!
6
[Blog] Logging Database Scoped Configuration Changes - sqlskills.com/blogs/jonathan… #SQLskills #SQLServer

Logging Database Scoped Configuration Changes - Jonathan Kehayias

The introduction of DATABASE SCOPED CONFIGURATIONS in SQL Server 2016 enabled different configuration settings at the individual database level. However, there is no logging of changes to the...

sqlskills.com
3
4
[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…
3
4
[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

Upgrading/Migrating Large Replicated Databases Without Reinitializing - Jonathan Kehayias

This is a topic that comes up a lot for us as consultants and I realized recently that I have never blogged about it. Usually the question is something along the lines of: I have a multi-TB replica...

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

More About AT TIME ZONE - Jonathan Kehayias

This post is a follow up to my previous post on the performance impacts of the AT TIME ZONE implementation in SQL Server based on some observations and comments that were made on Twitter by my good...

sqlskills.com
2
4
8
Shout out to @simon_sabin for the feedback, and to @AaronBertrand for the DateDimension table script.
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
Stackwalking SQL with XPerf

ALT Stackwalking SQL with XPerf

2
10
27
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!
4
22
Blog: Stop Planning a Backup Strategy sqlskills.com/blogs/jonathan… #SQLServer #SQLskills

Stop Planning a Backup Strategy - Jonathan Kehayias

I feel like I have had this discussion multiple times over the last few months with clients, so I decided to turn those discussions into a blog post. One of the things we often get asked about is how...

sqlskills.com
7
13
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
7
14
Jonathan Kehayias retweeted
Jonathan Kehayias@SQLPoolBoy
8 May 2021
Replying to @HCSOSheriff
@HCSOSheriff 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?
0:24
2
1
Load more