Monday, October 28, 2013

Training Course in Honolulu: Introduction to Structured Query Language (SQL)-Starting November 5,2013

If you are interested in this course you can still register.
Please get in touch with Gerald Cerny (gcerny@hawaii.edu)

Details here:
http://hodentek.blogspot.com/2013/08/introduction-to-structured-query.html

Sunday, October 27, 2013

Error on page 27 of my book, 'Learning SQL Server Reporting Services 2012'

Reporting an error on page 27 in my book 'Learning SQL Server Reporting Services 2012', Packt Publishing, ISBN: 978-1-84968-992-2, June 2013.

Despite an editorial process that took over 2 months and atleast 3 revisions, an error like this one can exist in the document. I sincerely apologize for this error on page 27 in my book, after Step.15.

Error type: Images duplicated instead of two separate figures.

Correction:
Remove the figure that is duplicated
Insert the replacement image in its place. 

Details: Instead of the image immediately after 'Step 15', review the replacement image.

I request the readers of this blog to review the following link which shows the steps to configure the service accounts.
http://hodentekmsss.blogspot.com/2013/09/installing-sql-server-2014-ctp1-on.html

Here is the replacement image.



Here is an image of the relevant page taken from the pref-final edition.

 

Sunday, October 20, 2013

SSDT for SQL Server 2014 CTP2

You will get SQL Server 2014 CTP2 Data Tools BI Project templates if you install Microsoft SQL Server 2014 Data Tools BI for Microsoft Visual Studio 2012, CTP2. Note that this does not work with Microsoft SQL Server 2012. It is supported only on x64 architecture of Windows Servers 2208 R2 and 2012 but on both X32 and X64 for Windows 7 and Windows 8.

Download link here
http://www.microsoft.com/en-us/download/details.aspx?id=40736

This is the file that is installed and is strictly to support CTP2 only:
SSDTBI_VS2012_x86_ENU.exe(537.1 MB), Version:12.0.15240 Published date:10/14/2013

This installs the Microsoft SQL Server 2014 CTP2 Data Tools Business Intelligence project templates for Analysis Services, Integration Services, and Reporting Services.

Make sure you have these on the computer as prerequisites:
•Microsoft .NET Framework 4.5
•Microsoft Visual Studio 2012 Shell (Isolated) Redistributable Package
•Microsoft Visual Studio 2012 Shell (Integrated) Redistributable Package
•Microsoft Visual Studio Tools for Applications 2012
•Microsoft Report Viewer 2012 Runtime

Details of December 2012 update here.

SSDT 2012 news here.

 

Thursday, October 17, 2013

You want to back up your prior version SQL Server data to Windows Azure ? No Problem!

SQL Server 2012 supported backing up database to Windows Azure . Of course higher versions will also be capable and in fact SQL Server 2014 will also do so more easily. What if you wanted to backup your SQL Server 2005, SQL Server 2008, SQL Server 2008R2 to the Cloud. Well, a new 3 step tool released by Microsoft can do it, no problem(it appears). The tool supports backup compression and encryption to boot.

Access tool download link here:
http://www.microsoft.com/en-us/download/details.aspx?id=40740



For prior versions of SQL Server, the Tool provides (from Microsoft site):
  • Easy integration with Windows Azure Blob Storage.
  • Off-site SQL Server backups, accessible from anywhere.
  • Encryption and compression for cloud and on-premises SQL Server backups.
  • SQL Server Backup/restore with Windows Azure Blob Storage Service
  • Backup/Restore feature details here:

    http://msdn.microsoft.com/en-us/library/jj919148(v=sql.120).aspx

    Wednesday, October 16, 2013

    SQL Server 2014 CTP2 is out, get it fast.

    It is available for immediate download.

    Don't click on the start to get evaluation! It won't take you to SQL Server 2014 CTP2.

    Access the main link here:
    http://www.microsoft.com/en-us/sqlserver/sql-server-2014.aspx

    New capabilities :
    Promises new in-memory capabilities
    Promises new cloud capabilities

    Here is a cutout from product documentation.


    Want to check it out, download from here:
    http://www.microsoft.com/en-us/download/details.aspx?id=39269
    The installation should follow the same steps as in installing SQL Server 2014 CTP1.

    Get full screen shots here.
    http://hodentekmsss.blogspot.com/2013/09/installing-sql-server-2014-ctp1-on.html

    Complete product guide here:
    http://www.microsoft.com/en-us/download/details.aspx?id=39269

    Mahalo,
    Jay