Graph Database in SQL Server 2017, Part I

I felt like playing with something new for the holidays  and chose to investigate the Graph Database feature in SQL Server 2017. Graph Database is no simple feature, so this is going to take more than one post, but we’ll start here and see how long it takes for me to be distracted by another …

Continue reading "Graph Database in SQL Server 2017, Part I" »

Pass Marathon on Linux for SQL Server, Wednesday, Dec. 13th

Tomorrow Pass is sponsoring a Linux Marathon for all the SQL DBAs getting ready to go big with Linux. The schedule is jam packed with sessions on getting started with Linux, working with SQL Server on Linux and then a few sessions, including my own for essential tools that the DBA needs to work with …

Continue reading "Pass Marathon on Linux for SQL Server, Wednesday, Dec. 13th" »

Shooting the DBA isn’t a Silver Bullet to the Cloud

We’ve all been watching numerous companies view value in bypassing the Database Administrator and other critical IT roles in an effort to get IT faster to the cloud.  It may look incredibly attractive to sales, but the truth of it is, it can be like setting up land mines in your own yard. Having the …

Continue reading "Shooting the DBA isn't a Silver Bullet to the Cloud" »

UKOUG and Microsoft Marathon Webinar

I’m here for the last day of UKOUG Tech17 and it’s been an awesome event.  This is my first time to this event while in Birmingham and although quite the party town on the weekends, its a great city to have an event like UKOUG’s trio of events during the week. I was welcomed to …

Continue reading "UKOUG and Microsoft Marathon Webinar" »

SQL Server 2017 on Linux- Processes

So while finishing up my slides for the Microsoft Pass Linux Marathon webinar on Dec. 13th, Tim and I started to discuss the apples vs. oranges comparison of SQL Server on Linux process management vs. an Oracle instance. We discussed the differences one might expect to see using different tools with the two database platforms …

Continue reading "SQL Server 2017 on Linux- Processes" »

UKOUG Tech 2017

Its been a couple years since I presented at UKOUG.  After taking last year off to prioritize some projects with Delphix, I’m back to speaking and the event committee was gracious enough to offer a goth girl a couple spots on the schedule this year. The event is in Birmingham, and although I’ve never been …

Continue reading "UKOUG Tech 2017" »

Database Scoped Configurations

As most of you know, I’m working to update all of my SQL Server knowledge, which hasn’t gone as deep as I would like since SQL Server 2012. So there are a couple things we’re going to focus on today, first of which is the top in the list which I’ve highlighted, Legacy Cardinality Estimation: …

Continue reading "Database Scoped Configurations" »

How Not to Make WIT Result in WTH

The support of Women in Technology at Oracle is a fine line and a careful argument. I receive between 20-30 communications in any week on the topic and I think the challenge as I speak to people is the importance of education over persecution. I’m at DOAG, (Deutschland Oracle User Group) conference this week and …

Continue reading "How Not to Make WIT Result in WTH" »

Considerations When Using SQL Server 2016 Dynamic Data Masking

SQL Server 2016 introduced a new security feature called Dynamic Data Masking.  With the General Data Protection Regulations, (GDPR) breathing heavy down most IT in America’s neck, its good timing. “Data Masking” is a term that has a strict definition, but different results when we actually discuss the technology behind it.  The main goal is to …

Continue reading "Considerations When Using SQL Server 2016 Dynamic Data Masking" »

Azure SQL Database- Automatic Index Management

As I begin my education in SQL Server 2017, as well as Azure SQL Database, my attention was caught by the optimizer improvements and especially automatic tuning. Often referred to with features starting with the naming convention of “dynamic” in Oracle, many automatic features either thrill or frustrate DBAs, no matter what the platform.  The …

Continue reading "Azure SQL Database- Automatic Index Management" »

East Coast Oracle Conference, (ECO 17)

So this week I’m back on the other coast, Raleigh, NC at ECO17 after last week in Seattle. I’ve switched from SQL Server to Oracle and we won’t discuss how many times I had to correct myself as I said, “transaction log” instead of “archive log” and pointed west instead of east for the ocean…My …

Continue reading "East Coast Oracle Conference, (ECO 17)" »

Kudos to Pass Summit 2017

This week I had the opportunity to present at Microsoft’s Pass Summit, which was one of two events I had on my list for this year, (the other was Oracle Open World.) Although I’m still learning about all the events on the Microsoft side, unlike Oracle, where there’s one, massive event in San Francisco each …

Continue reading "Kudos to Pass Summit 2017" »

Pass Summit 2017, 1st Day, Also Known as HumpDay

I’ve plenty of rest after arriving in Seattle yesterday to get my registration for Pass Summit, attended the Women in Technology Happy Hour and then received my Idera ACE! Now Wednesday morning, I spent it reworking my slides for the third time and preparing while the main keynote was going on, (my session was right …

Continue reading "Pass Summit 2017, 1st Day, Also Known as HumpDay" »

International Woman Traveling with a 16in Carry-on

I travel and a seriously good amount.  I will present at about 35-40 events, attend company functions/meetings and this year with a considerable amount of those outside of the Denver area, this means I’ll be on a plane around 5-6 trips per month. Women commonly pack more, but I receive a few comments per my …

Continue reading "International Woman Traveling with a 16in Carry-on" »

Linux for the SQL Server DBA- Part II

So we’ve covered a few basics of a Linux host in Part I– The File System Users, groups Basic Commands with basic arguments And file and directory permissions Hopefully, what I share next will build on the first post and enhance your knowledge as you move forward with Linux. Reading the contents of a directory, …

Continue reading "Linux for the SQL Server DBA- Part II" »

Linux for the SQL Server DBA- Part I

For the Oracle DBA, Linux is life.  When I was at Oracle, Linux projects were the easy part of my job, unlike the ones on Windows, AIX, HP-UX and at times, even Solaris.  You knew the Linux ones received the most love from development, had the most time towards patching and received attention if there …

Continue reading "Linux for the SQL Server DBA- Part I" »

Disrupt or Die- Learning From History

As I continue to dig into the legacy we’re impacted by in technology, I had the opportunity to read Disrupt or Die, the new book from Delphix and Avamar founder, Jedidiah Yueh.  I was first concerned that the content wouldn’t be that interesting to someone from the deep technical like myself… To be honest, I …

Continue reading "Disrupt or Die- Learning From History" »