Month: June 2023

dba at a small to medium size business

4 Ways to Better Manage SQL Server Without a DBA

Microsoft SQL Server is popular. Statistics vary as to just how popular, but most agree that it is one of the most popular database platforms in the world. And for good reason. It’s feature rich, very reliable, highly scalable, and can be made extremely secure. All good things. According to a 2022 survey conducted by…
Read more

SQL Server FAQ

What’s the Difference in Index Defrag and Rebuild?

If you’ve worked with SQL Server for very long, you’re probably familiar with the concept of indexes. Indexes can help speed up queries by allowing SQL Server to quickly locate specific data values within a table. Indexes are typically much smaller than their underlying tables so they can be searched much more efficiently. (They aren’t…
Read more