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 …
SQL Sunday Fun – Word Search with SQL Server Keywords Read more »
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 …
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 …
One Thousandth Download of Database Health Reports Read more »
Nice shirt I discovered at Amazon.com
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 9. An index that rearranges the structure of a table 12. The underlying structure of …
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 SQL Server 2014 Enterprise Edition CTP1, which is the early release of SQL Server 2014. …
Enabling Transparent Data Encryption on SQL Server 2014 Read more »
Hekaton is also known as SQL Server In-Memory database, touted to accelerate transaction throughput up to 30x performance increases on existing hardware. With a new latch-free technology Hekaton is claimed to dramatically increase performance. Are you ready to increase the speed …
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 working on adding a new feature into the Database Health Reports to analyze T-SQL Technical Debt. If …
Working on the T-SQL Technical Debt feature in the Database Health Reports Read more »
I received this rave today about the Database Health Reports. It has been posted on the Raving Fans page. 7/17/2013 – Beta 6 Rave The software is really good, I am using very regularly to audit and performance tune the …
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 also applies to database development. There are many tools available to report on technical debt …