Dive deep into the world of Microsoft technologies at the Community TechDays and get trained on the latest from Microsoft. Build real connections with Microsoft experts and community members, and gain the inspiration and skills needed to maximize your impact on your organization while enhancing your career. What more… You can watch some of these sessions LIVE online, from the comfort of your workstation as well.
SQL SERVER – SQL Server Desktop Screen Background
Buck Woody (MSFT) has published a blog post about SQL Server Desktop Screen Background. I really like the SQL Server Desktop background and I have replaced that background on my work laptop. I came across this particular post because I am a regular reader of his blog. Few of the other interesting posts written by him are following.
SQL SERVER – Difference between SQL Server Express and MySQL
Both SQL Server express and MySQL are two of the Relational Database Systems (RDBMS) available today. Both are freely available and meant for running smaller or embedded databases, yet there are also significant differences between them.
SQL SERVER – Find Gaps in The Sequence
I have previously written two articles on the subject of missing identity and both are very well received by community. I had great fun to write article as many SQL Server expert participated in both the articles. Expert Imran Mohammed had provided excellent script to find missing identity. Please read both the articles for additional information before reading this article about finding gaps in the sequence.
SQL SERVER – Mirrored Backup and Restore and Split File Backup – Introduction
Introduction – Mirrored Backup
This article is based on a real life experience of the author while working with database backup and restore during his consultancy work for various organizations. We will go over the following important concepts of database backup and restore.
Conventional Backup and Restore
Spilt File Backup and Restore
Mirror File Backup
Understanding FORMAT Clause
Miscellaneous details about Backup and Restore
SQL SERVER – Download Script of Change Data Capture (CDC)
My article written on subject of Introduction to Change Data Capture (CDC) in SQL Server 2008 is quite a popular and I have received many request for uploading the script associated with this subject.
SQL SERVER – Plan Caching in SQL Server 2008
Plan Caching in SQL Server 2008
SQL Server Technical Article
Writer:Greg Low, SolidQ Australia
Technical Reviewers From Solid Quality Mentors: Andrew Kelly, Eladio Rincón, Itzik Ben-Gan
Technical Reviewers From Microsoft: Adam Prout, Campbell Fraser, Xin Zhang
Published: August 2009