Again following the Agile philosophy of Release Early and Release Often, there is another minor release of Database Health Beta 7. I called this one Beta 7++, the version has been updated to 1.99.7.512. In this version the following minor …
Beta 7++ Additional Cleanup on the Technical Debt Read more »
One of the ideas behind Scrum software development is the idea of “Release early, Release Often and Get Customer Feedback.” After the release of Beta 7 of the Database Health Reports earlier this week I received an email with a …
I have been working on Beta 7 over the last 3 months, and it is finally ready. Beta 7 has been released today featuring the addition of the SQL Technical Debt reporting. Besides the SQL Technical debt reporting, the other area …
Database Health Beta 7 Released – Featuring SQL Technical Debt Analysis Read more »
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 …
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 …
Finished the Beginning C# Course on the Joes2Pros Academy Read more »
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 …
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 …
SQL Sunday Fun – Word Search with New T-SQL 2012 Functionality Read more »
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 …
SQL Sunday Fun – Word Search with SQL Server DBCC Commands Read more »
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 …
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 …