Show 4 – Push or Pull?

09/10/14 • 43 min

Two weeks have passed, and it’s time for our 4th show.

As always, we have a mix of interesting stuff covering performance, data architecture, new services, tips, tricks, and much more. Among other topics, we talk about:

Why pulling from a Linked Server is A LOT faster than pushing
The effect of new hardware on Writelog waits
Ways to improve the throughput of your data loading processes
The architecture of Transaction Replication
A weird bug with sequence
DocumentDB, Microsoft’s new NoSQL database service
String search solutions in SQL Server
Why you should wear the Database Architect hat from time to time
How Paul Simon is related to SQL Server

Items mentioned in the show:

Two weeks have passed, and it’s time for our 4th show.

As always, we have a mix of interesting stuff covering performance, data architecture, new services, tips, tricks, and much more. Among other topics, we talk about:

Why pulling from a Linked Server is A LOT faster than pushing
The effect of new hardware on Writelog waits
Ways to improve the throughput of your data loading processes
The architecture of Transaction Replication
A weird bug with sequence
DocumentDB, Microsoft’s new NoSQL database service
String search solutions in SQL Server
Why you should wear the Database Architect hat from time to time
How Paul Simon is related to SQL Server

Items mentioned in the show:

Previous Episode

Show 3 – Performance Tuning

You know you have a performance problem in your server, but where do you start looking in order to find what that problem is?

On our 3rd show, we take a deep dive into performance tuning and talk about:

The Top-Down and Bottom-Up methods and when to use which
The various tools SQL Server gives us for performance tuning
How to pinpoint the problem in any of the methods
What to look for when tuning a slow running query or process
What to look for when analyzing execution plans
Why you should always blame the network
And more..

What’s your method for performance tuning? What are the tools that you use? Tell us in the comments..

Next Episode

Show 5 – Kevin Kline

On show 5, we have our first guest – Kevin Kline!

We talk with Kevin about various topics, covering professional development, the direction of Microsoft, SQL Server 2014, the role of the DBA, and more. Specifically, we cover:

How well Microsoft is keeping up with the competition
What Kevin thinks about SQL Server 2014 and where Microsoft going in the database market
How to take the leap from being a good DBA to being a manager
Why it’s important to have a mentor
His history at PASS, how he and the other founders envisioned it when they founded it, and what he wants to see PASS doing today
How the DBA role is going to change in the next few years
DBAs and Chauffeurs
Kevin’s biggest mistake
And more..

About Kevin:

Kevin is a renowned database expert and software industry veteran, a long-time Microsoft SQL Server MVP and noted leader in the IT industry. Kevin is a founder and former president of PASS and the author of popular IT books like SQL in a Nutshell. Kevin is also a top-rated speaker at industry trade shows worldwide.

Items mentioned in the show: