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 Authority News – I am Participating in Winter Discounts and Christmas Photo Fest
I am taking part in Devart’s winter discounts and Christmas photo fest. Here is why dbForge Studio for SQL Server is my favorite of their tools.
SQL SERVER – Story of Temporary Objects
Temp tables, table variables and more: the story of Temporary Objects in SQL Server, why you would use them and how they can help performance and scalability.
SQL SERVER – Beginning with SQL Server Security Aspects
A high-level overview of SQL Server security aspects and best practices, starting with the often overlooked physical security of the server itself.
SQL SERVER – Beginning Reading Transaction Log File
What is the SQL Server transaction log, why do we need it and how does it work? A beginner’s first step toward reading transaction log file content.
SQL SERVER – A Practical Use of Backup Encryption
A backup in the wrong hands is a data leak waiting to happen. Here is a practical example of Backup Encryption in SQL Server 2014 to keep your backups safe.
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.