Do you know how to provide high availability protection for SQL Server without upgrading to Enterprise Edition? Learn how to get robust data protection features for a fraction of the cost of SQL Enterprise Edition with AlwaysOn Availability Groups.
Learn the A to Z process to build an SSIS Package in SQL Server 2016 with Visual Studio 2015. This step by step tutorial will provide you with the history of the technology and tools, Control Flow and Data Flow logic, deployment, performance optimizations
Is Hadoop really that popular? How much time do other DBAs truly spend on security? We joined forces with Unisphere Research and Database Trends and Applications to ask hundreds of DBAs some interesting questions and their answers may surprise you.
In some applications having hard coded SQL statements is not appealing, because of the dynamic nature of the queries being issued against the database server. Because of this sometimes there is a need to dynamically create a SQL statement on the fly and t
Some of our SQL Servers contain tables with summarized data (summarized on a weekly / monthly / quarterly basis). Previously this data was emailed as a flat file attachment to the recipients. I was asked to convert this in such a way that the email itself
The SQL BI team wanted a copy of the live Data Warehouse database to be restored to their DEV SQL Server by replacing the already existing database. There was not enough space for the backup file on the server, so in this tip we show how to use a mapped d