David

The Top 4 Data Technology Trends Every DBA Should Know About in 2019

Jan 072019

Join Sentry One, Kevin Kline, and me in an exciting (and laugh-filled) panel session this Wednesday, January 9th, at 2pm ET, where we will discuss all of the technology trends that matter to DBAs!

https://info.sentryone.com/webinar-data-technology-trends

The Information Technology world was stable for decades, but since the arrival of the 21st century, new paradigms have emerged and technologies are advancing and evolving at record speed.

How can you keep up? And which trends should you focus on?

Join Kevin Kline and a panel of distinguished experts as they provide an overview of the top four data technology trends that will advance your business, amplify your productivity, and expand your career opportunities:

DevOps
Cloud Computing
Machine Learning (ML) and Artificial Intelligence (AI)
Containers/Docker/Kubernetes

Get details on the most useful resources for learning about and implementing each of these trends. And they’ll discuss a few technologic trends that aren’t yet fully baked or simply aren’t worth your time.

SQL Bits Precon 2019

Technology No Responses »

Jan 072019

I am extremely happy to announce that I’ll be presenting a preconference training session with Bob Pusateri at this year’s SQLBits conference in Manchester, England, from February 27th to March 2nd! The preconference session is entitled “Level Up Your Data Platform Cloud Infrastructure“.

Precon Session Abstract: While your on-premises infrastructure is likely maintained by another team, in the cloud this responsibility falls on you. Whether your organisation is just planning for the cloud, all-in, or leveraging a hybrid architecture, this course is designed to ramp you up on maximizing your investment in the cloud components that you utilize. Infrastructure skills are essential when managing your environment in the cloud. Knowledge is power; key items such as firewalls and connectivity, storage presentation and performance, baselining, and even platform selection are all necessary areas of concern. Capacity management is also crucial, as the old ways of “throwing hardware” at a performance problem will translate into a larger bill each month. Attend this session to learn how to efficiently manage cloud resources, set yourself apart from your peers, improve the performance of your mission-critical workloads,and potentially save your employer money!

Microsoft MVP and VMware vExpert David Klee and Microsoft Certified Master Bob Pusateri lead this full-day introduction to getting the most out of the infrastructure underneath your Data Platform environment in the cloud. The focus of the course is to help those new to cloud concepts become familiar with function and purpose of each layer of the architecture around their databases, and how this knowledge can benefit them as data professionals. Participants will gain exposure to all layers of cloud infrastructure, from storage all the way through to the Data Platform and databases, methods for baselining their current workloads and sizing the target server, migration strategies, and will learn how to review and engineer the entire stack with a strong emphasis on SQL Server performance.

We are thrilled to travel to the UK to present to this exciting audience! We hope to meet you at the conference, and ping us if you want to meet up! Register for this conference today!

SQL Live Conference – December 2-7 in Orlando

Best Practices, Cloud, Events, Professional Development, SQL Server No Responses »

Nov 192018

I am proud to contribute to this year’s Live360 conference, to be held in Orlando Florida at the Royal Pacific Resort at Universal from December 2nd to 7th.

I’ll be presenting two sessions at this conference. The first is Thursday in room SQH01 called “Cosmos DB for SQL Server Pros” at 8:00am.

Microsoft’s Cosmos DB is the first globally distributed database service, allowing low-latency scalability across multiple geographical regions. As a SQL Server pro, why does this matter? SQL Server is a great multi-function database that can handle many of your tasks with ease. However, it’s not the only tool in the toolbox, and Cosmos DB is a tremendous alternative for some use cases. This introductory session explores Cosmos DB and walks you through the similarities and differences in the two platforms. We explore how to provision and design your database, insert sample data and query for specific records. We’ll review the scalability and throughput settings, and help you ramp up your DBA and development skills on this compelling new platform.

You will learn:

The core concepts of Cosmos DB and the reasons to consider it for data requirements
Key concepts around data design, placement and document construction
How to query for data and process client-side

Just after this session completes on Thursday, the next session is called “Level Up Your SQL Server Cloud Skills” in room SQLH05 at 9:30am.

Think infrastructure in the cloud is still just for sysadmins? Think again! As your organization moves into the cloud, infrastructure architecture skills are more important than ever for DBAs to master. Expert knowledge of cloud-related infrastructure will help you maintain performance and availability for databases in the cloud. For example, know what an IOP is? Should you use a Database as a Service or provision a cloud-based virtual machine? How many compute resources does your database consume during a given day? Can you secure it properly? Come learn many of the key cloud infrastructure points that you should master as the DBA role continues to evolve!

You will learn:

