Showing posts with label SQL Server 2012. Show all posts
Showing posts with label SQL Server 2012. Show all posts

Monday, July 17, 2017

Backing up legacy database to SQL Server 2012 (x86) using SSMS 17.1

SQL Server Management Studio 17.1 does well in backing up a Northwind database to a SQL Server 2012 Express (x32bit) on Windows 10 OS.

A backup of Northwind database was obtained from the Codeplex site and was saved to one of the folders on a Dell computer with Windows 10 OS. The computer also has SQL Server Management Studio (v 17.1). You should be able to restore using the SQL Server Management Studio installed when you installed the SQL Server 2012 Database engine.

Follow these steps to restore the Northwind database to an instance of SQL Server 2012 (x86) installed on the same computer.

Step 1. Start SQL Server Management Studio v17.1 (Run as administrator)

The SSMS is version 17.1 and Hodentek9\PCATT is a SQL Server 2012 Express

Step 2. Right click the Databases node highlighted in the PCATT isntnace as shown.




RestoreDB_01

Step 3: Click Restore Database...

Restore Database window is displayed as shown.


RestoreDB_02

Step 4: The Default Source is Database and it is greyed out as shown. Chnage it to Device. The Restore Database gets changed as shown.


RestoreDB_03

Step 5: Click the ellipsis button along 'Device' in the above image.

Select backup devices window shows on top of Restore Database window as shown.


RestoreDB_04

Step 6: Click Add button in Select backup devices window.
Locate Backup File window gets displayed as shown.


RestoreDB_05

Usually the 'backup files with extension .bak' are found in the following directory in the case of x32 bit SQL Server.
C:\Program Files (x86)\Microsoft SQL Server\MSSQL11.PCATT\MSSQL\Backup

However, for this exercise it is stored in a different location.

Step 7: Now browse to that location and highlight the Northwind.bak (A backup file which came from a Microsoft site) as shown.


RestoreDB_06

Step 8: Click OK. The file path is entered in the Select backup devices window as shown.


RestoreDB_07.png

Step 9: Click OK
You are returned to the Restore Database - Northwind as shown.


RestoreDB_08.png

Step 10: Click OK in the above.

Microsoft SQL Server Managment Studio message reports that the database
'Northwind' restored successfully.


RestoreDB_09.png

Step 11: Click OK to the message. Verify that Northwind database is in the SQL Server 2012 instance Hodentek9\PCATT


RestoreDB_10.png


Bye





Wednesday, March 09, 2016

Hands-on Learning Event in Honolulu 1 : Introduction to Structured Query Language

The above course will be offered again (April 14-May 17, 2016) as a non-credit course by the Pacific Center for Advanced Technology Training.


Course summary:

Databases, organized repositories of information, have become indispensable and in fact even more relevant despite the emergence of Big Data in today's world.

In this introductory course you will learn about relational databases and the basics of Structured Query Language (SQL) including sorting; grouping result sets; using DDL, DML, DCL, and TCL. All SQL statements will initially be written for one table. Most practical, modern and relational databases will include a large number of tables and SQL queries have to access information from several tables. This course will then introduce you to querying more than one table. With this skill you will be able to query two or more tables in a database. This is a hands-on course which will take you from installing SQL Server 2012; learning the ins and outs of SQL Server Management Studio and of course a full dose of SQL.

During each meeting the students will be assessed for their knowledge, competency and proficiency in SQL.

New this session:
SQL Azure Database: SQL Server in Microsoft Cloud
Windows PowerShell for SQL Server

My sincere thanks and best wishes to the January batch of students.


Monday, November 23, 2015

End of support for SQL Server 2005

It is sunset time for SQL Server 2005 as it reaches end of life  (EOL). While EOL may be an extreme word to use, it is going to be End of Support (EOS) by Microsoft beginning April 2016.
SQL Server 2005 was the beginning of a new era for SQL Servers and according to information available on the Internet, SQL Server 2005 is still used extensively tied up with Windows Server 2003.
There are a couple of upgrade options and probably most go for either SQL Server 2012 or SQL Server 2014. Perhaps it may be better to go the whole 9 yards and get SQL Server 2016 which is in CTP right now.

The good news (for me) is that SQL Server 2005 will continue to stay for few more years and I can still sell my book.


https://www.packtpub.com/networking-and-servers/beginners-guide-sql-server-integration-services-using-visual-studio-2005

Sunday, November 22, 2015

HeidiSQL is a very useful Open Source client to SQL Server

