Month: August 2013

Suggest An Idea for Database Health Reports

As I get ready for Beta 7 to launch I have decided that for Beta 8 I will focus on feature suggestions from the users of the Database Health application.  I have created a feedback system for users to suggest their

Posted in Database Health, Technical Debt Tagged with: ,

Finished the Beginning C# Course on the Joes2Pros Academy

After 23 years of programming experience, many years of C, C++ and C#, I realized that I have never actually taken a course in C#.  As part of the early release and testing on the Joes2Pros Academy I decided to work

Posted in Academy Tagged with:

Introducing the Joes2Pros Academy

The new Joes2Pros Academy has just launched. The Academy provides an interactive classroom experience that can be accessed on your own time as you need it. This site has high quality content, quizzes and exams. Students can interact with other students and instructors

Posted in Academy, DBA, SQL 2012, TSQL 2012 Tagged with:

SQL Sunday Fun – Word Search with New T-SQL 2012 Functionality

    Click on the grid to enlarge, then print it. Find the following words in the grid up, down, left, right, horizontal, vertical, and diagonal. ROWS  RANGE  PRECEDING  FOLLOWING  UNBOUNDED  IIF  CHOOSE  OFFSET  FETCH  FORMAT  CONCAT  SEQUENCE  PARSE  TRYPARSE 

Posted in SQL Sunday, TSQL Tagged with: , , , , , , ,

SQL Sunday Fun – Word Search with SQL Server DBCC Commands

The following DBCC commands are all hidden in the word search.  Be aware, some of the DBCC commands are undocumented. CACHESTATS CHECKCATALOG CHECKCONSTRAINTS CHECKDB CHECKFILEGROUP CHECKIDENT CLEANTABLE DROPCLEANBUFFERS FLUSHPROCINDB FREE FREEPROCCACHE FREESESSIONCACHE FREESYSTEMCACHE INDEXDEFRAG OPENTRAN OUTPUTBUFFER PAGE PROCCACHE SHOWCONTIG SHRINKDATABASE

Posted in DBCC Commands, SQL Sunday, TSQL Tagged with: , , , , , ,

I’m Speaking at SQL Saturday #190 in Denver

  One of my sessions was accepted for SQL Saturday #190 in Denver this year. Please come see my CTE presentation. Common Table Expressions – Introduction Have you ever wanted to create a recursive query, but didn’t see how to

Posted in SQL Saturday Tagged with: , ,

SQL Server Technical Debt

As Beta 7 of the Database Health Reports approaches is just three weeks, the big new feature that has been added is the SQL Technical Debt Analysis. The SQL Technical Debt Analysis a great check for those areas that are

Posted in Database Health, Technical Debt Tagged with: , , , , ,

SQL Sunday Fun – Word Search with SQL Server Keywords

The following SQL Server keywords are hidden in the word search puzzle. Find them all! ALTER BETWEEN CLUSTERED COLUMN COMMIT CREATE DATABASE DEFAULT ELSE END EXECUTE EXIT FOR FUNCTION GRANT IDENTITY INSERT KEY NOCHECK NONCLUSTERED NULL OFFSETS OPENDATASOURCE OPENQUERY OPENROWSET

Posted in TSQL Tagged with: , , , , , , ,

What is a Common Table Expression – Video

  Related Common Table Expression Links Sample Database for Common Table Expressions Writing Your First Common Table Expression with SQL Server Video: Writing Your First CTE with SQL Server Common Table Expressions – Terminating the Previous Statement CTE Scope Introduction

Posted in CTE, CTE Book Tagged with: , , , , , , ,

One Thousandth Download of Database Health Reports

Today marks the 1000th download of the Database Health Reports in the last 11 months since Beta 1 was released. I thought this would be the perfect opportunity to recap on the history of the database health report application. First

Posted in Database Health Tagged with: , , , , , , , , ,