Microsoft has just released AdventureWorks database for SQL Server 2012 RC0. I am very happy that now I will be able to play with this new sample database and base my various demo script around the same. Here is the link to download AdventureWorks 2012 RC0 database.
SQLAuthority News – Microsoft SQL Server ODBC Driver for Linux Available Now
We discussion pretty much everything that DBA do in their daily life. Microsoft SQL Server ODBC Driver for Linux Available Now.
SQLAuthority News – Download Whitepaper 5 Tips for a Smooth SSIS Upgrade to SQL Server 2012
Microsoft SQL Server 2012 Integration Services (SSIS) provides significant improvements in both the developer and administration experience. This article provides tips that can help to make the upgrade to Microsoft SQL Server 2012 Integration Services successful. The tips address editing package configurations and specifically connection strings, converting configurations to parameters,…
Read MoreSQL SERVER – Where Can YOU Get My Books – SQL Server Interview Question and Answers
Earlier month I released by third book SQL Server Interview Question and Answers. The focus of this book is ‘master the basics’. If you rate yourself 10 out of 10 in SQL Server – this book is not for you but if you want to learn fundamentals or want to…
Read MoreSQL SERVER – 2012 RC0 Various Resources and Downloads
Microsoft SQL Server 2012 Release Candidate 0 (RC0) Microsoft SQL Server 2012 RC0 enables a cloud-ready information platform that will help organizations unlock breakthrough insights across the organization. Microsoft SQL Server 2012 Express RC Microsoft SQL Server 2012 Express RC0 is a powerful and reliable free data management system that…
Read More
SQLAuthority News – Various Microsoft SQL Server Documentations Available for Download
Microsoft has recently released various SQL Server related documentation and here I have listed them here for quick reference.
SQL SERVER – Import CSV into Database – Transferring File Content into a Database Table using CSVexpress
One of the most common data integration tasks I run into is a desire to move data from a file into a database table. Generally the user is familiar with his data, the structure of the file, and the database table, but is unfamiliar with data integration tools and therefore…
Read More