It is nice to have access to SQL Server from an Open Source program and HeidiSQL nicely comes in handy. It is free and Open Source. HeidiSQL can handle a surprisingly large number of tasks. Review this list:
•Connect to multiple servers in one window
•Connect to servers via command-line
•Connect via SSH tunnel, or pass SSL settings
•Create and edit tables, views, stored routines, triggers and scheduled events.
•Generate nice SQL-exports, compress these afterwards, or put them on the clipboard.
•Export from one server/database directly to another server/database
•Manage user-privileges
•Import text-files
•Export table rows as CSV, HTML, XML, SQL, LaTeX, Wiki Markup and PHP Array
•Browse and edit table-data using a comfortable grid
•Bulk edit tables (move to db, change engine, collation etc.)
•Batch-insert ASCII or binary files into tables
•Write queries with customizable syntax-highlighting and code-completion
•Pretty reformat disordered SQL
•Monitor and kill client-processes
•Find specific text in all tables of all databases of one server
•Optimize and repair tables in a batch manner
•Launch a parallel mysql.exe command line window using your current connection settings

In addition to Microsoft SQL Server you can also connect to PostgreSQL and MySQL. From the list above it can be seen that HeidiSQL can do things that SQL Server Management Studio cannot.

HeidiSQL may be downloaded from here by using any of the options.

Downloading and Installation is described ( from an installer) here in detail.

Connecting to SQL Server 2012 using HeidiSQL is described here.

Here is a named instance of SQL Server 2012 accessed on HeidiSQL.



Sunday, November 01, 2015

Data-tier application with SQL Server 2012

Data-tier application in SQL Server defines the schema and objects that are required to support an application.It is really very simple.

There are two ways you can implement a DAC:
  • Using Microsoft Visual Studio 2010 with a SQL Server Data-tier application project type
  • Using the extraction utility in SQL Server's Extract Data-tier wizard.
In Microsoft Visual Studio 2015 Community there are no templates to do this although you can import one, if it exists in the community samples.

Here is how you extract using the SQL Server Management Studio in SQL Server 2012.

Connect to SQL Server on your computer. Here is the Object Explorer of a named instance of SQL Server 2012.

Dac_01

We now create a DAC using the Northwind database.
Right click Northwind to open the menu and the sub-menu as shown.


Dac_02

Click on Extract Data-Tier Application... to display the Introduction screen of the Wizard.

Dac_03

The above screen pretty well describes the actions we take. It has the three steps:
  • Set the DAC properties
  • Review object dependency and validation results
  • Build the DAC Package
Click Next to display the Set Properties page of the wizard. when you choose the databse the application name gets the database name by default and if it iss the first time the version is also set.


Dac_04

It appears that I have already created a file with that name and I will extract another with a different name NrthWnd.

Dac_05

Click Next. Displays the validation and summary page of the wizard.

Dac_07

Click Next. after a bit of creating and saving animation the process either succeeds or fails.

Dac_08

Click finish (after you get to see the Success of the operationb)  and the DAC  page is saved to the location indicated.

Dac_09

DAC files can be unpacked with programs shown.

 Dac_10


Monday, May 11, 2015

Tips and trick to format SQL Reponse in JSON format using DocumentDB

 Recently Microsoft made it easy to migrate data form certain sources to DocumentDB on Microsoft Azure. Review post here.

