3am SQL Emergency? We have a Service for that!
You call us in the middle of the night, and within 2 hours we’re on the issue with our Highly Available Support Managed Service! Just… Read More »3am SQL Emergency? We have a Service for that!
Using Synonyms on SQL Server
Synonyms in SQL Server are a useful feature that allow developers to create an alias or alternate name for an object in the database. This… Read More »Using Synonyms on SQL Server
Query to find the most used data files on SQL Server
To find the most used data files on SQL Server, you can use the sys.dm_io_virtual_file_stats dynamic management view. This view contains statistics about the I/O… Read More »Query to find the most used data files on SQL Server
Is Your SQL Server Secure?
SQL Server is a popular database management system that is widely used to store and manage data in a variety of applications. As with any… Read More »Is Your SQL Server Secure?
Our Managed Services Video Explanation
Sometimes it’s hard to explain the value of something through written word so we filmed Steve to explain our Managed Services. Don’t be shy, contact… Read More »Our Managed Services Video Explanation
Securing SQL Server: Renaming and Disabling the SA Account
The SA (System Administrator) account is a predefined account in SQL Server that has full control over the database server. By default, the SA account… Read More »Securing SQL Server: Renaming and Disabling the SA Account
Common Waits Reported by Daily Monitoring This Month
Each month we report on the most common waits that we see reported by our daily monitoring customers. All the data is sanitized, so there… Read More »Common Waits Reported by Daily Monitoring This Month
Left Outer Join (Left Join)
In SQL, a LEFT OUTER JOIN is a type of JOIN operation that combines data from two tables, based on a JOIN condition. This type… Read More »Left Outer Join (Left Join)
SQL Performance – Finding total elapsed time
One of the key tasks of a database administrator is to ensure that the SQL Server database is running efficiently and effectively. One way to… Read More »SQL Performance – Finding total elapsed time
Renaming a Table in SQL Server
To rename a table in SQL Server, you can use the sp_rename system stored procedure. This stored procedure allows you to change the name of… Read More »Renaming a Table in SQL Server