Who Wants To Be A DBA? Roles & Responsibilities
36 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 loo...
Query Progress Tracking in SQL Server
278 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...
Columnstore Indexes Improvements in SQL Server 2016 with Niko Neugebauer
245 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...
Exploring SQL Server’s Plan Cache
404 Views0 Comments0 Likes
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.
