Check these sites out!    
   
 Print   
 Welcome to SQLServerManagement    

I want to welcome you to SQLServerManagement.com. This web site serves as personal spot for me to put items I find interesting to SQL Server database administrators who need to manage very large and complex database environments. Over the last few years I have found myself moving more and more away from everyday database management to a role that I like to describe as “Infrastructure Architect”. This role has me performing quite a bit of hardware tuning, sizing, long term capacity planning and general design of the infrastructure in which our databases sit on. This role is a natural progression for me as I find that the skill needed to work with large OLTP infrastructure designs are very similar to those needed to work with large BI infrastructure designs. Something I have been working with more and more the past year.

So to make a long story short, you will find both database administration information and infrastructure design information on this site as it grows and develops over the next few years.

I hope you enjoy this site,

Randy Dyess

 

   
 Print   
 Latest Annoucements    
News for December 14, 2009 - Monday, December 14, 2009
One of those, I have too much to do days. The next two weeks I will be working on creating a class for our India subsidiary on performing database maintenance while not affecting the uptime of a database. So much material, so little time to discuss it all. 
Latest News - Thursday, December 10, 2009
Hello everyone. It has been a long time since I started putting this web site together and recently I have told myself that I really needed to get serious about the site or just take it done. I have decided that I wanted to get serious again about maintaining a web site like I used to a few years ago.

So here we go.
 
   
Syndicate   Print   
 Scheduled Events    



Date: Jan 2010 TBD
Location: Webinar Link to follow
Link: TDB/
Topic: Oracle to SQL Server 2008 Migration/Conversion guidance & best practices
Description: In this session you will be taken through the best practices that you must follow to successfully complete a SQL Server migration from the Oracle database platform to SQL Server. The session will take the attendee through the creation of the migration plan, implementation of the migration plan, and post- migration tasks. The attendee will understand the tasks that must be completed to ensure a successful SQL Server migration effort from Oracle to SQL Server 2008.

Date: February/9/2010 @ 11:30am
Location: Houston Area SQL Server Users Group
Link: http://houston.sqlpass.org/
Topic: Managing the Very Large Database: Best practices for administrators managing 1TB or more
Description: In this session you will learn tips, tricks, and best practices that are needed to manage a VLDB. The attendee will be shown methods learned from years of VLDB management and how they can implement those methods in their environment. Whether it be file layout, backup and restore strategy, or designing a database environment for large data loads, this session will take you through tricks and tips that can help you achieve a worry-free VLDB.
   
 Print   
 Latest Blog Posting    
I have just recently spent quite a bit of time working with Microsoft on their Fast Track initiative. My tasks were to help them create a 1-day class to explain what Fast Track Data Warehouse Reference Architecture is and then help them deliver the class at various Microsoft locations in the US. We delivered in Dallas TX, Reston VA, Iselin NJ, and Chicago IL. Hopefully over the next year the class will be delivered again in the US and in Europe as well.

While working with the material to create the class and prepare for the delivery, I started sketching out a series of blog postings, articles, and even additional whitepapers and another class that will help the average database administrator understand the technology behind what makes Fast Track RA work.

I have started the process of writing these blog postings and wills start putting them up on this site in January. I do not want to rush them as I want the information be useful in helping you understand Fast Track and what it is and what it is not while understanding all the SQL Server concepts behind it.

As I post these blogs I will also be posting deeper blogs on the SQL Server concepts behind Fast Track. These blogs will contain information and discussions on topics like partition, compression, fragmentation, parallel loads, etc. that everyone can make use of to help design and management a large environment, OLTP or DW related. Look forward to these blogs being mixed in with those discussing Fast Track over the next few months.

I have also made the decision that I will not be allowing direct comments on the blog postings. I just do not want to spend most of my time deleting spam and other comments. I do welcome comments sent through the contact form and I will answer and post those comments on the blog as I get them. If you do not want your comment posted, just say so in the email and I not post the comment. I may turn it into a FAQ that does not give away any of your information or specifics, just a general question and answer.
   
 Print   
 Latest Video    

