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
business people around a table and laptop
Oct 9, 2014
blog

AlwaysOn Availability Groups and SQL Server Jobs, Part 10: Dynamic Detection Gotcha #3

You can interject a SQL Server Job Step into your Jobs and have this new/injected Job Step do some checking for you. Here's a look at everything that’s involved in such an approach....More
Man holding a piece of paper with the word GOTCHA
Oct 7, 2014
blog

AlwaysOn Availability Groups and SQL Server Jobs, Part 9: Dynamic Detection Gotcha #2 3

Given that a USE statement is parsed before code is actually run, there are a few options that could be used as a around when it comes to detecting whether or not code should be run....More
iceberg
Oct 2, 2014
blog

AlwaysOn Availability Groups and SQL Server Jobs, Part 8: Dynamic Detection Gotcha #1 1

Learn about why the option of dynamically detecting whether or not to run a SQL Server Job at execution time is quite a bit more problematic than you might think....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) ×