by XTIVIA | Jul 11, 2019 | Blog, MySQL
Here at XTIVIA we have provided professional services many times to clients running into errors while restoring a MySQL database from a backup created with mysqldump. One specific error on import of a backup, Error 1227, reports “Access denied; you need (at...
by XTIVIA | Jul 2, 2019 | Blog, SQL Server
As a SQL Server DBA, there will be times when you will cross over into the system administrator realm of responsibilities or at a minimum explaining them how to fix errors so your SQL environment runs better. WSFC (windows server failover cluster) is setup for...
by XTIVIA | Jun 20, 2019 | Blog, SQL Server
There comes a time in everyone’s life that they need to be concerned about tempdb. I know… we all have configured it correctly and it’s running great. The application and all of the developers are using it like crazy …Wait… that may not be a good thing....
by XTIVIA | Jun 13, 2019 | Blog, Database
Whether you pronounce it “S-Q-L” or “sequel,” we interact with SQL, NoSQL, or NewSQL in one way or another everyday, but what exactly is the difference between them? The fact of the matter is that, although they’re all types of databases,...
by XTIVIA | May 31, 2019 | Blog, PostgreSQL
Figuring out when to cluster can be a mountain to climb in itself, but combining that with figuring out which software to use can often be an insurmountable task. In this article I will go over the clustering options available for PostgreSQL and highlight their...
by XTIVIA | May 28, 2019 | Blog, SQL Server
CTEs may not be used for performance but there are times they could help you from a performance standpoint. The following example uses the same logic written in a way to use three different types of temporary objects. It shows what is done with each process using...