It is my plan to start adding some videos to the site to help explain some of the topics a little better. I have found out over the years that a short video can take the place of a long article. Check back for videos to start appearing on various topics and for short videos over the material I cover in some of my classes to make their way here.


 
   
Syndicate   Print   
 Latest Article    
It has been a long time since I wrote an entire article for my web site or another. Starting in Jan 2010, I have several articles that are in various stages of completion that I will be able to post. I will also be making announcements at in 2010 about a new venture within Solid Quality that I hope will be of tremendous us to you as well.
   
Syndicate   Print   
 Latest Tool Review    

Reviews of SQL Server tools coming soon

   
Syndicate   Print   
 Our Sponsors    
   
 Print   
 Solid Quality Courses    
I have created and actively deliver several SQL Server related courses through Solid Quality Mentors. If you would like to receive more information about any of the following courses, please email me or follow the link to the course page at Solid Quality Mentors.

These courses can be delivered at a physical location or remotely over the internet. I have found out recently with the drop in training budgets more and more people are asking for remote training. Each of the courses can be delivered entirely through the internet without missing any of the material of the course. Labs are done on the attendees own time with help if requested.

If the course you are interested in is not scheduled, contact me as I create a “waiting” list for each course and when I have enough interest I will contact everyone on the list to work out a good time for everyone. I do encourage you to do this as we may have a course with several others on the list and your name may the last one we needed.

If you have more than 4 people at your location would like to schedule a physical or remote custom class, please email me for more details. I find that a company that desires training for all their DBAs usually enjoys the custom class I can create that deals with their particular needs and issues. Modules can be combined from all my courses to create these custom classes so you can design your own course. There will be additional charge for creating material that is not currently covered in one of my classes as I have to set aside time to create that content. Demos and ad-hoc labs done against your environment to solve one of your problems come with the cost of the custom course.

Guru’s SQL Server Database Administration Database administrators and developers often need to have a deep understanding of SQL Server and its internals in order to maintain very large and complex environments or perform advanced level troubleshooting. This 5-day very intense seminar is designed for database administrators and advanced developers who have found themselves faced with administrating very large and complex databases and wish to know how SQL Server really interacts with the hardware and how the SQL Server database engine works behind the scenes. Link

Introduction to SQL Server Database Administration Often developers are faced with performing database administration tasks against the databases they are developing against. This 5-day introduction level course is designed for developers and power users who have found themselves faced with becoming a database administrator. This course prepares individuals who are familiar with databases with the skills they need to understand the tasks that must be performed to maintain and administrate Microsoft SQL Server 2005 and 2008 databases Link

Microsoft SQL Server Performance Tuning Bootcamp This five day intensive course is designed to give attendees a broad look at the performance tuning concepts and methods found in SQL Server 2005 and SQL Server 2008. This course is designed to prepare the SQL Server DBA for a transition to SQL Server 2005 or SQL Server 2008 while discussing best practices for a variety of performance topics that SQL Server DBAs will face in their day-to-day job functions. Link

SQL Server Database Administration for the Experienced DBA Database administrators often need information that goes beyond the simple CREATE, DROP, and ALTER statements. This 5-day intensive course is designed for developers and database administrators who wish to learn more advanced database administrative techniques o who wish to learn components of SQL Server they do not yet understand fully and need to implement in their current environments. This course prepares individuals who have 2-3 years of experience with SQL Server databases with the skills they need to maintain and administrate larger or more complex Microsoft SQL Server 2005 and 2008 databases. Link

SQL Server Database Administration for the Oracle DBA This 4 day course is designed for Oracle database administrators who have found themselves faced with the advanced administration of a SQL Server database. This course prepares individuals who are familiar with databases with the skills they need to understand the tasks that must be performed to maintain and administrate larger and more complex Microsoft SQL Server 2008 databases. Link
   
 Print   
Inspired by Nina