Databases, Development, and Other Anecdotes


Using Python and Azure Functions to send data from Azure SQL Database When building applications on Azure SQL, one of the most flexible ways to send data from your database to other systems is to use Azure Functions. Azure Functions are serverless functions that can be triggered by a variety of events, including HTTP requests, timers, and Azure SQL Database changes . In this article, we will discuss how to send data from an Azure SQL Database to an FTP server and API endpoints using Azure Functions.

My inbox for drew@drewsk.tech was quiet for a few weeks and I didn’t think much of it. I was planning on sitting down to clean up old articles and publish a new one when I noticed that the blog site was down. Technically, the site was still up, but DNS wasn’t pointing to it. It turns out - all of my DNS entries were gone. A sudden and unexpected failure to find the website What Happened?

The Georgia Tech online masters of science in computer science has been a groundbreaking endeavour to bring an MS CS program to students at a massive scale.

In five years, the program has received over 25,000 applications and enrolled more than 10,000 students (including those who have graduated), all working their way toward the same Georgia Tech M.S. in Computer Science as their on-campus counterparts.

Despite the use of online communities, legions of teaching assistants, and other techniques to expand the reach of a traditional masters of science program to thousands of students, there are still opportunities for students to be deeply engaged with university resources. One of these categories of opportunities is research and independent projects, which I was fortunate to experience in three ways during my time in the program.

The online Masters of Computer Science program at Georgia Tech is completely online and designed for working, part-time students. I applied to OMSCS in 2015 when I was concerned about what I saw as a plateau ahead in my career. At the time I worked for a smaller company doing a little bit of everything in technology and development. With a MS in chemistry and a minor in computer science under my belt I was confident that I would be able to succeed in OMSCS and it would contribute to my part of my aspiration to be a better developer and work as software engineer in the future.

I received the decision notification email while driving from Missouri back home to Minnesota. It was unpleasantly cold and windy at a gas station in Iowa as I navigated the applicant portal from my iPhone. Also relatively unpleasant was the news that I had not been accepted to OMSCS.

Content prior to this date is migrated from the previous Wordpress site. I’ll be cleaning it up over time and apologize for formatting issues that impact the reading experience.

T-SQL Tuesday Logo

My invitation to you is I want to know what you have automated to make your life easier? This can be anything creating a SQL Server Agent job to automated running a daily report or using dbatools to manage your servers. I’m curious what challenges you’ve found at your job and what you’ve done to make things better. If you haven’t had a chance to automate some part of your job, what would you like to automate and what are your hurdles? If you’re interested in some help or advice, let us know. I love #SqlFamily, and I’d love to see what we can do to help out.

T-SQL Tuesday Host, Elizabeth Noble (https://sqlzelda.wordpress.com/2020/09/01/t-sql-tuesday-130-automate-your-stress-away/)

As I embark on my first year with a greenhouse, one of the fundamentals I want to grasp is an understanding of the temperature and humidity inside the greenhouse and how it is impacted by the weather outside the greenhouse. Our whole-house “smart system” is centralized through Home Assistant so I wanted to continue the connection into the greenhouse by passing the monitoring from the greenhouse through Home Assistant. This post is the basics of how I accomplish this.

Error: GLTrans with transdate value far outside a normal range. http://go.microsoft.com/fwlink/?LinkID=397215 Validation task error message, complete with dead Microsoft URL This post is a follow-up to a previous post on Management Reporter data validation errors, which focused on a different data validation error with Management Reporter. The good news is that the same tools we used to correct other errors will likely be used here. In this case, we’re looking for records where the trandate field is “outside normal range”.

In the world of technology services, integrations are the gold standard. Azure Logic Apps are an accessible and customizable way to create basic integrations. One of the most common integration options you will see is a “webhook” – when a system sends defined HTTP requests to a user-defined endpoint.

This post summarizes an example where when a visitor logs in at an Envoy kiosk, the integration sends an SMS and an automated phone call to their host through Plivo. Azure Logic Apps can be used to quickly create an endpoint for receiving webhooks without writing code.

This post recaps a webinar originally presented during the 24 hours of PASS marathon in September 2019, “The Open Source Opportunity: How You Can Impact Azure Data Studio”. The webinar was a precursor to a presentation on Azure Data Studio extension development at PASS Summit 2019. It was a new challenge to present at 3am local time but I’ll (almost) never forgo an opportunity to talk about contributing to open source software.

Open source software presents a unique opportunity to shape the future of a product with modes of involvement for any skillset or interest. Azure Data Studio, a cross-platform product with monthly releases, has a steadily growing pool of contributors from across the data platform community. From reporting bugs to submitting source code pull requests, we’ll review the ways anyone can impact the development Azure Data Studio.


My topic is looking for your favourite ‘life hack’, something you use to make your day easier. This could be anything from a keyboard shortcut in SSMS that runs ‘sp_whoisactive’, to a technique you use to get and stay organised.  It doesn’t have to be directly related to a technology, just whatever you use to make your life easier.

T-SQL Tuesday Host, Jess Pomfret ( https://jesspomfret.com/t-sql-tuesday-123/ )

To present a PowerBI report user or consumer with a securely pre-filtered dataset, row level security must be used. In a PowerBI embedded architecture where “app owns data”, implementing row level security (RLS) requires a modification to the token generation request. By specifying a role and user in the token request, we can generate an embed token specific to the user’s data access.

This post is going to walk through the quick steps to move TempDB through TSQL and the Windows Server UI. This information will be useful you are looking to move TempDB away from your user databases and/or away from the OS. Beyond the potential for an interruption during the addition of a drive to the OS, moving TempDB requires the SQL Server service to be restarted. Such a minor interruption makes the potential benefit of this change worthwhile. While this post isn’t going to dig into any of the details around physical disk configuration for performance optimization or availability, it is part of the foundation to improving a SQL Server from a scenario where all the components are stored on 1 drive.

In SQL Server Management Studio (SSMS), you can create multiple cursors across multiple lines with alt + shift + up/down. Because of its VS Code foundation, Azure Data Studio has similar functionality built-in. Creating multiple cursors in Azure Data Studio can be done directly on adjacent lines, at user-determined locations, and at instances of a selected string.

I want to read your stories about when you’ve experienced, seen, or overcome imposter syndrome! Was there a job that you felt you were ill-prepared for? Did you make a mistake or did someone say something that made you question if you were a true data professional? Maybe there was a particular task you ran into that made you question your experience? Did you resolve your tasks and succeed in your job? How did you overcome that feeling of being an imposter and solve your challenges? Maybe you haven’t experienced it yourself but you saw someone who was feeling imposter syndrome, were you able to help them?

You can be technical or non-technical with this post, the goal is to share experiences to help those also experiencing imposter syndrome. Maybe you are still feeling it, sometimes walking through your challenges can help you brainstorm solutions.