The following source data can be migrated to DocumentDB using the migration tool:
  • CSV file or files
  • JSON file or files
  • SQL
  • MongoDB
  • DocumentDB

  • This post shows how you may obtain response to your SQL query in JSON format using the migration tool.

    You start with a SQL query that can be run on the instance of SQL Server 2012 (in this case). Make sure of your instance name and that you have permissions to run the query on the objects you want to use.

    You need to download the migration tool described in the link above and launch it. The tool requires input information from the source,
    Connection information and either a query file or the query itself. For some unknown reason using the query file failed, but providing a query did succeed.

    Here is the query and the location of JSON response as entered on the migration tool:

     
    Here is the JSON formatted response from the migration tool:
     
     
     

    Sunday, February 22, 2015

    BI projects in SQL Server Data Tools

    SQL Server  Data Tools(SSDT) installs when you install SQL Server 2012 (even the SQL Server 2012 Express edition). SSDT has all the necessary project templates to start a Business Intelligence project. However it will not have the templates for other language projects such as C#, VB.NET etc.

    SSDT allows you to create all the Business Intelligence related projects by providing templates for the projects. You can also create SQL Server projects as shown here:


    ssisProj03
    Here is an example of creating a SQL Server Integration Services project using the Visual Studio Shell launched by SSDT that gets installed with the SQL Server.

    http://hodentekmsss.blogspot.com/2015/02/sql-server-data-toolsssdt-installs-when.html

    More posts on SSDT here:
    http://hodentek.blogspot.com/2013/10/ssdt-bi-templates-for-sql-server-2012.html

    http://hodentek.blogspot.com/2014/07/new-update-to-sql-server-data-tools.html

    http://hodentek.blogspot.com/2014/03/sql-server-data-tools-to-go-with-sql.html

    Monday, November 10, 2014

    Using SQL Server with PHP 5.5

    PHP is adopted worldwide and Microsoft has been providing hooks in the past  so that PHP applications can access SQL Server data. Extending connectivity to SQL Database on Microsoft Azure need no explanation.

    SQL Server driver (SQLServer31.exe, 499KB, version 3.1.CTP) for PHP is now available as a CTP. Now PHP scripts can access Microsoft SQL Server and Microsoft Azure SQL Database.

    You can download the CTP here:
    http://www.microsoft.com/en-us/download/details.aspx?id=20098&WT.mc_id=Blog_SQL_Announce_DI

    Details of this version:

    This version
    • Supports PHP Version 5.5 and requires Microsoft ODBC driver 11 (or higher)
    • It supports SQL Server 2012; LocalDB and AlwaysOn features
    • Buffered Queries are included
    All SQL Server user can get it at no extra cost.
    This widens the interoperability range.

    The soon to be released JDBC driver compatible with JDK7 for SQL Server will enable applications to connect to SQL Server widening connectivity with Java Platform.

    I have covered in detail how to use PHP applications (PHP versions 5.2.4 or later) to access data on Microsoft Azure SQL Databases (formerly called  Microsoft SQL Azure) using PHP Data Objects. Details are on pages 369-373, Chapter 10 in my 2010 book here:

     
    You can buy or join the library here:

     

    Tuesday, March 18, 2014

    SQL Server 2014 goes RTM

    SQL Server 2014 RTM, billed as 'Microsoft Cloud First Platform' will be RTM on April 1, 2014
    The main feature is the in-memory OLTP processing which will turbo- charge transaction processing making it as much as 30 times faster. In order to use this feature you need memroy-optimized databases and tables declared as memory optimized. These memory-optimized tables are stored in file groups.

    In-memory transaction processing appears to be not new, but peer pressure from products already in the market makes it important to highlight this feature in this offering as it is fully integrated with the present version.

    The other prominent feature is the enhancements to Microsoft Azure in particular the enhancements leading to integration between on premises and cloud based environments. SQL Server 2014 instances can be backed up to Windows Azure Storage which can then be deployed as Windows Azure VM by just invoking a wizard. This  can then be designated as a high availability node for SQL Server 2014.

    Of course to reap all this benefit you need to purchase SQL Server 2014. I know people using SQL Server 2000 even now, I assume it is still supported.

    For more information read these articles:
    http://www.infoworld.com/t/dbms/sql-server-2014-supercharged-in-memory-tables-azure-connectivity-238639?source=IFWNLE_nlt_daily_pm_2014-03-18

    http://www.zdnet.com/microsofts-sql-server-2014-crowns-redmonds-data-platform-7000027444/

    Friday, January 31, 2014

    Thursday, December 26, 2013

    Can you deploy a Data-tier component extracted from SQL Server 2014 CTP1 to SQL Server 2012?

    This should not be possible according to documentation here  and quoted below unless the DAC Framework version are the same.

    'A DAC package or export file built with one version of the DAC Framework cannot be processed by an earlier version of the DAC Framework. For example, a DAC package extracted using the SQL Server 2012 client tools cannot be deployed using the SQL Server 2008 R2 client tools.'

    This post is about a little experiment to test the validity of the above statement. In an earlier post in HodentekMSSS.blogspot.com here a .dac extracted from SQL Server 2012 was deployed to CTP1:

    http://hodentekmsss.blogspot.com/2013/12/deploying-dac-to-sql-server-2014.html

    The above post was about a DAC package extracted from SQL Server 2012 Express on Windows 7 Platform (x64) and deployed to SQL Server 2014 CTP1 on Windows 8 Preview platform.

    In this post the database created using the above procedure was extracted and deployed back to SQL Server 2012 Express on the other partition. This was also successful in violation of the previously quoted procedure.

    The reason was the DAC Framework versions were found to be the same on both servers using the DacUnpack utility.

    The DacUnpack utility unpacks the .dac files. Here are the two files opened in Safari browser.

    Northwind.dacpack's Origin.xml


    3.0.0.0 false 2.0.0.0 1.0.0.0 4e266c18-42ec-4e0c-b3ce-5894ab3f1cd1 2013-12-09T15:29:51.5237832-10:00 0001-01-01T00:00:00.0000000 Microsoft.SqlServer.Dac, Version=10.3.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a 11.0.2902.0 http://schemas.microsoft.com/sqlserver/dac/Serialization/2012/02 

    Microsoft SQL Server 2012 - 11.0.2218.0 (X64) Jun 12 2012 13:05:25 Copyright (c) Microsoft Corporation Express Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1) 

    8 103 1 9 13 27 1 1 13 91 100 11 1 19


     16 
     
    C3CCC630725BF4F1785C54AEC314B1D687A323EDAD15DA1235BA5CFD6FC5865A
     

    NorthwindCTP1.dacpack's Origin.xml (obtained after unpacking)

    3.0.0.0 false 2.0.0.0 c1c8859f-2548-4873-a550-b322e63d5ef4 2013-12-26T10:09:30.4691845-10:00 0001-01-01T00:00:00.0000000 Microsoft.SqlServer.Dac, Version=10.3.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a 10.3.0.0 http://schemas.microsoft.com/sqlserver/dac/Serialization/2012/02 
    Microsoft SQL Server 2014 (CTP1) - 11.0.9120.5 (X64) Jun 10 2013 20:09:10 Copyright (c) Microsoft Corporation Enterprise Evaluation Edition (64-bit) on Windows NT 6.2 <X64> (Build 9200: ) (Hypervisor) 
    8 103 1 9 13 27 1 1 13 9 1 100 111 19
     16 
     
    87A4AC4BF297030FAFDEA917D02EF357DFDC8F92CED835DA64DF47683B851272


     

    Sunday, October 20, 2013

    SSDT BI templates for SQL Server 2012 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 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
    For more support information follow this link here.

    Sunday, August 25, 2013

    Connecting to SQL Server 2012 from OpenOffice 4.0 is a walk in the park

    It just takes 4 easy steps as you will see presently.

    It's assumed that you have set up an ODBC DSN to connect to SQL Server 2012. If you want to know how you can set up this file access the following link:

    http://hodentekmsss.blogspot.com/2013/08/how-do-you-create-odbc-dsn-to-sql.html

    Click open OpenOffice 4.0 from its shortcut on desktop to display the following:


    Click on Database in the displayed list.

    The Database wizard is displayed as shown with four steps and it is already in Step 1 -Select Database.


    Click Connect to an existing database and click the drop-down list to view how you want to connect.

    Choose the last one, ODBC. Click Next. You Step into step 2 - Set up an ODBC Connection.

    The accessible ODBC sources are displayed as shown.



    Click on sql11 and Click OK. Click Next. You move into Step 3 - Set up user authentication. Enter credentials to the SQL Server. The windows authentication is used.



    Place check mark for Password required. Click Test Connection.



    Enter Password field and click OK. You should see a positive response as shown.




    Click OK and click Next to move to Step 4 - Save and proceed as shown.



    Read instructions. Save the OpenOffice database with a name as shown, Aug 25.odf.

    The file opens in the OpenOffice 4.0 user interface as shown.


    Now you can start working with Northwind database in OpenOffice 4.0

    Perhaps, if you find connecting to SQL Server 2012 using SSMS is a bit taxing and somewhat intimidating try Apache OpenOffice 4.0. 


    Tuesday, July 02, 2013

    How do you add a database connection to Server Explorer in VS 2012?

    Report authoring is perhaps one of the most frequently required activities in an enterprise. Knowledge of report authoring is an invaluable asset when one is looking for a job in an enterprise. Before you can write a report you will have to know where your data is and how to get connected to it from your authoring software. Report authors who are not very comfortable with using data on a back end server could use the more powerful and highly interactive Power View reports, but this requires a developer in your organization to create a model for you to work with. Once the model in place it is super easy to create stunning reports. This is only possible on SQL Server 2012 with the reporting services installed in SharePoint integrated mode.

    The following is specific to SQL Server Reporting Services, but this is important for any authoring tool. In the following Visual Studio 2012 is presumed and a web project is to be created to demonstrate the use of Report Viewer Control.

    Presently the Server Explorer has the following items:

     


    If you do not see Server Explorer you click View in the main menu and click Server Explorer as shown:


    Presently there is a connection established with the Adventure Works 2012 database on the SQL Server 2012 named Kailua.

    Click Connect to Server item on Server Explorer tool bar shown.



    The Add Server window is displayed as shown.


    The name of the computer is provided (you provide the name of your computer). Click OK.

    Adding a Data Connection

    Click Connect to Database toolbar item as shown.



    Or you can right click Data Connection and start as well.

    Assume that we clicked Connect to Database.

    The Add Connection window is displayed as shown.



    This is because before getting to the database you must first get connected to the server. Notice that the Microsoft SQL Server (SqlClient) is the default. It can be changed to others by hitting the Change... ellipsis button and following the wizard.

    For now accept the default. Click on the handle for Server Name after hitting the Refresh button. You see three servers, a SQL Server 2012 (Kailua); a SQL Server 2008 R2 (Maui) and a SharePoint Server.



    Click HODENTEKWIN7\KAILUA to choose the server. The Add Connection window is updated as shown. We accept the default authentication, Windows Authentication.


    Click on the handle for the Select or enter a name for the database field to display the drop-down list as shown.

    Click Northwind. It could be another database in your case. Click the Test Connection button and verify that the connection was successful as shown.



    Click OK on the above message window and click OK on the Add Connection window. The new database connection will be added to the Visual Studio 2012’s Server Explorer as shown.


    That is all for now.

    Mahalo

    My new book uses images / screenshots such as the above to guide you through the learning process. The instructions are very simple and most of the steps are described.








    Tuesday, June 18, 2013

    Hyperlinks referenced in my new book


    My new book on SQL Server Reporting Services 2012 is about to be released and this post provides a list of links referenced in the book, sorted chapter wise.



    Hyperlinks provide a gateway to the extensive literature that can be accessed on the Internet. They provide information (collective knowledgebase) above and beyond what one finds in a single article,book,blog or other media formats. However links in a printed book are useful to only those readers who would go to any lengths to find information but irksome, frustrating and almost useless to the others. They are of course useful in online formats such as eBooks.

    In order to conform to page count limit set by the publishers (as you might have noticed computer books have become heftier and heftier) and yet provide guidance to the readers there is no better way than publishing a list of links that is chapter-wise sorted and placed in a location that is easy to access. This post is an attempt to do just that. However some essential information from Microsoft Documentation is used as is in the book in some of the chapters.

    Chapter 1: Overview and Installation – SQL Server Reporting Services 2012

    Operating System Requirements
    http://msdn.microsoft.com/en-us/library/ms144275.aspx.

    Software requirements (Power Shell)
    http://msdn.microsoft.com/en-us/library/ff637750(v=azure.10).aspx

    Finding processor cores of the computer
    http://hodentekhelp.blogspot.com/2013/01/how-do-i-find-number-of-cores-in.html

    Download link for SQL Server2012 Enterprise Evaluation x64 bit
    http://www.microsoft.com/en-us/download/details.aspx?id=29066

    Options for SharePoint Integration
    http://technet.microsoft.com/en-us/library/hh213532.aspx

    Distributed replay controller
    http://msdn.microsoft.com/en-us/library/ff878183(v=SQL.110).aspx

    Configuring reporting services 2012
    http://msdn.microsoft.com/en-us/library/cc281311.aspx

    SQL Server 2012 Security related link
    http://msdn.microsoft.com/en-us/library/ms144228.aspx

    Setting up IE browser to start with Administrator Privileges
    http://hodentekhelp.blogspot.com/2013/01/how-to-start-ie-browser-with.html

    SQL Server 2000 database files
     http://www.microsoft.com/en-us/download/details.aspx?id=23654

    Attaching and detaching databases
    http://msftdbprodsamples.codeplex.com/workitem/19203

    Attaching/Detaching step-by-step
    http://hodentek.blogspot.com/search?q=Sample+databases

    Running script files, step-by-step
    http://hodentekmsss.blogspot.com/2013/01/how-do-i-install-sample-database-using.html

    Choosing SharePoint Server for SQL Server 2012 Integration
    http://technet.microsoft.com/en-us/library/dc6a3372-db26-43f0-b7aa-f725acc635c2

    Installing SharePoint 2010 on Windows 7(x64)
    http://msdn.microsoft.com/en-us/library/ee554869(office.14).aspx

    SharePoint 2010 hardware and software requirements
    http://technet.microsoft.com/en-us/library/cc288751(v=office.14).aspx

    Download link SharePoint2010 Trial
    http://www.microsoft.com/en-us/download/details.aspx?id=16631

    Installing Microsoft Sync Frame work 1.0(x64)
    http://go.microsoft.com/fwlink/?LinkID=141237

    Get Microsoft SQL Server 2008 Native Client MSI
    http://go.microsoft.com/fwlink/?LinkId=123718

    Download and Install Windows 6.1-KB974405-x64.msu
    http://www.microsoft.com/en-us/download/details.aspx?id=17331

    Get Microsoft Chart Controls for Microsoft .NET Framework 3.5 (KB2500170).
    http://support.microsoft.com/kb/2500170

    SharePoint2010 and SQL Server 2012 choice
    http://msdn.microsoft.com/en-us/library/dc6a3372-db26-43f0-b7aa-f725acc635c2

    Reporting Services 2012 Add-in for SharePoint 2010
    http://www.microsoft.com/en-us/download/details.aspx?id=29068

    Making changes to application pool identity
    http://hodentekhelp.blogspot.com/2013/04/how-do-you-make-changes-to-application.html

    Chapter 2: SQL Server Reporting Services 2012 Projects with Visual Studio 2012

    SSDT and SQL Server 2012
    http://msdn.microsoft.com/en-us/library/hh272686(v=vs.103).aspx

    SSDT first time problems
    http://www.sqlservercentral.com/blogs/jamesserra/2012/04/13/ssdt-installation-confusion/print/

    http://blogs.msdn.com/b/ssdt/archive/2012/06/06/getting-started-with-localdb-debugging-using-ssdt.aspx?CommentPosted=true#commentmessage

    SSDT and SSRS 2012
    http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/1f005f31-82a6-4e1c-b221-cb2c798c4caa

    SSDT December 2012 update
    hodentekmsss.blogspot.com/2012/12/december-update-to-ssdt.html
    http://msdn.microsoft.com/en-us/data/hh297027

    Report Designer
    http://technet.microsoft.com/en-us/library/ms173745.aspx

    Problem with report preview in VS Designer
    http://social.technet.microsoft.com/Forums/en-US/sqlreportingservices/thread/41d46c69-5a18-4915-8b5e-fc3c19da8db9

    http://social.technet.microsoft.com/Forums/en-US/sqlreportingservices/thread/38ff8d54-06aa-40c3-8916-378d5185320e

    First edition
    Learning SQL Server Reporting Services 2008, ISBN: 9781847196187, Packt Publishing, 2009
    Export problem to MS Access
    http://connect.microsoft.com/SQLServer/feedback/details/735375/business-intelligence-bids-ssdt-missing-referenced-assembly

    Visual Studio 2012 Ultimate download site
    http://www.microsoft.com/visualstudio/eng/downloads

    Report Viewer Controls
    http://msdn.microsoft.com/en-us/library/ms251671.aspx

    Visual Studio 2010 download site
    http://www.microsoft.com/en-us/download/details.aspx?id=12187

    Detailed description of Report Builder 2.0
    http://dotnet.sys-con.com/node/982742   Part 1

    http://jayaramkrishnaswamy.sys-con.com/node/1227111  Part 2

    RDL and RDLC Schemas
    http://msdn.microsoft.com/en-us/library/ms252109.aspx

    Report Viewer Runtime 2008 version
    http://www.microsoft.com/en-us/download/details.aspx?id=6576

    Report Viewer Runtime 2010 package
    http://www.microsoft.com/en-us/download/details.aspx?id=6442

    Report Viewer Runtime 2010 SP1
    http://www.microsoft.com/en-us/download/details.aspx?id=6610

    Report Viewer Runtime 2012
    http://www.microsoft.com/en-us/download/details.aspx?id=35747

    Chapter 3: Overview of SQL Server Reporting Services 2012 Architecture, Features, and Tools

    Major Components of Native Mode installation
    http://msdn.microsoft.com/en-us/library/ms157231.aspx

    SharePoint Standalone Deployment for SQL Server 2012 Integration
    http://msdn.microsoft.com/en-us/library/bb510781(v=sql.105).aspx

    Reporting Services 2012 Configuration details
    http://msdn.microsoft.com/en-us/library/ms155866.aspx

    Regarding Report Parts and their usage
    http://msdn.microsoft.com/en-us/library/ee635721.aspx

    ESRI Shape Files
    http://www.esri.com/library/whitepapers/pdfs/shapefile.pdf

    Regarding Report scheduling
    http://go.microsoft.com/fwlink/?linkid=232473

    Creating, modifying and deleting Schedules
    http://msdn.microsoft.com/en-us/library/ms155897.aspx

    Power View Features
    http://office.microsoft.com/en-us/excel-help/power-view-explore-visualize-and-present-your-data-HA102835634.aspx

    Authentication – Report Servers
    http://msdn.microsoft.com/en-us/library/bb283249.aspx

    URL access parameters
    http://msdn.microsoft.com/en-us/library/1c3e680a-83ea-4979-8e79-fa2337ae12a3

    Reporting Services Default Extensions
    http://msdn.microsoft.com/en-us/library/ms157231.aspx

    Security, Data Processing, Rendering, Report Processing and Delivery Extensions
    http://msdn.microsoft.com/en-us/library/hh213576.aspx


    Chapter 4: Working with Report Manager

    Report Manager 2012 - Overview
    http://msdn.microsoft.com/en-us/library/ms157147.aspx

    Configure a Report Server for Local Administration on Windows Vista and Windows Server 2008
    http://msdn.microsoft.com/en-us/library/bb630430.aspx

    Tasks and permissions on Native mode report server
    http://msdn.microsoft.com/en-us/library/ms159840.aspx

    Launch error from while launching Report Builder from Report Manager
    http://social.msdn.microsoft.com/Forums/enUS/sqlreportingservices/thread/ec0a6b15-1816-4d6c-87c0-b2f1f28f3d04

    Report Manager Site Settings
    http://msdn.microsoft.com/en-us/library/ms181194.aspx

    Report Manager F1 Help
    http://msdn.microsoft.com/en-us/library/ms189690.aspx

    System Role assignments (New/Edit)
    http://msdn.microsoft.com/en-us/library/ms186541.aspx

    Clickthrough Reports (SSRS)
    http://technet.microsoft.com/en-us/library/ms345252.aspx

    Exporting Reports (Report Builder and SSRS)
    http://msdn.microsoft.com/en-us/library/dd239307.aspx

    Caching Reports (SSRS)
    http://msdn.microsoft.com/en-us/library/ms155927.aspx

    Chapter 5: Working with Report Manager
    Learning SQL Server 2008 Reporting Services, Jayaram Krishnaswamy, Packt publishing, ISBN: 9781847196187, 1st Edition, March 2009
    http://www.packtpub.com/learning-sql-server-2008-reporting-services/book/mid/010409ofvkyp

    Chapter 5: Working with Report Builder 3.0

    Report Builder: ENU\x86\ReportBuilder3.msi (24.8 MB) file download link
    http://www.microsoft.com/en-us/download/details.aspx?id=29072

    Report Builder 2.0 Interface description
    http://dotnet.sys-con.com/node/982742   Part 1

    Authoring Reports with Report Builder 2
    http://jayaramkrishnaswamy.sys-con.com/node/1227111 Part 2

    Data source properties - credentials
    http://msdn.microsoft.com/en-us/library/ms178308.aspx

    Chapter 7: Report Authoring with Report Builder 2.0
    Learning SQL Server 2008 Reporting Services, Jayaram Krishnaswamy, Packt publishing, ISBN: 9781847196187, 1st Edition, March 2009
    Report Parts in Report Designer (SSRS)
    http://technet.microsoft.com/en-us/library/ee635721.aspx

    Chapter 6: Power View and Reporting Services

    Business Intelligence Semantic Model
    http://blogs.msdn.com/b/analysisservices/archive/2012/03/09/xvelocity-and-analysis-services.aspx

    What’s new in Power View
    http://office.microsoft.com/en-us/excel-help/whats-new-in-power-view-in-excel-2013-and-in-sharepoint-server-HA102901475.aspx

    Comparison of Multidimensional and Tabular Model
    http://www.jamesserra.com/archive/2012/04/sql-server-2012-multidimensional-vs-tabular/

    Overview of Power View
    http://social.technet.microsoft.com/wiki/contents/articles/3726.power-view-overview.aspx#Useful_links_for_Project_Crescent_and_SQL_Server_Denali

    Power View Visualization
    http://office.microsoft.com/en-us/excel-help/power-view-explore-visualize-and-present-your-data-HA102835634.aspx

    Practicing Power View online
    http://blogs.msdn.com/b/oneclickbi/archive/2011/12/27/more-demos-of-power-view-available.aspx

    News about Windows Azure HDInsight; and Power View/Power Pivot
    http://redmondmag.com/blogs/the-schwartz-report/2013/03/big-data-fray.aspx

    Tabular Model and default field set
    http://msdn.microsoft.com/en-us/library/hh479569.aspx

    Measures: Tabular Data Model
    http://msdn.microsoft.com/en-us/library/hh230824.aspx

    Power View with Multidimensional model
    http://blogs.msdn.com/b/analysisservices/archive/2012/11/29/power-view-for-multidimensional-models-preview.aspx

    Chapter 7: Self-service Data Alerts in SSRS 2012

    Data Alerts details
    http://msdn.microsoft.com/en-us/library/gg492252.aspx

    Setting up content types in SharePoint site
    http://msdn.microsoft.com/en-us/library/bb326289.aspx

    SharePoint Integrated Reporting Services proxy site
    http://msdn.microsoft.com/en-us/library/gg492284.aspxhttp://msdn.microsoft.com/en-us/library/gg492284.aspx

    About alert Rules and Alert Scheduling
    http://technet.microsoft.com/en-us/library/gg492254.aspx

    Chapter 8: Reporting Services and Programming

    URL Access
    http://msdn.microsoft.com/en-us/library/1c3e680a-83ea-4979-8e79-fa2337ae12a3

    Deprecated prefixes (DSU and DSP) in SQL Server Reporting Services 2012
    http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/72f83019-9d2b-4ede-a526-e096a0cabc5b/

    URL Access syntax for SharePoint Integrated Reporting Services server
    http://msdn.microsoft.com/en-us/library/ms153586.aspx

    Report Viewer: CodePlex Site link
    http://reportviewer.codeplex.com/

    Stream callback and Report Viewer
    http://msdn.microsoft.com/en-us/library/microsoft.reporting.winforms.createstreamcallback.aspx

    Report Server Web Services Management Endpoints
    http://msdn.microsoft.com/en-us/library/ms155398.aspx

    ReportExecution2005 end point
    http://msdn.microsoft.com/en-us/library/ms154052.aspx

    SharePoint proxy endpoints
    http://msdn.microsoft.com/en-us/library/ms155398.aspx

    SharePoint Integrated mode ReportService2006
    http://technet.microsoft.com/en-us/library/reportservice2006.reportingservice2006

    Windows Management Framework 3.0 (PowerShell) download
    http://www.microsoft.com/en-us/download/details.aspx?id=34595

    Power Shell quick reference (Cheat sheets)
    http://www.microsoft.com/en-us/download/details.aspx?id=30002

    PowerShell script for getting all Prerequisites to install SharePoint server 2010
    http://gallery.technet.microsoft.com/scriptcenter/bcf3332d-f726-4ac7-b01a-eeda4b7ece8e

    Making changes to Application Pool
    http://hodentekhelp.blogspot.com/2013/04/how-do-you-make-changes-to-application.html

    Power Shell – In depth link
    http://msdn.microsoft.com/en-us/library/gg492249.aspx

    System.Management namespace details
    http://msdn.microsoft.com/en-us/library/aa719480.aspx

    RSS disambiguation
    http://en.wikipedia.org/wiki/RSS_(disambiguation))

    Configuring Reporting Services URL
    http://msdn.microsoft.com/en-us/library/bb630447.aspx

    Writing custom code for reports
    http://msdn.microsoft.com/en-us/library/ms156028.aspx

    Chapter 9: Windows Azure SQL Reporting

    Windows Azure SQL Reporting Services limitations
    http://msdn.microsoft.com/en-us/library/windowsazure/gg430132.aspx

    Pricing for hosting reports on Windows Azure SQL Reporting
    http://social.msdn.microsoft.com/Forums/en-US/ssdsgetstarted/thread/fecb288a-d1a8-4eda-b6f7-85f6dc1e4b4e

    Main link for pricing
    http://www.windowsazure.com/en-us/pricing/details/

    MSDN Forums
    http://social.msdn.microsoft.com/Forums/en-US/category/windowsazureplatform

    Technet forums
    http://social.technet.microsoft.com/Forums/en-US/ssdsgetstarted/threads

    Windows Azure Portal- link to old portal
    http://www.windowsazure.com/en-us/home/features/portals/

    Windows Azure Service - known issues
    http://msdn.microsoft.com/en-us/library/windowsazure/hh667464

    Comprehensive reference to SQL Azure with hands-on examples
    Microsoft SQL Azure: Enterprise Application Development, ISBN:9781849680806, Packt Publishers, 2010
    https://www.packtpub.com/microsoft-sql-azure-enterprise-application-development/book

    Chapter 10: Applications Accessing Report Servers

    Windows Presentation Foundation in Visual Studio
    http://msdn.microsoft.com/en-us/library/bb546194(v=vs.90).aspx

    Web Browser Class (.NET Framework 4.5)
    http://msdn.microsoft.com/en-us/library/system.windows.controls.webbrowser.aspx

    Browser WebBrowser.Navigate () method
    http://msdn.microsoft.com/en-us/library/system.windows.forms.webbrowser.navigate.aspx

    View and Explore Native Mode Reports Using SharePoint Web Parts (SSRS)
    http://msdn.microsoft.com/en-us/library/ms159772.aspx

    SQL Server Integration Services
    http://msdn.microsoft.com/en-us/library/ms141026.aspx

    Chapter 14: Web Service task to convert miles to kilometres
    SQL Server Integration Services Using Visual Studio 2005, ISBN: 9781847193315, Packt Publishers, 2007
    http://www.packtpub.com/sql-server-integration-services-visual-studio-2005/book












    DMCA.com Protection Status