Install SQL Server Management Studio (SSMS) 2016 Without Internet Access: One of my frustrations with SQL Server 2016, is that the SQL Server Management Studio (SSMS) is no longer included with the database instance installation. It is now has its … Continue Reading →
TSQL Query to Find Fragmented Indexes Including Partitioned Indexes
What I wanted to find is the most fragmented indexes, including the partition number (for the partitioned tables) and size for each index. I want to bring back only the … Continue Reading →
How to Install SQL Server 2012 Shared Management Objects
Recently was asked to install the SQL Server 2012 Shared Management Object on an application server. There was a new application need some of the library file that are installed … Continue Reading →
Script to change the SERVERNAME property in SQL Server
When the Master Database is restored or moved to another server with with a different hostname, the master database is unable to detect that it is on a new server. … Continue Reading →
Microsoft Lync Starts Automatically When I Log-On
At work, a vendor asked if I would join a Lync Meeting. Since then Microsoft Lync now opens every time I log on my laptop. This was annoying. Below is … Continue Reading →
Moving a Certificate from Windows to the Java Cacerts File
Recently I had a server with a java application that one day stopped authenticating users. I was able to trace it back to the JDK (java developer kit) that the … Continue Reading →
Installing node.js on Oracle Linux Server (OEL)
Install node.js is much easier to install on other Linux operating system like Ubuntu & Fedora. I was challenged to find a way to install node.js on the Oracle Linux Server … Continue Reading →
Cloned Oracle Linux (OEL) is missing eth0
Normally I use Oracle Linux to do much of my testing because of its similarity to RedHat Linux. However I had an issue when I cloned OEL (Oracle Enterprise Linux) … Continue Reading →
Grep like command in Windows?
In Linux & Unix, I find that I use the grep command to filter the information by different utilities that returns more then a screen full of information. For example … Continue Reading →
Delete or Drop a GridFS object in mongoDB
Recently I was asked to remove a GridFS object from one of our mongoDB databases. As of version 2.4.6 of mongoDB, this is not straight forward right click & delete … Continue Reading →
Renaming a GridFS object in mongoDB
Recently I was asked to rename a GridFS object from one of our mongoDB databases. As of version 2.4.6 of mongoDB, this is not straight forward right click & rename … Continue Reading →