Tag: Humor

  • Creating a Speaking Failures Support Group

    Earlier this week the emails went out to speakers who submitted to the PASS Data Community Summit 2023 conference. These were acceptances and rejections, letting people know the results of the volunteer review.

    I got this one:

    2023-07-13 10_39_20-PASS Data Community Summit 2023 – Call for Speakers Results - Message (HTML)

    I had only submitted one session after being buried last year, and I assumed (we know what assume means) that this one would get picked. It wasn’t, and that’s OK.

    A Speaking Failures Support Group

    I know I’m not alone. I’ve had many speaking submissions rejected. From big conferences and little ones. It is disappointing, but I’ve learned not to take it personally.

    I know this is a hard message to get, especially for less experienced speakers. So I decided to a) publicly disclose my rejection, and b) create a place to get support.

    Since I am the editor of SQL Server Central, that’s a natural place for me to do this. I set up a forum for a Speaking Support Group, which you can use to post questions, ask for feedback on your submissions or ideas, get spell/grammar/phrasing help from others, commiserate with fellow speakers, and give them support/encouragement to try again.

    Feel free to join me there, and comment on my first post, hopefully telling me to not take this too personally.

  • Executing Notebooks in a Stored Procedure

    Jupyter Notebooks are a popular way of consolidating a number of code batches together and them executing them as separate batches or all together. These are essentially a document with notes and code, all of which are stored together. Databricks can run these, as can a number of other services. They are also integrated into various tools, like Azure Data Studio.

    Just like many other technologies, we’d like to execute these in a way that suits our environment. While running these in a tool like ADS works fine, we might want to schedule these and check the results later. You can run notebooks with PowerShell, but keeping around results and managing the data is hard. Since many of us use SQL Server or Azure SQL Database, wouldn’t it be great if we could find a way to have these run inside SQL Server and keep the results around?

    I was poking around inside a database and discovered that I could do this. Only with notebooks that have T-SQL code, but that’s usually what we’d want to do inside a SQL Server (or Azure SQL) database. I need to write a more detailed article on this, but there are a few basics that might help some of you understand how this works. Essentially, there is an undocumented extended stored procedure, xp_notebookparse, that will read the JSON internals of a notebook and allow you to extract out there T-SQL batches. The @execute = 1 parameter will cause each of these batches to be executed.

    For results, a new notebook is created and added to a local temp file, #nbresults, as a BLOB value. You can explore the structure of this, but essentially, part of your stored procedure should take all the data from this table and add it to a permanent table in your database. If you use a stored procedure to wrap the extended stored procedure call and an INSERT..SELECT call together then you’ll actually get nothing to happen because today is April first. It’s April Fools and this is a joke. Hopefully, you aren’t too disappointed.

    Steve Jones

    Listen to the podcast at Libsyn, Stitcher, Spotify, or iTunes.

  • Easy SSIS Package Compare

    I’ve been asking for a way to compare SSIS packages for a long time, and finally Redgate has released an early access version. Years ago we had an internal version, but the visual comparison format was a problem. Really, we couldn’t decide how to actually compare packages on screen in a way that makes sense for users.

    Well, this has been a part-time project for a few developers, and they’ve been trying out ideas for years. I saw something last year that looked good, and I’ve been hoping they’d move it forward. It finally got accepted as a Foundry project, which is our research arm.

    It got a little polish, and now you can get a view of two packages, with various annotations that tells you something is different between the various tasks. The inspiration is the Execution Plan compare, which is in SSMS now.

    view-the-execution-status-of-ssis-package-2

    If you want to try this out, you can’t. It’s a joke. While I do hope they build this, for now, there’s no project in the works.

  • Datetime3

    I was reading about how 2020 ruined time for an author at The Verge. I agree. I find that March feels like an eternity ago, but so much of the hours and days between then and now have blended into a blur from that I can’t easily discern individual elements. As I cleaned up my speaking CV for 2020, I find myself either unable to differentiate some events from others or feeling that others were years ago.

    Time perception is a funny thing, and as the article notes, we can perceive it in different ways, especially under stress or difficulties. I’ve seen some funny posts, like Pandemic Standard Time, the 211th of March, etc. In fact, this is day 286 of March for me. Mar 11 was the day that most things in my life shut down, though I could see that coming.

    It’s gotten to be so crazy that I want to define a new data type, datetime3, which starts on that date and when I perform a datediff(day, 0, getdate()), I just get the number of days since my personal pandemic started. Maybe this could be a somber Easter Egg in SQL Server, a setting, like two digit year cutoff, that we each can set to remind us of the date when the world changed for us, and a new one began.

    I do think that with medical technology leaping forward that we can find some semblance of our old world, where we get together and share knowledge, smiles, and laughs. However, I also think all of us, and our organizations, will be somewhat changed by the events of 2020.

    I hope that begins in 2021.

    Steve Jones

    Listen to the podcast at Libsyn, Stitcher or iTunes.