Migrating DB2 Databases to Azure

Yep, still doing a lot of database migrations. Just too many people wanting to migrate their other database platforms over to Azure…

I have two customers that have DB2 databases and I know how overwhelming it can be to take on a project like this, so I thought I would go over the high level steps to this project to demonstrate it’s a lot easier than many first may believe. The SQL Server Migration Assistant (more...)

Using SSMS with Power BI

I’m curious by nature and many have shown interest when I connect Power BI to the SQL Profiler to collect performance information, but if you can do that, what happens when you connect it to the SQL Server Management Studio, (SSMS)?

That can seem quite foreign, but if you can connect it to the SQL Profiler, you can connect it to the SSMS. Why you can do this is clearly understood when you begin to (more...)

Pricks Upon the Soul of Women’s Ambition

There were two trends in topics that repeatedly came up at RMOUG around women in attendance that I felt deserved a deeper investment of time. As I spend a significant amount of time in a more progressive atmosphere, I find I’m even more aware of them than previously. I hope that my words of support and any advice I offered was helpful to those who sought me out this week.

Be Happy With (more...)

No Pause on the Azure Data Factory

Using only what you need in Azure is a crucial part of optimizing your environment in the cloud. You find that as attractive as Azure is for the masses, making this change to make sure what you do use is optimal will make it downright irresistible.

Many customers, as they are ramping up with Azure Data Factory, (ADF) didn’t worry too much as they built out pipelines, as they could always pause the service at (more...)

Upcoming Events- #SQLSatCle and @RMOUG_ORG #TD19

As I live in an RV and travel as part of my work and to attend events, travel has started to figure out that I often fly out of one location and fly back into another. This week will be no different.

Since we travel between cities on the weekend, its bound to happen that I leave for a SQL Saturday on a Friday in one city and arrive back in a different city on (more...)

Azure Automation of A-to-Z, Part I

DevOps deployments and automation have numerous tools at their disposal, but most often, scripting is required. Although I’m a Microsoft Azure fanatic, I am also a strong advocate of Linux and with my two decades on Unix, I strongly prefer BASH over PoSH. I find the maturity of BASH and KSH highly attractive over PoSH and with my experience, I’m simply more skilled with shells native to the Linux OS.

Before we get too far (more...)

How Not to Perform a Difficult Update in SQL Server/Azure

I learned a long time ago, that the quickest way to do something was to not do it at all.

A friend of mine asked me if I could review an update statement that was confounding their group looking for ways to optimize it.

The table has, just short of 50 columns, a considerable number of indexes and the column in question, has a datatype set to NVarChar(8), consists of some numbers, combinations of letters (more...)

Migrating Oracle Databases to Azure

Cloud is a still a huge buzz word because people are still moving to embrace it. As many companies that are in the cloud, there are still a large percentage of real estate that’s on-premises. As much as I’m now Analytics and AI with Azure, it shouldn’t surprise anyone that I’ve been adopted by a number of those inside Microsoft to assist in the migration of Oracle databases to Azure. There are three primary goals:

  1. (more...)

Speeding up Power BI Interface for sp_Blitz/First Responder Kit

So Tracy Boggiano told me about the great First Responder kit that Brent Ozar had available to use with sp_Blitz using Power BI desktop for a UI, but that it was really slow to non-responsive as data grew. As this was focused on performance data and also included my new love of Power BI, I asked to take a look at it. Tracy was kind enough to send me a copy of her database and (more...)

Women in Tech Book and Upcoming SQL Saturday Events

Its been a busy holiday for me. Tim and I spent the days traveling since the weekend after Christmas until January 2nd moving the RV from California to Texas. I’m not the biggest fan of the Southwest- I just like green and water too much… 🙂

Crushing IT Bias Book

The evenings and nights were spent finishing up my book on Women in Technology, called “Crushing the IT Gender Bias” with Apress. I’ve been working on (more...)

Ode to Azure Cloud Shell on Christmas

When I arrived at Microsoft, I knew I would hopefully get to use my Linux skills for more than teaching SQL Server DBAs about Linux and was pleasantly surprised as I began working in Azure to find that, of course, it’s ALL LINUX.

After almost six months at the company and coming into the Christmas week, I’m thankful for all the technology I’m working with and what many assume that Microsoft won’t be about-  the (more...)

Clean Data = Happy Analytics

I just finished cleaning up the example data that I was offered for my own demos and solutions. Working in Education requires you use education data to ensure what you’re presenting resonates with the users you’re working with. Otherwise you just look silly presenting something that makes utterly no sense to the individual you’re hoping to impress.

Having been given the gift a large data set from demos and solutions, I quickly took the data (more...)

Visual Studio 2017 Incompatibility on *PROJ/SLN Files

Upon joining the Analytics and AI Team at Microsoft to support education, it became quickly apparent that my automation skills were needed more than getting me up to speed on Power BI.  My predecessor had built some great solutions, but to be more scalable, it would pay forward in the end for me to do the automation work, knowing I’d be granted a greater understanding of the products in the long run.

See the source image

The task (more...)

Extended Events with Azure Analysis Services

Its almost standard fare to be using Azure Analysis Services with our customer deployments these days.  As our customers evolve the value of their data.  SSIS integration runtimes were pivotal to this and now that there is Azure Analysis Services, it’s even easier to get started with just a few clicks in the portal interface, (or for me, a simple step in a script… :)) and migrate runtimes to the cloud.

One of (more...)

That’ll Be Fun

I have a t-shirt that says, “Underestimate me, that’ll be fun” on the front of it.  This statement pretty much sums up my life and I continue to both impress and annoy people, which means I’m living up to it.

The session evaluations came out for PASS Summit and I was surprised by some of the reviews I received.  The opportunity to under estimate you is kind of expected.  I’m pretty comfortable (more...)

Sizing Up #SQLPass Summit 2018 After the Fact

This is my third time attending PASS Summit and second time as a speaker.  I applaud the PASS organizers, the community, the volunteers, the sponsors and the attendees for another incredible event.  In less than four days, I came home and tried to isolate one defining moment from the event and it was impossible to do so.

My Scrutiny

I love RV life and I thought I’d be just find with customer and (more...)

PASS Summit, Women in Technology ROCKS!

PASS Summit 2018 is the 16th annual WIT luncheon.  Many of the men are wearing kilts in support of the women in the SQL community, (it’s a thing here…) there’s a luncheon, there’s special panels and highlight on the women authors and speakers.

 

Women in Tech Speaker

The WIT speaker was Lauri Bingham, the Director of Technology Engineering Project Management at T-Mobile.  

Lauri shared her early life, the challenges her mother (more...)

PASS Summit, Day 2 Keynote!

After a long night in a coma to restore my energy expel for the first day of Summit, (anyone else exhausted already???)  I showed up bright eyed and bushy tailed for the second day’s keynote and the blogger table.  

Me this week…

PASS Time

The awesome Wendy Pastrick started us out letting us know what goes on behind the scenes deciding how PASS makes decisions…and then broke into song.  She will survive…. (more...)