Download scripts here: view_IndexInformation.sql (for all DBs at once), view_IndexInformation_CurrentDB.sql (for a DB in scope) and view_IndexCreation.sql (for relevant missing indexes) Hello all, Here is another post on SQL scripts that may help DBAs, following the series “SQL Swiss Army Knife”. I’ve been using and tweaking this script for years now, and with a recent update for SQL…
Overview of Microsoft Dynamics AX build numbers
Microsoft Dynamics 365 for Operations (roadmap | what’s new) Version Build Availability To learn more Application version 1611 7.1.1541.3036 Nov 2016 Upgrade Platform Update 3 7.0.4307.16141 Nov 2016 Upgrade Platform Update 2 7.0.4230.16130 Aug 2016 Upgrade Platform Update 1 7.0.4127.16103 May 2016 Upgrade Application version 7.01 7.0.1265.23014 May 2016 Upgrade Platform version 7.0 RTW 7.0.4030.16079 Mar 2016 How…
Adaptive Index Defrag
Latest update: 11/04/2016 (Check change log) Download on GitHub NOTE: if using SQL Server 2012 or SQL Server 2014, mind there is a bug where the online index rebuild can cause index corruption or data loss when it is used together with concurrent queries that modify many rows. If using @onlineRebuild option, to work around this,…
SQL Swiss Army Knife #9 – Fixing VLFs
Download script here: Fix_VLFs.sql Hello all, Here is another post on SQL scripts that may help DBAs, following the series “SQL Swiss Army Knife”, this time revisiting the topic of VLFs. I blogged on this subject several times before and if you want to read more about it just click here. Anyhow, a few months…
The SQL Swiss Army Knife #6 – Evaluating compression gains
Download code here: view_CompressionGains.sql Hello all, Here is another one focusing on SQL scripts that may help DBAs, following the series “SQL Swiss Army Knife”. This time we are evaluating table and index compression, specifically an approach on how to select the best compression method for a database object. There is a great deal of…
Extending Trials of TFS 2010,TFS 2012 and beyond
***UPDATE Nov 2, 2016*** Starting in TFS 2015 Update 3 and beyond, this trial extension process has been removed. We have moved to and “honor based system”. A trial will expire and the product will inform you of that but it is up to you to stop using it at that point. The old process…
Sample code to detect .NET Framework install state and service pack level
Introduction Many installers and applications require that one or more versions of the .NET Framework be installed on the system in order to be able to install and function correctly. This article provides sample C++ code that can be used in a setup program or in an application’s code to detect the install state and…
.NET Framework Setup Verification Tool User’s Guide
.NET Framework Setup Verification Tool User’s Guide Introduction This .NET Framework setup verification tool is designed to automatically perform a set of steps to verify the installation state of one or more versions of the .NET Framework on a computer. It will verify the presence of files, directories, registry keys and values for the .NET…
.NET Framework Cleanup Tool User’s Guide
.NET Framework Cleanup Tool User’s Guide Introduction This .NET Framework cleanup tool is designed to automatically perform a set of steps to remove selected versions of the .NET Framework from a computer. It will remove files, directories, registry keys and values and Windows Installer product registration information for the .NET Framework. The tool is intended…
File URIs in Windows
Invalid file URIs are among the most common illegal URIs that we were forced to accommodate in IE7. As I mentioned in a previous blog post there is much confusion over how to handle file URIs. The standard for the file scheme doesn’t give specific instructions on how to convert a file system path for…