Teaching the Maintaining SQL Server 2005 class tonight. Week 8 – SSIS Packages: In Detail / Flat Files. Creating Partitions. More TSQL. Here is the… Read More »SSIS Packages: In Detail / Flat Files. Creating Partitions. More TSQL.
Teaching the Maintaining SQL Server 2005 class tonight. Week 7 – High Availability and Replication – Implementing Database Mirroring and Log Shipping. Here is the… Read More »High Availability and Replication
Teaching the Maintaining SQL Server 2005 class tonight. SQL Server Reporting Services (SSRS) Here is the slide deck for the class tonight. DBA_Essentials_Class06_SSRS.pdf
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… Read More »Kauai Questions and Answers
Teaching the Maintaining SQL Server 2005 class tonight. Week 5 – Working with TSQL, Transactions and Performance Tuning Here is the slide deck for the… Read More »Working with TSQL, Transactions and Performance Tuning
Teaching the Maintaining SQL Server 2005 class tonight. Week 4 – Creating Stored Procedures, Functions, and Triggers Here is the slide deck for the class… Read More »Creating Stored Procedures, Functions, and Triggers
Teaching the Maintaining SQL Server 2005 class tonight. Week 3 – Creating Tables – Data Integrity, and XML Here is the slide deck for the… Read More »Creating Tables – Data Integrity, and XML
Teaching the Maintaining SQL Server 2005 class tonight. Week 2 – Database Design, Normalization, Analyzing Capacity Needs, Service Broker Here is the slide deck for… Read More »Database Design, Normalization, Analyzing Capacity Needs, Service Broker
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… Read More »Installing / Configuring SQL Server 2005
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… Read More »Determining the version of SQL server from TSQL