Hovsep's SQL Server Favourite Bookmarks - Developer
Hello, Everyone
Just wanted to share with you my favourite bookmarks to websites, articles and blogs on SQL Server from a Developer's perspective. I hope you like these and are willing to share yours with the rest of the world.
My personal favourite tool is of course the Visual Studio Team Edition for Database Developers. Its a great tool that every database developer should own. Let's start with this one, then.
Visual Studio Team Edition for Database Developers (VSTEDB):
VSTEDB Homepage: https://msdn.microsoft.com/vstudio/teamsystem/dbpro/
Channel9 has a great video intro for VSTEDB at: https://channel9.msdn.com/ShowPost.aspx?PostID=213649
SQL Server RDBMS-related favourites:
Interested in developing applications that connect to DB2, SQL OLAP, XML, Data Mining, etc. using .net? Or do you need to access SQL Server from a Java Application using ODBC, then the following download will be great for you:
Feature Pack for SQL Server 2005 Feb 2007
https://www.microsoft.com/downloads/details.aspx?familyid=50b97994-8453-4998-8226-fa42ec403d17&displaylang=enYou need to learn more about SQL Server? Download the sample databases to get more:
SQL Server 2005 Samples and Sample Databases (February 2007)
https://www.microsoft.com/downloads/details.aspx?FamilyID=e719ecf7-9f46-4312-af89-6ad8702e4e6e&DisplayLang=en
Business Intelligence favourites:
Need to learn BI using a practical example? Start from a real project:
Project REAL—Business Intelligence in Practice
https://www.microsoft.com/sql/solutions/bi/projectreal.mspxComparing SQL Server 2005's new BI features? Start here
Business Intelligence and Data Warehousing in SQL Server 2005
https://www.microsoft.com/technet/prodtechnol/sql/2005/dwsqlsy.mspxGotDotNet resource on BI based on SQL Server:
Business Intelligence Architecture and Design Guide
https://www.gotdotnet.com/codegallery/codegallery.aspx?id=00895184-067e-4183-b186-48d9f104aaafHaving trouble deploying Integration Services Packages? Here's a great resource for you:
Deploying Packages Tutorial
https://msdn2.microsoft.com/en-us/library/ms365338.aspxWant to learn Integration Services the hardcore way? Check-out the Guided Tours on MSDN. These ones are awesome!
SQL Server 2005 Integration Services Guided Tours
https://www.microsoft.com/sql/technologies/integration/tours.mspxIf you love Integration Services like me, you'd want to use some tricks that would allow you to update an SSIS Package's properties at run-time. For example, if you created an SSIS package that imports a file, you'd like to execute that package on the server, but to a different file path than the one you used during development. SSIS Package Configurations come to your rescue:
Package Configurations
https://msdn2.microsoft.com/en-us/library/ms141682.aspxHow to: Create a Package Configuration
https://msdn2.microsoft.com/en-us/library/ms140213.aspxAnother great tool withing the SQL Server arsenal is Reporting Services. Below are the great tutorials that I personally found interesting.
Reporting Services Tutorials Home
https://msdn2.microsoft.com/en-us/library/ms170246.aspxIf you'd like to generate an .rdl report file using .net, here's a great tutorial for you:
Tutorial: Generating RDL Using the .NET Framework
https://msdn2.microsoft.com/en-us/library/ms170667.aspxIf you want to update a report's .rdl file in run-time, here's a tutorial that tells you how to:
Tutorial: Updating Reports Using Classes Generated from the RDL Schema
https://msdn2.microsoft.com/en-us/library/aa337451.aspxThese are great articles for those who want to build reports based on data sources that listed in SQL Server.
Create Reports from Any Data Source Using SQL Server Reporting Services Custom Data Extensions
https://www.devx.com/dbzone/Article/31336Custom Data Processing Extensions for Reporting Services
https://www.sqlmag.com/Article/ArticleID/49645