by Richard Cookson | Jun 20, 2019 | Cloud, Data Management, Databases
In the face of SQL Server 2008’s end of life, there’s been a lot of buzz around utilizing SQL Server on Azure Virtual Machine (VM). As one of the many ways of continuing support for your SQL Server Database, we’d like to elaborate on what exactly...
by Kathleen Long | Jun 11, 2019 | Cloud, Data Management, Databases
SQL Server 2008\2008 R2’s retirement is inching closer; now is the best time to weigh your options and decide on the next course of action. Do you migrate your SQL Server database to an Azure environment or do you keep an on-premise system and upgrade to SQL...
by XTIVIA | Apr 13, 2016 | Data Management, Databases
Maintenance in General is a necessity for SQL Server. No different than changing the oil in your car or going to the Doctor for the annual exam. There are going to be times when you need to perform maintenance on your server. The tricky part is trying to determine...
by Aish Khare | Jan 27, 2016 | Data Management, Databases
Recently, we noticed on a staging environment that the LOGPRIMARY setting was set to 35, yet the number of logs on the log path was only 21. Number of primary log files (LOGPRIMARY) = 35 35 Number of secondary log files (LOGSECOND) = 45 45 db2inst1# ls -ltr total...
by XTIVIA | Jan 7, 2016 | Business Intelligence, Data Management, Data Warehousing, Databases
This discussion provides an understanding of what is included in a sound backup strategy for your Sql Server data warehouse application. Most data warehouse applications require a different backup and recovery strategy than a typical online transaction processing...