Web technologies are moving at a pace that we can hardly keep up in pace. More and more of investments are going on in the space of web that even database developers like me find it interesting. In the same context, recently I was exploring on Skyvia (SQL SERVER – Integrate Your Data with Skyvia – Cloud ETL Solution) from ETL to how one might query and was surprised to see how some of these can be made useful.
SQL SERVER – Antivirus Exclusions Best Practices With SQL Server
One of the classics as far as best practices is concerned is to exclude SQL Server files and folders on your antivirus programs running on the server. We all know this statements and often I see DBAs not adding any extra care to this recommendation. There are not many blogs…
Read More
SQL SERVER – Cloud Based Data Integration Made Easy – A Real World Scenario
If you are a DBA, once in a while, you will have a situation where you end up with some tasks which will be boring and annoying. Trust me in my life, I often come across similar scenarios quite often. Here is one such tasks I came across a few days ago. Let us learn about cloud based data integration.
SQL SERVER – Three Top Efficiency Features of Management Tool for SQL Server
Every weekend I spend time learning something new and interesting. My primary focus is always on either performance of SQL Server or performance of myself. This weekend, I downloaded dbForge Studio for SQL Server. It is a powerful IDE for SQL Server management, administration, development, data reporting and analysis. I have been using SQL Server Management Studio for most of the my tasks and I like sharing tips and tricks with the same. However, there are moments when I wish that SSMS provides me more than what it has been offered to me. There are moments when I feel that I can write up few macros or automated processes to solve a few of my daily routines with SSMS. In simple word, I wish I could customize SSMS a bit more to my own choice. Let us learn about Three Top Efficiency Features of Management Tool for SQL Server.
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?
Few days back my friend called me to know if there is any tool which can be used to get restart notification about SQL in their environment. I told that SQL Server can do it by itself with some configurations. He was happy and surprised to know that he need…
Read More