Increasing the Font in SSMS on the Fly
Recently, I have learned a neat trick to quickly increase or decrease the font size. This something I found with a different database product, but was happy to see work … Continue Reading →
Category: SQL Server
Microsoft SQL Server database system
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 →
dm_tcp_listener_states DMV Altered to be Readable
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 →
Upgrade SQL Server 2012 Standard to Enterprise with Different Service Packs
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 →
Error 0xc0204016: SSIS.Pipeline … The length must be between 0 and 8000.
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 →
BCP with No Output & No xp_cmdshell
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 →
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 →
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 →