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 connected to the SQL Server, you can run the following command: SELECT ‘SQL Server ‘ + CAST(SERVERPROPERTY(‘productversion’) AS VARCHAR) + …
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 was able to get questions asked and answered shortly after that. This is an experiment for me in 2 …
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 part of the Extended Education program.
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 a huge table where you are typically only accessing a small part of the table, you can add a filtered …
The biggest benefit that I see with the new backup compression in SQL Server 2008 is that it improves the speed of the restore. The thing that is far more important that a database backup is the actual restore process, and with a compressed backup, this can speed up the restore time by as much as 40% which can make …
In SQL Server, an empty or a null column still would take up space in the database, so even if you added a column that was set to null values, there would still be space taken up in the database. Sparse Columns introduced in SQL Server 2008, are a new type of column configuration that truly take up zero space …
Tonight I had the opportunity to present to the Bellingham .NET users group. About 30 people showed up for the presentation. SQL Server Performance Tuning and Advanced Query Tuning: This presentation will include SQL Server performance tuning tips and recommendations for both the developer and the database administrator. Topics covered will include index usage details, query tuning, understanding the …
SQL Server Performance Tuning for the Bellingham .NET users group Read more »