I just checked the schedule and 2 of the sessions that I submitted for SQL Saturday 114 in Vancouver BC on March 17th have been accepted. The first one is on Unleashing Common Table Expressions in SQL Server, and the second session is Using SSRS reports to analyze SQL Server health. This should be fun!
I just submitted a second abstract for SQL Saturday titled Unleashing Common Table Expressions in SQL Server. This is for the SQL Saturday Redmond and SQL Saturday Vancouver BC sessions. I am hoping to get three sessions accepted for Vancouver.
Covers the steps you need to monitor your SQL Server using the Database Health Monitor application. Learn how to monitor your wait statistics, you blocking queries, and to find out the best ways to improve performance with what you learn. Purchase of this course gets you a license to Database Health Monitor and the ability to connect to 20 servers …
Is it a good idea to run DBCC SHRINKDATABASE regularly? Download the sample file ShrinkSample. This article and samples apply to SQL Server 2005, 2008, and 2008R2. This really depends on a number of factors, but generally the answer is NO, it is not a good idea to run DBCC SHRINKDATABASE regularly. For the purpose of this article, I am …
Default Values and Computed Columns In SQL Server 2008, I was presented with the following error when attempting to create a table that has a default value that references other columns in the same table. Msg 128, Level 15, State 1, Line 6 The name “Subtotal” is not permitted in this context. Valid expressions are constants, constant expressions, and (in …
MSG 128, Level 15, State 1 – not permitted in this context Read more »
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 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) + …
The quick and easy way to determine how much memory your SQL Server is using is to look at the Task Manager on the server and find “sqlservr.exe” in the process list, and look at the “Mem Usage” column. But what if you are not on the server, or if you want to grab this information programmatically from an application, …
A week or so ago I heard someone on the radio talking about Open DNS as a way to help protect children from some of the nasty sites on the internet. After using it now for about a week, I am very impressed, and I have realize that there are some very interesting features beyond just blocking bad sites. DNS …
OpenDNS Review – What a Great Site, what a great service Read more »