DrewSK.Tech

Databases, Development, and Other Anecdotes

0%

Publish on: Classify at: ; ;
There are a few instances where you want to run SQL Server on macOS and interact with it from a windows VM. As someone that works within the world of SQL Server/Azure SQL, the use of SQL Server Management Studio (SSMS) comes to mind immediately - for the tasks you can’t complete in Azure Data Studio on macOS directly. Another adjacent (and generally unfortunate scenario) is when work with .NET Framework is required, and for that, you need Windows.

Publish on: Classify at: ;
Even if you’re setting big goals, especially long-term goals, you can’t forget to take small steps sometimes. I’m one year post completing an MS in Computer Science and after a year of maybe less directed pressure on myself, I’m forming out aspirations for the next 3-5 years. It’s exciting, but it hit me with a bit of paralysis at first. It seems silly now that I look back on it, a good 4 weeks of just emotionally staring at a giant wall.

Publish on: Classify at: ;
There’s no secret that PMs, no matter what the “P” stands for, have a lot of meetings. Over the past few years I’ve become fully indoctrinated into the Microsoft life of PM (program/product management) with meetings dominating too much of my day, week, and year. After many mornings taking at a look at my calendar only to find it nearly incomprehensible I’ve spent some time making ultimately lightweight changes to make my calendar lower maintenance and easier to read.

Publish on: Classify at: ; ; ;
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.

Publish on: Classify at: ;
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?

Publish on: Classify at: ;

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.

Publish on: Classify at: ; ;

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.

Publish on: Classify at: ;

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.

Publish on: Classify at: ;
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/)

Publish on: Classify at: ;

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.

Publish on: Classify at: ;
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”.

Publish on: Classify at: ;

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.

Publish on: Classify at: ; ;

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.

https://www.pass.org/Learn/Recordings/Listing.aspx?oRecording=3396

Publish on: Classify at: ;

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

Publish on: Classify at: ;

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.