Posted in: Microsoft SQL
After laying out the structure for our zones, my client quickly asked, is there a way we can automatically stand up this structure each time we bring a new Tenant into our solution. With a smile, I replied it was possible! In the short term, we would use PowerShell to...
Posted in: Microsoft SQL
Over the next few blog posts in this series, I’m going to share with you the story of how a Data Lake project comes together. As I tell this story, I’m going to keep pointing back to traditional ETL work and to Automation techniques. Not all of these will include...
Posted in: Microsoft SQL
Last week you might have seen a tweet about a day in the life of a Data Platform Consultant. To say the least, my days are varied.This day, in particular, I was
Posted in: Microsoft SQL
As I mentioned in the overview, the largest cost in terms of time is the requesting each web page from the web server and downloading that file to disc. That’s why this file staging loop is a separate step from the parsing and transforming step. This loop can be as...
Posted in: Microsoft SQL
In the last article, I laid out the architecture to dealing with this type of data source. This time, we’re going to get in to the basics of parsing data. A Few New Technologies Before we dive into details, let’s cover the technologies this solution rests on. First, there’s C#....
Posted in: Microsoft SQL
Introduction There's a ton of data on the Internet. Some of that data is really easy to download and extract that data into a relational database. Data that
Posted in: Microsoft SQL
Everyone who knows me, knows I'm a Microsoft data platform professional. I do prefer their solutions over most other solutions. I know there have been a few
Posted in: Microsoft SQL
After getting AD Password Authentication working with my Azure SQL server, I moved on and set up a local Active Directory domain on my home network. I don’t think this is something every data professional should try and tackle. I count myself extremely fortunate to have made friends with IT...
Posted in: Microsoft SQL
f you’ve been working with Azure in the last few years, you’ve noticed there is a relatively new feature that’s supposed to make identity management easier with your Azure solutions: Azure Active Directory (AAD). This feature does work with Azure SQL Servers and Azure SQL Databases. But it may not..
Posted in: Microsoft SQL
I’m coming to the end of my posts on identifying which SQL Server components to use to support different business requirements. I’ve already covered SQL Server Agent, DB mail, Service Broker and Full-Text Search This time I’m going to go over linked servers. Not exactly the link I was talking...
Posted in: Microsoft SQL
I'm currently working on a batch of 12 articles that will fill in details on the study guides I've published over the last week. These articles are all a part
Posted in: Microsoft SQL
I’m putting together a new series to cover the materials you’ll need to know in order to pass the 70-433. Microsoft’s exam that covers Database Development using Microsoft SQL Server 2008. I’m going to list the topics covered in several posts, each one will include links to details to those...