Randy Dyess

Randy
Dyess

Randy Dyess is a mentor with Solid Quality Mentors and has been working with SQL Server for more than 15 years. Randy specializes in very large OLTP databases and deals primarily with performance tuning.

Articles
video camera lense
Video: SQL Server 2008 - Episode 5: Knowing Your Data
Randy Dyess, with Solid Quality Mentors and a SQL Server MVP, discusses the features of SQL Server commonly grouped under the title business intelligence (BI).
videos key on computer keyboard
Video: SQL Server 2008 - Episode 2: Under the Hood
Randy Dyess, a mentor with Solid Quality Mentors and SQL Server MVP, lifts the hood and takes a close look at SQL Server 2008, Microsoft’s latest release of its flagship database product.
video camera lense
Video: SQL Server 2008 - Episode 4: What About Developers
Randy Dyess, with Solid Quality Mentors and a SQL Server MVP, discusses the features of SQL Server 2008 that can be used by database developers to minimize the time needed to create functional database applications.
video written in pink of blue screen
Video: SQL Server 2008 - Episode 8: How Do I Upgrade
Randy Dyess with Solid Quality Mentors and a SQL Server MVP discusses what you need to know to prepare to upgrade to SQL Server 2008.
video written in pink on blue screen
Video: SQL Server 2008 - Episode 3: Protecting Your Data
Randy Dyess, with Solid Quality Mentors and a SQL Server MVP, discusses the database mirroring feature found in SQL Server 2008.
computer keyboard with green key and red lock keys
Video: SQL Server 2008 - Episode 1: How Can I Secure Data
Randy Dyess, with Solid Quality Mentors and a SQL Server MVP, discusses security in SQL Server 2008. You will learn the fundamentals of SQL Server 2008 data security and how you can use this security in your database.
play written on blue video screen
Video: SQL Server 2008 - Episode 7: Ready for your Environment
Randy Dyess, with Solid Quality Mentors and a SQL Server MVP, discusses very large databases and how SQL Server 2008 is ready to be utilized in a large environment.
Microsoft SQL Server 2008 logo
Video: SQL Server 2008 - Episode 6: 64 Bit and You
Randy Dyess, discusses the 64-bit version of SQL Server 2008 and takes you through the advantages that a 64-bit version of SQL Server 2008 can give database administrators and BI analysts.
How Do I upgrade to SQL Server 2008? 1

In this instructional video, Randy Dyess prepares the SQL Server DBA for migrating data to SQL Server 2008.

The video covers how to migrate from SQL Server 2005 to SQL Server 2008 by taking the viewer through the main points that every migration plan needs in order to succeed. Database administrators will learn how to create a migration plan and learn the particulars of migrating to SQL Server 2008.

Ready for Your Environment? Working with VLDB Using SQL Server 2008 1
In this instructional video, Randy Dyess discusses very large databases and how SQL Server 2008 is fully ready to be utilized in large enterprises.
SQL Server 2008 Boosts Built-in Encryption
The new Extensible Key Management feature makes SQL Server’s built-in database encryption more secure by supporting third-party encryption providers, so that you can store keys outside of the database.
Knowing Your Data: SQL Server 2008 and Business Intelligence

In this instructional video, Randy Dyess discusses the features of SQL Server commonly grouped under the heading Business Intelligence. The video covers BI concepts and the tools found in SQL Server 2008 that will help companies understand how SQL Server can help them in their quest to fully utilize the data they capture.

What about Developers? SQL Server 2008 and the Development Environment

In this instructional video, Randy Dyess discusses the features of SQL Server 2008 that database developers can use to maximize the time needed to create functional database applications.

64-Bit and You: How SQL Server 2008 Better Uses a 64-bit Platform

In this instructional video, Randy Dyess discusses the 64-Bit version of SQL Server 2008. The video will take the viewer through the advantages that a 64-Bit installation of SQL Server 2008 can give database administrators, database developers, and business intelligence analysts by discussing how SQL Server performs on a 64-Bit machine.

Digital Magazine Archives

Browse back issues of SQL Server Pro, from January 2007 through the last issue published in April 2014. Find the back issues here.

 

From the Blogs
Jul 28, 2015
blog

AlwaysOn Availability Groups and SQL Server Jobs, Part 29: Practical Implementation Tips

My initial goal in writing this series of posts was to outline some of the concerns surrounding Availability Groups (AGs) and SQL Server Agent Jobs – and call out how there is virtually no guidance from Microsoft on this front and then detail some of the pitfalls and options available for tackling this problem domain. I initially expected this series of posts to have between 25 and 30 posts – according to some of the early outlines I created ‘way back when’....More
Jul 6, 2015
blog

AlwaysOn Availability Groups and SQL Server Jobs, Part 28: Additional Options for Tackling Jobs Failover

Throughout this series of posts I’ve taken a somewhat pessimistic view of how SQL Server Agent jobs are managed within most organizations – meaning that most of the code and examples I’ve provided up until this point were based on assumptions about how CHANGE to jobs is managed. That pessimism, to date, has come in two forms:...More
Jul 1, 2015
blog

AlwaysOn Availability Groups and SQL Server Jobs, Part 27: Options and Concerns for More Advanced Deployments

In this series of posts I’ve called out some of the concerns related to SQL Server AlwaysOn Availability Groups and their interaction with SQL Server Agent jobs – both in the form of Batch Jobs (see post #3) and backups....More
SQL Server Pro Forums

Get answers to questions, share tips, and engage with the SQL Server community in our Forums.

Sponsored Introduction Continue on to (or wait seconds) ×