#sqlblog

2024-02-13

#tsql2sday time
I managed to write a blog post again, for the first time in nearly half a year
nocolumnname.blog/2024/02/13/t

#sqlblog

2023-05-27

My latest blog on Parameter Sensitive Plan Optimization in SQL Server 2022 is up at sqljared.com/blog/parameter-se. My next post will be on this subject as well, discussing an issue that may affect your Query Store scripts! #sqlfamily #sqlblog

#SQLBlog #SQLServer Using the new CETAS functionality (Generally available!) to export data from my Managed Instance to Parquet files in Azure Blob Storage. You can do folder paths, partition on dates, etc. This is freaking fantastic! I wrote python scripts using Apache Arrow to do this, and I already prefer this.

thebakingdba.blogspot.com/2023

#SQLBlog abusing DECLARE @VAR=VARCHAR for fun. blogger.com/u/1/blog/posts/143 #SQLServer
oooh, Mastodon has a longer limit!

Run this. Do you get what you expected? I certainly didn't.
DECLARE @blah VARCHAR
SET @blah = '123456'
SELECT @blah
DECLARE @date DATETIME=getdate()
SELECT CONVERT(VARCHAR, @date, 112)
SELECT @blah = CONVERT(VARCHAR, @date, 112)
SELECT @blah

#SQLblog Using Extended Events to capture and read all the ugly Severity 10+ errors in your code that the app is ignoring. thebakingdba.blogspot.com/2023 , and I'm curious whether the Bird or the Furry Mammal will get more love. :D #SQLServer

2023-02-13

The follow up #sqlblog post about that issue I had. Throwing OPENROWSET and error handling in with dynamic SQL...
debthedba.wordpress.com/2023/0

2023-01-31

Inspired to throw together a #sqlblog post by as I was working through an issue. Let's start by talking about dynamic SQL.

debthedba.wordpress.com/2023/0

Rob Sewell He/Himrobsewell@tech.lgbt
2023-01-15

Super blog post.
You should read this if you are in tech whether you are in data or not, it is relevant
---
RT @SQLEspresso
BLOG ARCHIVE: Run Book, Run!!! bit.ly/2QF0wTZ #sqlserver #sqlblog #sqlpass
twitter.com/SQLEspresso/status

2023-01-04

Going through my notes of blog post ideas, I found that I had put something together months ago but never got around to publishing. Let's fix that, shall we? #NeverToLateToPost #sqlblog

debthedba.wordpress.com/2023/0

2022-12-13

Client Info

Server: https://mastodon.social
Version: 2025.04
Repository: https://github.com/cyevgeniy/lmst