This year in October, I again have the privilege to speak at PASS Summit in Seattle. One of my favorite topics, Database Corruption was the session that was selected. Here are the details. When Database Corruption Strikes You database is …
Today we released Episode 52 on the SQL Data Partners podcast on the R Programming Language. You might remember a few weeks ago the announcement that I was joining Carlos Chacon as the co-host of the weekly podcast. Episode 52 …
The Service Pack 2 release of SQL Server 2014 introduces a new DBCC command called DBCC CloneDatabase. Books online states: “DBCC CLONEDATABASE should be used to create a schema and statistics only copy of a production database in order to …
I have just released version 2.4.3 the July 2016 version of Database Health Monitor. You can download it now at the Database Health Monitor website. http://DatabaseHealth.com/download Since the releases have been coming about monthly lately, I have decided to add …
With previous versions of SQL Server to get the developer edition, it was usually available for around $50 USD at Amazon.com. With the introduction of SQL Server 2016 Microsoft has made the SQL Server 2016 Developer Edition a free download. …
I am excited to announce that I have joined Carlos Chacon to become the co-host of the SQL Data Partners – SQL Server podcast. The weekly show has just reached 50 episodes, and Carlos has asked me to join him as co-host on …
Today I released the latest update to Database Health Monitor. Version 2.4.2. It has been about a two weeks since version 2.4.1 release and version 2.4.2 has a few new features, and a couple bug fixes. Here is a preview of …
Database Health Monitor Version 2.4.2 Released Today Read more »
Just one day after releasing Database Health Monitor version 2.4, today I released version 2.4.1. Version 2.4.1 includes a bug fix and 2 new feature that were added after the release of version 2.4. Feature: Support for SQL Server 2016. Since …
If you haven’t tried Database Health Monitor Version 2.4 might be a good time to try it out. Five and a half years of my development time has gone into Database Health monitor, and hopefully the features will show it. Here …
Who owns that database? A quick check of the owner of most databases will likely reveal that the databases are either owned by sa, or by someone with sysadmin permissions (or domain admin permissions). This is not recommended, however it …