Watch now! In this session, the second of a 2-part series, we will cover the rich tools, features, and methodologies in SSDT that allow DBAs to implement a continuous database development lifecycle, and how to solve common problems and edge cases.
This webinar was delivered as part of the PASS Global Hebrew Virtual Chapter, and as such is presented in Hebrew.
Watch now! In this session, the first of a 2-part series, we will learn what is Git Source Control? What are CI/CD Pipelines? What are Unit Tests? These are all topics that each DBA must familiarize themselves with before integrating with the software development lifecycle.
This webinar was delivered as part of the PASS Global Hebrew Virtual Chapter, and as such is presented in Hebrew.
Clear your calendars! The long-awaited webinar about CI and CD with SSDT finally has new dates! Yes, I said dates as in plural. It’s going to be a 2-parter! November 28th and December 4th, hosted at the #PASS Global Hebrew Virtual Group.
Last week, I called up Matan Yungman, and offered to replace Guy Glantser as a co-host in SQL Server Radio, while Guy is away on holiday in New Zealand.
We recorded episode 111 in English, and episode 117 in Hebrew.
Check them out!
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.
For this month’s T-SQL Tuesday, Kevin Chant asked us to dream up our fantasy SQL Server feature. I love this topic and so I had to join in on this as a late (and first-time) contributor.
My ask from Microsoft for SQL Server is something that…. Well… It should be simple. It should’ve been implemented YEARS ago. I’m thinking somewhere around the year 2005.
Read More »T-SQL Tuesday #118 – I wish SQL Server had better Table Partitioning
On October 7th, I delivered my presentation about Advanced Dynamic Search Queries at the Israeli Data Platform Meetup, at Microsoft Reactor Tel-Aviv!
Watch here.
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!
Read More »New open source project: Send calendar invites from within SQL Server
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.
Read More »Import GitHub Issues from Trello Cards using Powershell
I’ve published a new open-source project in my GitHub account, dubbed “sp_GenerateTableDDLScript“.
This is basically a stored procedure that can be used to generate a CREATE TABLE script in T-SQL for a given table in Microsoft SQL Server.