On vacation without a laptop and a server needs a quick query? Skyvia lets you use the web to query databases right from a browser. Here is how I tried it.
SQL SERVER – Antivirus Exclusions Best Practices With SQL Server
If antivirus locks a SQL Server file, you can face startup issues or even corruption. Here are the antivirus exclusions best practices every DBA should follow.
SQL SERVER – Cloud Based Data Integration Made Easy – A Real World Scenario
Every day at 4 PM I had to load a CSV file into a remote SQL Server. Here is how cloud based data integration took that boring task off my plate.
SQL SERVER – Three Top Efficiency Features of Management Tool for SQL Server
Sometimes I wish SSMS did more. Here are the three top efficiency features of dbForge Studio, a management tool for SQL Server I tried over a weekend.
SQL SERVER – SQL Server Data Compare Tool
This article shows how to use ApexSQL Data Diff, a SQL data compare tool. You can download it here, install, and play along. Let us learn about SQL Server Data Compare Tool.
SQL SERVER – SQL Server Schema Compare Tool
In this article, I’ll show how to use ApexSQL Diff, a SQL Server Schema Compare Tool. You can download it here, install, and play along while reading this blog post.
SQL SERVER – How to Get SQL Server Restart Notification?
Want a restart notification when SQL Server starts, without buying a tool? Here are the steps to run a stored procedure at startup.