Kauai Questions and Answers
Following in the theme of the Questions and Answers website, I have spun off another site called Kauai Questions and answers. Still using the Mechanical Turk to populate the site with data, and it is growing rapidly.
Following in the theme of the Questions and Answers website, I have spun off another site called Kauai Questions and answers. Still using the Mechanical Turk to populate the site with data, and it is growing rapidly.
Teaching the Maintaining SQL Server 2005 class tonight. Week 5 – Working with TSQL, Transactions and Performance Tuning Here is the slide deck for the class tonight. DBA_Essentials_Class05_TSQL_TXN_and_Perf.pdf
Teaching the Maintaining SQL Server 2005 class tonight. Week 4 – Creating Stored Procedures, Functions, and Triggers Here is the slide deck for the class tonight. DBA_Essentials_Class04_Stored_Procedures_Functions.pdf
Teaching the Maintaining SQL Server 2005 class tonight. Week 3 – Creating Tables – Data Integrity, and XML Here is the slide deck for the class tonight. DBA_Essentials_Class03_Creating_Tables_Data_Integrity.pdf
Teaching the Maintaining SQL Server 2005 class tonight. Week 2 – Database Design, Normalization, Analyzing Capacity Needs, Service Broker Here is the slide deck for the class tonight. DBA_Essentials_Class02_Design_Capacity.pdf
Teaching the SQL SERVER SPECIALIST CERTIFICATE PROGRAM – Maintaining SQL Server 2005 Class Tonight. Week1 Here is the slide deck for the class tonight. DBA_Essentials_Class01_Installation
The question came up as to which version of sql server is being run, and how do you determine the exact version number of the SQL server. Here is what I have come up with. From TSQL if you are …
Tonight I created the Questions and Answers website. My wife was watching Mamma Mia (the movie), and that lost my interest quickly so I went and created the Questions and Answers site. Total coding time was about 3 hours, and …
I have just finished all of the paperwork. For spring quarter 2009, I will be teaching a SQL Server DBA class at Western Washington University. The class is for the SQL Server 2005 Specialist Certificate program at WWU. It is …
SQL Server 2008 introduces a new feature called Filtered Index. A filtered index is a way of adding a WHERE clause to the index definition to get faster access to a subset of the data. For instance if you have …