by Joshua Fletcher | May 17, 2018 | Blog, SQL Server
A service is a program that runs in the background that does not require any user interaction. Some examples of services are the drivers for your keyboard and mouse, your antivirus software, and the SQL Server Service. The SQL Server Service is the executable process...
by XTIVIA | May 10, 2018 | Blog, SQL Server
For some time now, SHA-1 has not been allowed to be issued from CA’s with few exceptions. This was due to a large catalog of evidence suggesting that SHA-1 was less secure than acceptable. Starting with SQL 2016 self-signed certificates are issued using SHA-2,...
by XTIVIA | Apr 18, 2018 | Blog, SQL Server
These are the ten most important commands to know as a DBA working in a Linux environment. This is not specific to any Linux distribution or single database platform necessarily, however, I have added some really good links specific to MSSQL Server running on Linux at...
by XTIVIA | Apr 12, 2018 | Blog, SQL Server
One of the new features introduced by Microsoft in SQL Server 2017 is the new DMF sys.dm_db_log_info. It helps to take a look at the structure of the transaction log file without using the undocumented DBCC LOGINFO. As we all know, Transaction Log Files are internally...
by XTIVIA | Mar 15, 2018 | Blog, SQL Server
SQL Server DBAs use Transaction Log backups for point-in-time recovery of a database in the full recovery model. It truncates the log file and prevents it from growing too large and consuming a lot of disk space. Before SQL Server 2017, these backups were scheduled in...
by XTIVIA | Jan 16, 2018 | Blog, SQL Server
The most concerning issue with SQL Server merge replication is that it is not adequately designed to scale past a very small amount of subscribed instances. From a DBA’s perspective, we find merge replication the least desirable of the Microsoft replication...
