CLR vs Transact SQL
One thing for sure, we will be revisiting a post such as this one to add more information as we continue to research the subject matter. Our stored procedures have always been transact-sql until about … Read more
Category : Databases
Mysl, MSSQL, Oracle, SQLITE, POSTGRES
Reporting Services Useful Sites
Adding Header and Footer to a Report Working with “lists” in reporting services Adding Images Microsoft Report Viewer Redistributable 2008 Reporting Viewer Samples Features of Reporting Service http://www.microsoft.com/sqlserver/2008/en/us/ Reporting Services Ten Common SQL Server Reporting … Read more
SSIS Command Line Tools
You can use SSMS (sql server management studio ) to connect to the integration services. But SSMS is not the only tools available for that purpose. Let say you do not have SSMS installed. Should … Read more
SSIS Deployment
When i first started learning SSIS, i was confused, trying to put together all the different pieces of the integration services. The challenge is the fact that i do not do that on a daily … Read more
Deploying an SSIS Package
Deploying an SSIS package You can deploy a package to an instance of SQL server or to a file system. The file deployment is the preferred choice of ycsoftware. Obviously your first step is to copy … Read more