Upgrade SQL Server 2014 Standard to Enterprise
This blog is about upgrading SQL Server 2014 Standard Edition to the Enterprise Edition. This blog looks & sound much like my October 2013 post, “Upgrade SQL Server 2012 Standard … Continue Reading →
Resolutions found with SQL Server and other types of databases
Microsoft SQL Server database system
This blog is about upgrading SQL Server 2014 Standard Edition to the Enterprise Edition. This blog looks & sound much like my October 2013 post, “Upgrade SQL Server 2012 Standard … Continue Reading →
The sys.dm_tcp_listener_states DMV was introduced in version SQL Server 2012. This is a great DMV because the SQL Configuration Manager does not have to opened to find these values. However … Continue Reading →
In October 2013, I wrote about how to “Upgrade SQL Server 2012 Standard to Enterprise“. Recently in the comments section, Leo asked “Is this impacted by service packing?”. This is … Continue Reading →
About once a year, I am asked to import some text files into a table in a SQL Server database. To accomplish this, I am using the SQL Server 2008 … Continue Reading →
My problem was that I needed to create a cvs file with an older version of a SQL Server database. My plan was to use the BCP utility to create … Continue Reading →
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 →
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 →
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 →
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 →
This blog is about upgrading SQL Server 2012 Standard Edition to the Enterprise Edition. This issue has been written about a couple of times, but one more blog about this … Continue Reading →