SQL

At [04:50] Symon Perriman meets with Joseph Chan, a Principal PM Manager on the System Center team, to talk about System Center Advisor and how it now integrates with System Center 2012. Joseph first gives an introduction to Advisor and how people can start using this free cloud service.…

Although you might build say, a Sharepoint infrastructure in Windows Azure and leave it deployed as a permanent feature, totally integrated into your enterprise infrastructure, there are a growing number of organisations taking advantage of the temporary nature such infrastructures can have.…

Blain Barton  welcomes Jennifer Moser, Cindy Gross, Chuck Heinzelman and Thomas LaRock to the show as they discuss the upcoming PASS Business Analytics Conference. If BI and Big Data are important to you this is a must attend event. Tune in as they chat about why you should go and what you’ll…

Bob Hunt and Jose Barreto continue their Hyper-V over SMB series and in today’s episode they discuss a recently released independent study that compares the performance between Hyper-V local and Hyper-V over SMB. Tune in as they chat about the results as they take a deep dive to see how Windows…

Like what you heard? Try Windows Azure for FREE and enjoy the freedom to use your preferred OS, language, database or tool. Windows Azure can help you deploy sites to a highly scalable environment, deploy and run virtual machines, and create highly scalable application in a rich PaaS environment.…

Technical Evangelist, Chris Avis welcome Principal Security Architect Man Nguyen to the show as they discuss how Microsoft IT created a process to track, manage and report PCI compliance at Microsoft while leveraging System Center, Windows Server and SQL Server solutions. Tune in as he shares with…

Module 15 shows the mechanisms by which the database can be monitored for availability, errors, and performance. Statistics that can be captured for both proactive and reactive administration of the databases are reviewed here. [03:59] - Error logs [10:50] - Error messages [19:50] - Monitoring…

Module 14 provides a high-level overview of the scalability and high availability features available in each RDBMS. Oracle and SQL Server are both enterprise class RDBMS, therefore the topics of scalability and high availability are deemed important. However, due to the scope of the course the…

Module 13 is divided into two sections: tuning an instance and tuning an application. Tuning the instance involves taking steps to ensure that system resources such as memory, CPU and I/O are used efficiently. Tuning an application starts with the design and architecture of the application and…

Module 12 lists the types of errors encountered in a database and the various mechanisms that are available to safeguard against these errors. This module discusses various types of backups and recovery methods available. This module also covers Oracle’s Recovery Manager (RMAN) and the equivalent…