Shane O'NeillFeb 13, 2024

#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/

#sqlblog

#TSQL2sday 171: Describe the Most Recent Issue you Closed

What happens when nothing changes, sp_send_dbmail gets given sysadmin, and you still can’t get emails.

No Column Name
Deborah MelkinAug 21, 2023

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/

Fun with DATEDIFF – How long DID that process run for?

I was working on a query this week that reminded me of a fun quirk when working with dates and the DATEDIFF function in particular. I have a process that takes a while to run. Because of all of the…

Deb the DBA
Shane O'NeillJul 11, 2023

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/

#sqlblog

T-SQL Tuesday #164: Code That Made You Feel A Way

Time to read: ~ 4 minutes Words: 899 Welcome to T-SQL Tuesday, the monthly blogging party where we receive a topic to post. This month we have Erik Darling ( blog ) asking us to post about “c…

No Column Name
Tracy BoggianoJun 6, 2023
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
Using Azure Automation and Runbooks to Run Azure SQL Database Maintenance Tasks | Tracy Boggiano's Blog

I've been using Azure SQL Database for quite some while and have set up it in many various ways to run Ola's Index Optimize and Statistics Updates on them. All of these have seemed way too complicated probably because I was setting them up once, not again for several more months or a year. Well

Jared PocheMay 27, 2023
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
Parameter Sensitive Plan Optimization - SQLJared

Parameter Sensitive Plan Optimization is an interesting new feature in SQL Server 2022. Let's review and look at a potential issue.

SQLJared
mbourgonApr 27, 2023

#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

Azure Managed Instance to Parquet using CETAS and t-sql

And we're back! Not that anybody noticed.  'Scool. IP agreements and the like.  I'll make it brief since I logged on at 11pm to get this wor...

Shane O'NeillApr 11, 2023

#tsql2sday 161 Having Fun with SQL
Thanks @2meterdba

https://nocolumnname.blog/2023/04/11/t-sql-tuesday-161-having-fun-with-sql/

#sqlblog

T-SQL Tuesday 161: Having Fun with SQL

Words: 1,283 Time to read: ~ 7 minutes Welcome to T-SQL Tuesday, the monthly blogging party where a host provides a topic, and we blog about it. This month we have Reitse Eskens ( blog | twitter | …

No Column Name
mbourgonMar 2, 2023

#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

Blogger

Weblog publishing tool from Google, for sharing text, photos and video.

mbourgonFeb 24, 2023
#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
Severity 10 - using Extended Events to get code errors

I wish I knew whom to thank for this.  An absolute genius idea. Probably Ozar, possibly Bertrand, could be White or a bunch of other #SQLFam...

Deborah MelkinFeb 13, 2023
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/
OPENROWSET, Dynamic SQL & Error Handling

Deb the DBA