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
Dec 16, 2014
Sponsored

Eight SQL Server Signs the Illuminati Exist

Make no mistake about it, the signs that the Illuminati exist are all around us. You can find their markings on our buildings, on our currency and even in our music videos. That’s right, they’re everywhere!...More
Dec 2, 2014
blog

AlwaysOn Availability Groups and SQL Server Jobs, Part 16: Job Synchronization Checkup Logic

With Linked Servers configured to allow cross-host or cross-box communication between the servers you’re using to host your AlwaysOn Availability Groups, it’s time to start looking at some scripts that can be used to regularly check whether or not SQL Server Agent jobs are correctly synchronized across all servers in your topology....More
Abstract illustration of linked SQL Servers
Nov 18, 2014
blog

AlwaysOn Availability Groups and SQL Server Jobs, Part 15: Setting Up Linked Servers

Learn about setting up Linked Server definitions to let two (or more) servers in an AlwaysOn Availability Group talk to each other and check up on job statuses of jobs running on each other....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) ×