There was no change to the compatibility levels between SQL Server 2008 and SQL Server 2008 R2. SQL Server can run in a number of different compatibility levels, but how do you change it and how do you set it. These compatibility levels reflect the version of SQL server. 60 = SQL Server 6.0 65 = SQL Server 6.5 70 …
Originated as Sybase SQL Server Acquired by Microsoft and named Microsoft SQL Server in 1989 Recent Versions (2005, 2008, and 2008 R2) But what is it? A system for managing large amounts of data Provides a language TransactSQL (T-SQL) to access and manipulate data A multi-user server based application A relational database
Here are the slide decks from the Introduction to SQL Server class – January 2010. Class 1 About the Instructor Introduction and Class Overview (Review Syllabus) Course Logistics – What to expect and what is expected What is SQL Server? Installing SQL Server 2008 SQL Server Management Studio Differences between SQL Server 2005 and SQL 2008 Introduction to SQL Books …
Notes from the Introduction to SQL server class. Read more »
The current datacenter has failed. The company that we have been using Fibercloud in Bellinhgam WA, with their “Always On” slogan has had an epic failure. Server temp of 117 degrees F means that it is time to move to a real datacenter. Planning on configuring a new SQL server a the new location, then doing a full restore and …
Moving to a new datacenter – EPIC FAIL – Fibercloud. Read more »
If you are using Windows 7, give this a try. When you have multiple windows all visible on your desktop, just click on the title bar of one of the windows. While holding your mouse button down “Shake” that window my moving your mouse back and forth quickly. All other windows on the desktop will be minimized, leaving the window …
This week I have been at the SQL Connections conference in Las Vegas. With 7 to 9 hours of classes and presentations every day, all on Microsoft SQL Server. The classes included the Next Generation of SQL Server, Distributed Applications with Service Broker, Building High Availability Using Microsoft SQL Server 2008, Virtualization, Installation and Migration Strategies, Logging and Recovery, Minimally …
Home after a week at SQL DevConnections 2009 in Las Vegas Read more »
This week I am in Las Vegas attending the DevConnections conference on the SQL Server track. A whole week of classes on SQL Server.
First off if you are not familiar with ISO files, an ISO file is a file that is a disk image of a a CD disk or DVD disk. It is like a copy of the entire CD or DVD into a ISO image on your hard drive. These were typically used for copying or distributing a disk contents over …
The new Travel Questions and Answers site is now live. http://travel.civicvoice.com/ Questions about everything that you wanted to know about travel and were afraid to ask, like: Which is the best country for a honeymoon? Enjoy… Steve Stedman Belingham WA
Teaching the Maintaining SQL Server 2005 class tonight. Week 9 – Class Project Presentations. SQL Server Agent. Here is the slide deck for the class tonight. DBA_Essentials_Class09_SQL_Server_Agent.pdf