Tag: sql server

Sort: Date | Title | Views | Comments Sort Descending
View:

SQL Server Data Compression

Added by 1 year ago

2.76K Views0 Comments

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?

Who Wants To Be A DBA? Roles & Responsibilities

Added by 1 year ago

2.89K Views0 Comments

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.

Query Progress Tracking in SQL Server

Added by 1 year ago

2.84K Views0 Comments

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...

Columnstore Indexes Improvements in SQL Server 2016 with Niko Neugebauer

Added by 1 year ago

3.32K Views0 Comments

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...

Exploring SQL Server’s Plan Cache

Added by 1 year ago

1.78K Views0 Comments

SQL Server’s plan cache is one of the largest regions of memory and is used to store SQL and T-SQL code for quick execution. It is largely self-maintaining and self-tuning. However, the kind of code you write and the way you invoke that code can have an enormous impact on how the plan cache is maintained, tuned, and optimized.

SQL Sentry Tools Demo Focused on SQL Server

Added by 2 years ago

4.42K Views0 Comments

In this video, Lori Edwards gives a demo on the tools offered by SQL Sentry that are focused on helping you with SQL Server.

Top 10 DBA Mistakes: Horror Stories! – Panel Discussion – Part 4

Added by 2 years ago

2.71K Views0 Comments

In Top 10 DBA Mistakes: Horror Stories! – Panel Discussion – Part 4, Kevin Kline, Aaron Bertrand, Jes Borland, David Klee, Grant Fritchey and Tim Ford briefly touch on indexing strategy and why it is important. They continue to tell their own horror stories for backups and recoveries and some of the things you can do to avoid having your own horror stories.

Top 10 DBA Mistakes: Horror Stories! – Panel Discussion – Part 3

Added by 2 years ago

2.22K Views0 Comments

In Part 3 of Top 10 DBA Mistakes: Horror Stories! - Panel Discussion, the panel talks about how human error is something that is inevitable and tell more horror stories from their own experiences. They stress how it is always important to prepare for these types of mistakes so you can recover faster when they occur.

Top 10 DBA Mistakes: Horror Stories! – Panel Discussion – Part 2

Added by 2 years ago

2.65K Views2 Comments

In Part 2 of the panel session on DBA Horror Stories, Kevin, Jes, David, Grant, Aaron and Tim talk about how the development of technology doesn’t get rid of the DBA, but forces a shift in jobs for the DBA.

Top 10 DBA Mistakes: Horror Stories! – Panel Discussion – Part 1

Added by 2 years ago

3.83K Views3 Comments

In the Top 10 DBA Mistakes: Horror Stories - Panel Discussion, SQL Server MVPs and SQL Cruise Technical Leads, Kevin Kline, Jes Borland, David Klee, Grant Fritchey, Tim Ford and Aaron Bertrand discuss how they learned the most from their experience as DBAs when things went horribly wrong and why it is extremely important to always be knowledgeable about your systems.

Custom Conditions

Added by 2 years ago

3.54K Views0 Comments

In this video, Scott Fallen, one of our Sales Engineers, looks at one of our newest features, custom conditions. He starts out by discussing how custom conditions work and how it’s different from anything available in other alerting systems. He also shows some example conditions, which are available in our starter custom condition package.

Top 10 DBA Mistakes: Horror Stories! – Part 3

Added by 2 years ago

2.56K Views0 Comments

In Part 3 of the series, SQL Server MVPs Aaron Bertrand and SurveyMonkey’s Argenis Fernandez join Kevin Kline. In this video, Kevin, Aaron and Argenis discuss another common DBA Mistake, inadequate preventative maintenance.

Page 2 of 3123