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" »

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" »

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" »

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" »

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" »

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" »

Conference Networking- Tips to Doing it Right

I was in a COE, (Center of Excellence) meeting yesterday and someone asked me, “Kellyn, is your blog correct?  Are you really speaking at a Blockchain event??”  Yeah, I’m all over the technical map these days and you know what? I love the variety of technology, the diversity of attendance and the differences in how the conferences …

Continue reading "Conference Networking- Tips to Doing it Right" »

Oracle IOTs against SQL Server Clustered Indexes

I’m itching to dig more into the SQL Server 2016 optimizer enhancements, but I’m going to complete my comparison of indices between the two platforms before I get myself into further trouble with my favorite area of database technology. <–This is sooo me. Index Organized Tables Index Organized Tables, (IOT) are just another variation of …

Continue reading "Oracle IOTs against SQL Server Clustered Indexes" »