Thursday, February 11, 2016

Attaching AdventureWorks2012 database to a SQL Server Instance


Sample database files are great if you are interested in learning the basics of SQL Servers and SQL Querying.

After installing the SQL Server the first thing you may have to do is bring in some data. Microsoft has provided lots of samples and AdventureWorks is one such database of a hypothetical company and it is bigger than the Northwind database of a hypothetical company.

Here is a Swaytorial that helps you to bring in data to your server. Enjoy!



Tuesday, February 9, 2016

A tutorial on creating script using SQL Server Management Studio

Creating script is an important skill that you should learn. As there are so many versions of SQL Server not to mention those on Microsoft Azure Cloud platform, you should know for which version you are writing the script. You can change this in Tools | Options and look for scripting node.

This presentation is created using Microsoft's latest presentation program SWAY. This is my first shot at SWAY. The presentation may not be smooth. Would you kindly comment? Thanks




Thursday, February 4, 2016

Problem with SQL Server 2014 Report Builder 3 and the fix

This problem surfaced while installing SQL Server 2104 Report Builder on a Windows 10 (x64) Pro machine which has a SQL Server 2014 (x64) Developer Edition installed and a properly configured Report Server.

The Report Builder software was downloaded from this Microsoft Site:
https://www.microsoft.com/en-us/download/details.aspx?id=42301


ReportBuilder_01

Double clicking the downloaded MSI file above started the installation. The program looks for a target report server and it was provided as shown:


ReportBuilder_02

The Report Server and the Report Manager both do not have any problem. However this ends up with an unsuccesful installation with this message:


ReportBuilder_03

The work around for this is to not provide a target report server and ccontinue with the installation. The installation succeeds this time. After a little while an gets added to the All Icons group as shown.


ReportBuilder_04