655 Views0 Comments0 Likes
This video takes you through a variety of checks against a third-party application that runs against a SQL Server database, from medical practice management systems, warehouse inventory systems, to laboratory informat...
752 Views0 Comments0 Likes
Microsoft Data Platform MVP Kevin Kline dives into the top 10 mistakes that, if avoided, will make your life much easier. These mistakes are the “low hanging fruit” of application design, development, and administrati...
855 Views0 Comments0 Likes
SQL Server specialist Gavin Payne discusses how the Microsoft Azure cloud platform has become an integral part of what’s now a very broad and deep Microsoft data platform. He begins by identifying the platform’s diffe...
641 Views0 Comments0 Likes
In this session, we’ll explore the technical foundation of containers and the emerging uses of containers with SQL Server. While containers are old hat on Linux, and the only way to reproduce the behavior of multiple instances on a single machine, the offer a variety of benefits on Windows too. For example, they are extremely fast to create, invoke, and run - and they licensed differently. We'll also show how the WinDocks solution compares to Microsoft’s, and of course other technical benefits offered by containers.
1.10K Views0 Comments0 Likes
SQL Server specialist Gavin Payne discusses how the Microsoft Azure cloud platform has become an integral part of what’s now a very broad and deep Microsoft data platform. He begins by identifying the platform’s different cloud services and how they relate to traditional SQL Server services. Gavin then suggests how these cloud services can then be used with existing on-premises data platforms to create hybrid solutions – something that’s becoming popular with businesses of all sizes.
1.09K Views0 Comments0 Likes
Indexing is a stab in the dark sometimes. Usage patterns in applications may be different than we expect when making choices for indexing and what we as DBAs think are good indexing decisions may work against us...
2.76K Views0 Comments0 Likes
Join our panel of industry experts for a deep dive into monitoring VMware and Hyper-V environments running SQL Server. The panel includes David Klee (@kleegeek), Kevin Kline (@kekline), and Jason Hall (@sqlsaurus) for a discussion covering issues like what are the important performance metrics to monitor, how to maintain peak performance, and ways that SQL Sentry Performance Advisor take all the pain out of maintaining and monitoring your VM estate for peak performance.
1.77K Views0 Comments0 Likes
Were you the person standing closest to the server rack when they said "We need a DBA"? Believe it or not, some people get shoved into the job of database administrator (DBA) in much that way, without warning or preparation.
2.45K Views0 Comments0 Likes
Have you heard of the data compression feature in Enterprise Editions of SQL Server 2008 and later? It promises great savings on storage space. But did you know it can also improve I/O performance and enhance SQL Server memory?
2.49K Views0 Comments0 Likes
In this video, Kevin Kline and John Martin discuss the roles and responsibilities of a DBA. They look at the interpersonal issues and answer questions who do I need to satisfy and what’s really expected. They also look at what technical skills you need to succeed as a DBA.
2.56K Views0 Comments0 Likes
It's 18:00 o'clock on Friday. You execute a process that usually takes a few minutes and start packing in order to start the weekend. You are already with your bag on your back, but the process doesn't finish. You sta...
2.81K Views0 Comments0 Likes
In this session, Niko Neugebauer looks at the columnstore indexes and discusses how they've improved in SQL Server 2016. About the speaker: Niko Neugebauer works as a BI Consultant for OH22, which creates int...