Microsoft SQL Server Business Intelligence development studio

Microsoft Business Intelligence is delivered as part of the world's most popular business productivity suite and most widely deployed information platform. Check out some basics from MS Sql Server Business Intelligence. Sql Server Denali ctp 3 Release Date Denali CTP3 was released on 12 of July 2011 (and for some reason CTP2 was missed? Or was not publicly available). Releasing CTP3 in July might indicate that Microsoft might want to still release new version of SQL Server in 2011! I will monitor the situation and try to find out if there any features that haven't been included in CTP yet which may indicate CTP4 release but looking briefly at the new beta version is seems all big things are included. Microsoft sql server error 18456 Error 18456" error message when you specify configuration database settings on the Set Configuration Database Server page of SharePoint Central Administration. This usually means that your connection request was successfully received by the server name you specified but the server is not able to grant you access for a number of reasons and throws error: 18456. Invalid userID: SQL Server is not able to find the specified UserID on the server you are trying to get. The most common cause is that this userID hasn’t been granted access on the server but this could be also a simple typo or you accidentally are trying to connect to different server (Typical if you use more than one server) Invalid password: Wrong password or just a typo. Remember that this username can have different passwords on different servers. SQL Select Statement Syntax A database stores data in table (fields and rows). You can communicate with database using SQL and in order to retrieve data (rows) from one or more tables and one or more fields you can use SQL Select statement. Just check it out what is a database? SQL Add Column How to add a column to table that already exist using SQL alter table command. Our example will be presented using MS SQL Server 2008 R2. Let me just say that adding a column is relatively easy; we just need to start with alter table and specify the table name (if you use more than one schema in your database you will also have to specify it) after that will just need to use SQL and add column and specify column properties like data type, null or not null, default value (mandatory if you specify not null column). Create ssis package A package is created within the context of an Integration Services project. Before you can use SSIS Designer, you need to open an existing Integration Services project or create a new project. When you create a new Integration Services project in Business Intelligence Development Studio, a new package is automatically added to the project. To open SSIS Designer, you double-click a package in the SSIS Packages folder in an Integration Services project. For more information, see Integration Services Projects. rnCheck it out also for SQL Interview Questions, sql tutorial for beginners and How to interview someone for a job