by XTIVIA | Sep 29, 2020 | Blog, Microsoft, Software Licensing
Keeping up with Microsoft product licensing and their product models can get tricky. As a Gold Microsoft partner, it’s our job at XTIVIA to keep up with all things Microsoft. We’re happy to help answer questions that inevitably come up around SQL Server,...
by XTIVIA | Jun 20, 2019 | Blog, 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 | Blog, 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 | Blog, 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 XTIVIA | Feb 17, 2016 | Blog, Databases
Securing your data is very important and database encryption is just part of that landscape. Taking advantage SQL Server database encryption can be a daunting task but once it is configured it is also important to monitor it. This query is intended to...
by XTIVIA | Feb 17, 2016 | Blog, Databases
SSMS Shortcut is what we are going to be learning about in this blog post. When writing T-SQL it can be quite distracting to go look up a table definition or information on a database object. Enter the SQL Server Management Studio (SSMS) shortcut key ALT + F1....
by XTIVIA | Feb 17, 2016 | Blog, Databases
Abstract Upgrading or migrating your SQL Server can seem like a very daunting task. And it certainly can be especially when we start to look at hardware requirements, size and space needs, time constraints, and the numerous impacts to the the users and applications...
by XTIVIA | Feb 15, 2016 | Blog, Databases
SQL Server 2005 extended support ends April 12, 2016. What this means to SQL 2005 users is no more security updates or hotfixes. What it means to us as DBA’s is we’re in a situation we never want to be in, where our database platform is down or compromised...
by XTIVIA | Jan 8, 2016 | Blog, Databases
This article is part 10 in a series on the top 10 most common mistakes that I have seen impact SQL Server Performance and Resiliency. This post is not all-inclusive. Most common mistake #10: Storage For the final post in the top 10 items that influence the performance...
by XTIVIA | Jan 8, 2016 | Blog, Databases
This article is part 9 in a series on the top 10 most common mistakes that I have seen impact SQL Server Performance and Resiliency. This post is not all-inclusive. Most common mistake #9: Automatically Shrinking Your Database This is a topic that has been written...
