Upcoming webinar: CI and CD with SSDT and Living to Tell About It

Unfortunately, due to unforeseen circumstances, the webinar had to be delayed to a later date. I’ll post an update as soon as a new date will be scheduled. I’m delivering an upcoming webinar in PASS Global Hebrew Virtual Group: CI and CD with SSDT and Living to Tell About It, on September 25th, 17:00 Israel Standard Time (GMT+3) Details and registration: https://globalhebrew.pass.org/MeetingDetails.aspx?EventID=14256 Meet SSDT (SQL … Continue reading Upcoming webinar: CI and CD with SSDT and Living to Tell About It

#TSQL2sday : I wish SQL Server had better Table Partitioning

For this month’s T-SQL Tuesday, Kevin Chant asked us to dream up our fantasy SQL Server feature.

The feature I wish we had is Table Partitioning, but… Better. Unfortunately, the feature by large remained the same way since its release in 2005, without any meaningful improvements (besides some parallelism and statistics maintenance improvements).

But I think Microsoft can do much better. Continue reading #TSQL2sday : I wish SQL Server had better Table Partitioning

New open source project: Send calendar invites from within SQL Server

Looking for a way to send calendar event invitations from within SQL Server?

Did you try that one hack where you use sp_send_dbmail to generate an ics attachment file, and then found that it’s still not being identified as a calendar event in the e-mail program?

Then fret no more, my friends, because I’ve been there, and out of sheer desperation of not being able to find a properly working solution, I’ve decided to build one myself. And now it’s available for your wide consumption as an open source project!

Continue reading “New open source project: Send calendar invites from within SQL Server”

Import GitHub Issues from Trello Cards using Powershell

I know this has little to do with SQL Server (and therefore, not quite like me to post this), but it’s a nifty little script in Powershell which I’ve been working on recently, and I believe other people may find use for it as well (someone, somewhere, maybe?).

This script basically takes a Trello JSON file (created using their Export feature), connects to a GitHub repository, and creates one GitHub issue per each Trello card. Any labels are copied over, any checklists in the Trello card will be added into the issue body as checklists, and any attachments in the Trello card will be added into the issue body as an unordered list of links. Finally, at the bottom of the issue’s body there would be a link back to the original Trello card.

Continue reading “Import GitHub Issues from Trello Cards using Powershell”