Episode 221: SQL Trail March 2021 Retrospective

As database administrators, we have to live with virtualization.  As a consultant, I can't think of a single environment I have been in that didn't have some of the SQL Servers virtualized.  Troublesh...

17 Feb 201630min

Think of one big investment that will be made this year.  How will it affect you?  Perhaps there is a large server migration project or move to Azure on the books this year.  Maybe you have been given...

10 Feb 201629min

We each have our way of going about things–this is what makes us unique.  When it comes to getting data out of the database, many times we might think that SQL Server would go about getting data the s...

3 Feb 201630min

Have you ever had a situation where performance got worse and you were sure why?  Do you keep records of when changes happen to your system?  How do we know there's a problem?  Baselines can help us o...

27 Jan 201632min

Have you ever wanted a feature to help you assess the impact of future SQL Server upgrades, the impact of hardware or operating system upgrades, and for SQL Server tuning?  Well that tool has been aro...

20 Jan 201631min

DevOps for the database--you have probably heard the term if you work in an organization that is deploying code on a regular basis.  The developers have this down to a science, and now it is the datab...

13 Jan 201626min

SQL Server 2016 has several new features and this episode explores the stretch database feature.  One of the unique attributes of this feature is that it uses both the on premise instance and the Azur...

6 Jan 201632min

One of the new features being added to SQL Server 2016 is the Query Store which will allow for greater access to the performance history of your databases.  This is going to be extremely helpful when ...

30 Des 201535min