#tsql2sday time
I managed to write a blog post again, for the first time in nearly half a year
https://nocolumnname.blog/2024/02/13/tsql2sday-171-describe-the-most-recent-issue-you-closed/
#tsql2sday time
I managed to write a blog post again, for the first time in nearly half a year
https://nocolumnname.blog/2024/02/13/tsql2sday-171-describe-the-most-recent-issue-you-closed/
A quick little post about using DATEDIFF... #sqlblog
https://debthedba.wordpress.com/2023/08/21/fun-with-datediff-how-long-did-that-process-run-for/
My #tsql2sday post is up just before the deadline:
https://nocolumnname.blog/2023/07/11/t-sql-tuesday-164-code-that-made-you-feel-a-way/
Using Azure Automation and Runbooks to Run Azure SQL Database Maintenance Tasks https://tracyboggiano.com/archive/2023/06/using-azure-automation-and-runbooks-to-run-azure-sql-database-maintenance-tasks/ #sqlblog #powershell #automation
My latest blog on Parameter Sensitive Plan Optimization in SQL Server 2022 is up at https://www.sqljared.com/blog/parameter-sensitive-plan-optimization/. 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.
https://thebakingdba.blogspot.com/2023/04/azure-managed-instance-to-parquet-using.html
#tsql2sday 161 Having Fun with SQL
Thanks @2meterdba
https://nocolumnname.blog/2023/04/11/t-sql-tuesday-161-having-fun-with-sql/
#SQLBlog abusing DECLARE @VAR=VARCHAR for fun. https://www.blogger.com/u/1/blog/posts/1434113132981005034 #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. https://thebakingdba.blogspot.com/2023/02/severity-10-using-extended-events-to.html , and I'm curious whether the Bird or the Furry Mammal will get more love. :D #SQLServer
The follow up #sqlblog post about that issue I had. Throwing OPENROWSET and error handling in with dynamic SQL...
https://debthedba.wordpress.com/2023/02/13/openrowset-dynamic-sql-error-handling/
NEW BLOG: Tempdb Performance Improvements in SQL Server 2022 are Dramatic https://sqlespresso.com/2023/02/01/tempdb-performance-improvements-in-sql-server-2022-are-dramatic/ #sqlserver #sqlfamily #sqlblog #azuredatacommunity
Inspired to throw together a #sqlblog post by as I was working through an issue. Let's start by talking about dynamic SQL.
https://debthedba.wordpress.com/2023/01/31/dynamic-sql-sessions-and-execution/
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!!! https://bit.ly/2QF0wTZ #sqlserver #sqlblog #sqlpass
https://twitter.com/SQLEspresso/status/1614731562494611456
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
https://debthedba.wordpress.com/2023/01/04/troubleshooting-azure-data-studio/
New #sqlblog post for #tsql2sday
T-SQL Tuesday 157 - End of Year Activity
https://nocolumnname.blog/2022/12/13/t-sql-tuesday-157-end-of-year-activity/