Search Our Knowledge Base

Recent Articles 1 - 9 of 9 Total in "MS SQL Server"

Set Static Ports in MSSQL (1433)

Created by edgar on Nov 9, 2017 and last updated on Nov 9, 2017 in Category: MS SQL Server

  When MSSQL Server Express is installed it generates a random port to listen on.  Variphy Insight needs to be configured with the exact port that MSSQL is using.   Follow these instructions to allow SQL Server Express to accept remote connections over TCP/IP for port 1433.  ... Read More >

Unlock MS SQL SA Account

Created by dan on Feb 24, 2017 and last updated on Feb 24, 2017 in Category: MS SQL Server

  There may be times when using Microsoft SQLServer where you have had multiple failed login attempts and have consequently locked the account within SQL. If other accounts are not setup accordingly, you may be put into a helpess position where a Windows NT or local SQL account does not have t... Read More >

Could not allocate space for object 'dbo.SORT temporary run storage

Created by edgar on Jun 16, 2016 and last updated on Jun 16, 2016 in Category: MS SQL Server

Microsoft SQL tempdb Database   The tempdb system database is a global resource that is available to all users connected to the instance of SQL Server and is used to hold the following: Temporary user objects that are explicitly created, such as: global or local temporary table... Read More >

Migrating MSSQL DB Using Stored Procedures (Windows to Windows)

Created by edgar on May 3, 2016 and last updated on May 9, 2016 in Category: MS SQL Server

Be aware that we discourage the migration of MySQL to MSSQL and vice versa.  Our documentation is written on the assumption of migration to a similar platform and architecture.    PREPARE SOURCE MSSQL SERVER: Step 1. Login to source server via RDP or Console Step 2. Launch MS... Read More >

MySQL upgrade process for Windows

Created by brian on Oct 7, 2014 and last updated on Oct 29, 2015 in Category: MS SQL Server

INTRODUCTION  It may be necessary to upgrade the current version of MySQL that Variphy is using to the latest production release available in order to address security concerns with older versions. This document will cover the steps to upgrade from MySQL 5.0.x -5.5.x, to MySQL 5.6.21 (the late... Read More >

Limit the ammount of memory MS SQL can use for data cache

Created by brian on May 21, 2014 and last updated on May 21, 2014 in Category: MS SQL Server

By Default, Microsoft SQL server 2008 R2 (or later) will allocate memory for database caching dynamically, unlike MySQL server, which requires that the innodb_buffer_pool_size parameter in the My.ini file be set to a fixed ammount. However, in the event that MS SQL is utilizing all availiable memo... Read More >

MS SQL Transaction Logs Full

Created by brian on Apr 15, 2014 in Category: MS SQL Server

A Transaction log file is associated to each MS SQL database, even if the database is in simple recovery mode. While Simple recovery mode does not create logs as exensively as full recovery mode does, running a large query that is requiring signifigant memory and disk space can still ... Read More >

Query to show the current size of the Transaction Log in MS SQL Server

Created by layne on Apr 15, 2014 in Category: MS SQL Server

In MS SQL Server, change the DATABASE_NAME_HERE to the appropriate database name and then run the following query: SELECT (size * 8.0)/1024.0 AS size_in_mb, CASE WHEN max_size = -1 THEN 9999999 ELSE (max_size * 8.0)/1024.0  END AS max_size_in_mb FROM DATABASE_NAME_HERE.sys.datab... Read More >

MS SQL Server Authentication

Created by SQL-Guru on Sep 20, 2013 and last updated on Feb 5, 2014 in Category: MS SQL Server

In SQL Server, there are 2 possible types of Authentication: Windows - Local Windows user accounts to access SQL Server SQL - Configured user accounts within SQL Server, such as the 'SA' account, which is the default admin account (similar to the 'root' account in MySQL)   SQL Server can be... Read More >

Variphy UC Tools & Analytics is trusted and used by thousands of organizations & Cisco Unified Communications/Collaboration engineers
Providing leading edge UC Management Tools to over 1200 organizations worldwide