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 by Randy Dyess
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.

IT/Dev Connections

Register now to get the best rate available!

From the Blogs
computer keyboard with blue save money key
Apr 15, 2014
blog

Save Thousands in Licensing Costs for SQL Server AlwaysOn Availability Groups

Windows Server 2012 or Windows Server 2012 R2 Standard Edition is a great way to save thousands on licensing—and save yourself some serious headaches when deploying SQL Server AlwaysOn Availabiliity Groups....More
Apr 8, 2014
blog

NoSQL: Eventual Consistency Yields Major Flaws

While I believe that NoSQL can have some places where it legitimately makes sense, I also believe that NoSQL is also the patently wrong choice for a number of different types of applications or use cases....More
Apr 1, 2014
News

SQL Server 2014 Now Available—No Joke

Initial word on the street is that SQL Server 2014 has been very stable so far—which is probably why it went to release so quickly and bypassed what would typically have been another pre-release....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) ×