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#.… Read More »Finished the Beginning C# Course on the Joes2Pros Academy
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 | TRACEON |
| TRACESTATUS | UNPINTABLE | UPDATEUSAGE |
| USEROPTIONS |
END OF PUZZLE ————————-
For more information on DBCC Commands:
One of my sessions was accepted for SQL Saturday #190 in Denver this year. Please come see my CTE presentation. Common Table Expressions –… Read More »I’m Speaking at SQL Saturday #190 in Denver
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… Read More »SQL Server Technical Debt
Related Common Table Expression Links Sample Database for Common Table Expressions Writing Your First Common Table Expression with SQL Server Video: Writing Your First… Read More »What is a Common Table Expression – Video
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… Read More »One Thousandth Download of Database Health Reports
Across 2. Management Studio 5. The database that is used as a template when creating a new database 6. Using a backup 7. Reporting Services… Read More »SQL Server Crossword Puzzle
To start with for Transparent Data Encyrption (TDE) we will need to be using Enterprise (or Developer) edition of SQL Server 2014. I am using… Read More »Enabling Transparent Data Encryption on SQL Server 2014
As part of my contribution back to the SQL Server community I am adding a new feature into the free Database Health Reports application. I am currently… Read More »Working on the T-SQL Technical Debt feature in the Database Health Reports
Technical Debt is a programming concept that is also known as code debt. The concept of Technical Debt applies closely with Agile software development, but… Read More »T-SQL Technical Debt