Configuring Firewall Access for SQL Database on Azure

Its quite common that the first time you work with a feature in a cloud interface, it can appear so foreign until you’ve done it a few times.  If it’s a task that you may not do often or only once, it can be downright painful.  It doesn’t matter who the cloud provider is or the application, we all have felt the pain of this type of situation and why some of us (more...)

Where in the World is DBA Goth Girl- Sept 11-23

Tim and I just arrived back in Colorado yesterday and just arrived-  as in Grand Junction, Colorado on the western border of Utah.  Hauling a 42Ft. 5th wheel means that you make some considerations on how far you can go and how far you want to go.

It’s going to be a busy couple of weeks and this is what’s in the plans:

Microsoft Education Data Summit

I’ll be flying to Las Vegas tomorrow (more...)

How to Linux for the SQL DBA Articles on Simple Talk

I’ve started to write a series of articles on Simple Talk from Redgate on Linux for the SQL Server DBA.  Thanks to Kathi Kellenberger, who came to my pre-con in Indianapolis SQL Saturday and then asked if it was something that I’d be up to doing.

The biggest challenge when doing one hour sessions on Linux at SQL Saturdays is that you find out, one hour is just no where, near enough.  The (more...)

Power BI- Loading PBI Log Files

There’s a reason that log analytics programs, like Splunk, Data Dog and Sumo Logic are so popular.  Even Microsoft has a Log Analytics product, but the important message here is log data is massive and parsing through it to find important information can be a bit of a pain.  The second word in Log Analytics IS “analytics”.  Due to this, the first thought when faced with the number of logs from many (more...)

RV Life and Working Remote

I get a lot of questions about what it’s like to work remote while living in our 5th wheel.  I’ll link this post to danceswithwinnebagos.com, too, so for those asking the same question from that site, it’s a two for one… 🙂

I don’t just break any ol’ rule, I break rules that don’t makes sense and working from an office was one of them.  The amount of time lost in a daily (more...)

Learn Linux With Docker and Microsoft Container Image

I just finished teaching an 8 hour pre-con at SQL Saturday Indianapolis on Essential Linux for the DBA.  The focus of the class was on what the Microsoft DBA would need to know as more SQL Server environments begin to run on Linux.

The obstacles and demands of them will be a bit different than the Oracle crowd, as they may not have the Linux Admin or Unix expertise onsite for support and have (more...)

Visual Studio- All the Warm and Fuzzy

So I haven’t opened Visual Studio in….oh….let’s just say it’s been a few years…:)

I had a project that I needed to run and was surprised when the Solution Explorer was missing from SSMS 2017.  Its only fair to say, there was also fair warning from Microsoft.

Due to this, I opened up Visual Studio to use its Solution Explorer and integration for SSIS and other features required for a large project. (more...)

Power BI 101- Logging and Tracing, Part III

Power BI, like many Microsoft products, is multi-threaded.  This can be seen from the logs and even the Task Manager.  I know, I know…you’ve probably heard this part all before…

The importance of this information, is that the logs will display Process IDs, (PID) that are separate from the main Power BI Desktop executable, including the secondary processes..  Moving from the Power BI logs that reside in the Performance folder, (see Part (more...)

Power BI 101- Logging and Tracing, Part II

So we went over locations and the basics of logging and tracing in Power BI.  I now want to know how to make more sense from the data.  In Oracle, we use a utility called TKProf, (along with others and a number of third party tools) to make sense of what comes from the logs.  SQL Server has Log Analytics and the profiler, but what can I do with Power BI?

First, (more...)

Power BI 101 – Log Files and Tracing

Knowing where log files are and how to turn on debugging is an essential part of any technical job and this goes for Power BI, too.  Remember, as I learn, so does everyone else….Come on, pretty please?

Power BI Desktop

Log files and traces can be accessed one of two ways-

  • Via the Power BI Application
  • Via File Explorer

In the Power BI application, go to File –> Options and Settings –> (more...)

Month Over Month and Newer Schtuff- Power BI

Today’s Post is brought to you by Patrick LeBlanc of Guy in a Cube.  I learn best by doing, so I was working with different features while watching along on Quick Measures:

As a newbie, yes, I had problems with my quick measures just as Patrick said I would, but with a twist-  It wasn’t that I didn’t want to learn DAX, quite the opposite, I could get the expression to work just fine  (more...)

Data Modeling, Dates and DAX

Presenting data in the format to ease visualization is required for any BI product.  Power BI provides much of this with Data Analysis Expressions, (DAX).   As a DBA, I admit to cringing every time a reference was made how similar it is to functions in Excel or other non-database platforms.  I’m a DBA and I naturally am going to see data at a much larger, more complex level.  I love (more...)

I Got Here On My Own

Click bait worthy title, eh? 🙂

That’s what I thought after I read the article from the Harvard Biz Review with the lead in comment, “Women who have already made it to the top say that the only person who will get you there is yourself.”  I found this utterly misleading and the article missing many of the important areas, proving this incorrect.  We are highly critical of women and we’re uncomfortable with women’s ambition, (more...)

Automation and Analytics

They say the devil is in the details and as I come from the DevOps side of the house, it would only be natural that I’d be attracted to how Microsoft Flow works with Power BI.  For those that aren’t familiar with Microsoft Flow, think of it like If This Then That, (IFTTT) from Microsoft.

I used IFTTT to automate a number of tasks at my previous company-  everything from posting to social (more...)

Power BI and the Speed(ier) Desktop

I can be an extremely impatient person about anything I think should be faster.

I’m diving in deep with Power BI and for most of the early on lessons, the data sources used are Excel and…ahem…Microsoft Access.  I don’t know a DBA alive that enjoys working with Access.  Its great for the common user to have a database application, but we can barely use the words “Access” and “Database” in the same (more...)

The Journey Begins- Power BI and AI

I’m back!!  I know you missed my posts…be honest…. 🙂

So its time to start drinking from the fire hose and its important for me to go back to the very beginning, start from scratch and learn from A to Z.  I learned Power BI on my own and there is undoubtedly pieces missing from my knowledge base that need to be filled in.  No way I’d be able to spell if my A to Z (more...)

First Day at Microsoft, the Satya Way

So I’ve finally crawled my way back out of the hole I dug myself in this last month.  The house is empty, the 5th wheel is ready for us to move into and I’m not in Redmond, doing my NEO, (New Employee Orientation.)

I swear this is all I see in my head every time I hear “NEO” 🙂

D&I Epiphany

The first epiphany is that Microsoft, unlike most companies, is really walking the walk (more...)

Time is Gold

So many have asked me when I’m starting at Microsoft and the official date is Monday, June 11th now.  Many also wonder what my upper limits are on how much I can handle, well folks, it looks like we’ve reached them!

I was supposed to start this last Monday, but as my last day approached, it became all the more clear that there was a need to change my ending and start date.  Individual deadlines (more...)