To identify key concepts around database platform selection, such as Azure SQL DB versus Infrastructure as a Service, and make educated recommendations for the appropriate platform
To identify key performance metrics, such as storage performance, vCPU/DTU requirements and so on, that help with properly sizing the destination resources
About Identifying and recognizing the key reasons to migrate databases to the cloud versus keeping them on-premises

PASS Summit Cosmos DB Demo Code

Cloud, Events, Performance, Personal, Professional Development, SQL Server, Technology, User Groups No Responses »

Nov 092018

As part of the PASS Summit conference session that Bob Pusateri and I are presenting right now called “Cosmos DB for SQL Server Pros“, we are demonstrating a number of Azure Cosmos DB features that we feel strongly about helping you leverage through code. As a result, all of the code that we’re demonstrating today is now available for you to download and explore.

This code demonstrates how to collect Windows Perfmon metrics with C#, package them up into a Cosmos DB document, insert the document into Cosmos DB, and then fetch and query individual and multiple documents based on a SQL-like interface demonstration.

As always, there’s no warranty with this code, please don’t distribute as your own, yada yada yada. I’m not the best programmer, so if anyone has improvements, I’d love to have you send me your updates to check out!

PASS Summit 2018 Activities

Best Practices, Business, Cloud, Events, Performance, Professional Development, SQL Server, Storage, Technology, Virtualization No Responses »

Nov 062018

What a whirlwind year this has been! I’m thrilled to invite you to my sessions at this year’s PASS Summit, happening this week in Seattle WA.

Tuesday 11:30am to 1:00pm I’m part of the cloud availability panel over lunch at the SentryOne Data Day precon at the Summit. I hope you already registered for this exciting opportunity to learn more about performance and availability-related topics in this whole-day discussion.

Next, for those of you that still have your mission-critical workloads in your on-premises datacenter (or even for those who have them in the cloud, because almost all of the topics directly apply!), come to my session Wednesday morning at 10:45am entitled “On-Prem SQL Servers, Interstellar Performance“. This deep-dive on virtual SQL Server performance will help you squeeze the most performance from your virtualized SQL Servers, and will help you communicate with your infrastructure team on things that matter the most to performance-oriented SQL Servers. You’ll be sure to have quite a bit of real-world tips and tricks to take back to the office as soon as you return from the conference.

Thursday morning I’m part of the SIOS PASS the Bacon breakfast panel, where we’ll get a good chuckle while we discuss a number of topics pertinent to today’s DBA, such as availability both on-prem and in the cloud, disaster mitigation and preparation, and other availability topics. Come register here, get a great breakfast on the house, and learn while you laugh!

Next, Bob Pusateri and I have a session Thursday afternoon called “SELECT STARS: A SQL DBA’s Introduction to Azure Cosmos DB”, where we discuss and present Microsoft’s new Cosmos DB offering on the Azure platform. This platform is a completely different model of databases than what most SQL Server professionals are accustomed to, and we’ll give you the details you need to expand your horizons and learn about this exciting platform. This session is more of the ‘what’ session to get you amped to learn more about the platform on Friday.

Friday my final session of the conference is entitled “Cosmos DB for SQL Server Pros”, designed to give you more of the ‘how’ when continuing your exploration of Cosmos DB. Bob Pusateri and I will share more of the use cases, scalability details, and live code demos of how to access and alter data in a Cosmos DB database.

I hope to see you at the show! If you want to sync up and talk geek, make sure to ping me to set up some time over your favorite form of caffeine.

SQL Saturday Lincoln Precon this Friday Oct 26

Best Practices, Cloud, Events, Performance, Professional Development, SQL Server No Responses »

Oct 232018

I’m presenting an exciting preconference training session on Friday, October 26, ahead of the SQL Saturday in Lincoln, Nebraska. This all-day training class, entitled “Level Up Your Cloud Infrastructure Skills“, is designed to help you, the SQL Server professional, ramp up your knowledge so you know how to better manage workloads in the cloud.

Think infrastructure in the cloud is still just for sysadmins? Think again! As your organization moves into the cloud, infrastructure skills are more important than ever for DBAs to master. Expert knowledge of cloud-related infrastructure will help you maintain performance and availability for databases in the cloud. For example, know what an IOP is? How many does your database consume during a given day? Properly sizing a cloud database depends on your knowledge of this metric. Failure to properly configure storage performance at the time of deployment will slow down your SQL Server considerably. Come learn many of the key cloud infrastructure points that you should master as the DBA role continues to evolve in this all-day boot camp on ramping up your knowledge on cloud management!

RSVP for this exciting preconference training session here for just $135! Seats are limited, so register soon!

Older Entries