November 13, 2009
I’m enjoying the weekend, with Microsoft SQL Server R2 November CTP and its new features from Database engine features to Analysis Services features, Reporting Service features, etc…
I’ll post a series about those features en shaaa ALLAH in the next days, but let’s begin with Database engine features
#1 connectivity to SQL Azure: what’s SQL Azure? is a cloud-based relational database service built on SQL Server® technologies. To learn more about SQL Azure press here
First you need to have Microsoft SQL Server R2 November CTP, get all about it from here and SQL Azure account (I got it from Microsoft Connect)
Open SSMS, and using your Azure account (Server name, username and password) try to login
Read the rest of this entry »
November 11, 2009
Updated on 11/11/2009 7:47 PM
Note: The download links below will launch the Akamai download manager which is designed to provide you with more control over your download experience.
Download now Microsoft SQL Server 2008 R2 November CTP http://care.dlservice.microsoft.com/download/7/B/4/7B4A1F68-4D05-42C1-8982-E5CD8492C6FA/SQLFULL_x86_ENU.exe
Microsoft SQL Server 2008 R2 add-in to Excel that allows very large sets of data to be manipulated efficiently aka Microsoft Gemini now its formal name is PowerPivot
Download: What’s New in SQL Server 2008 R2 November Community Technology Preview (CTP) http://www.microsoft.com/downloads/details.aspx?FamilyID=89550298-D564-40C5-B586-30DC3F909F6F&displaylang=en
It’s now available for download for MSDN and TechNet subscribers, and it will be available to the general public on November 11th http://blogs.technet.com/dataplatforminsider/archive/2009/11/09/announcing-the-sql-server-2008-r2-november-ctp.aspx
November 4, 2009
hmmm, nice we have SSIS it makes life easier but it usually comes with non-understood problems like
“SQL Server Destination” (2185) failed with error code 0xC0202071 it means when you insert data into table in remote SQL Server don’t use SQL Server Destination component however use OLE DB Destination component, thank you SQL Server Central
Anyway I used OLE DB Destination component and everything went well but I found the trigger which updates something doesn’t fire simply because I do bulk insert and I should tell the BIDS please fire it.
So, right click on OLE DB Destination component then Show Advanced Editor… Component properties FastLoadOptions write FIRE_TRIGGERS
Thank you Piotr Rodak
November 3, 2009
Well… we need to assign a server login to has access on a database, let’s say the SQL Server Login we had created programmatically should has access on database “Database1” and for some reasons we should do that programmatically
Well. Create any C# project type (Windows, Class Library or even Console one), add reference to Microsoft.SqlServer.Smo, and Microsoft.SqlServer.ConnectionInfo
/// Creates database user
private void CreateDatabaseUser(Database database, String username)
User sqlServerUser = new User(datawarehouseDatabase, username); //initializes new User object and we say to which database it belongs and its name
sqlServerUser .UserType = UserType.SqlLogin; //SqlLogin not anything else
sqlServerUser .Login = “login_name”; //associated the user to login name, login name should be valid login name
sqlServerUser .Create();//here’s we create the user on the database and till now the user don’t have any permission on database objects
sqlServerUser .AddToRole(“db_owner”); //or any role like db_databasereader, db_databasewriter,…
P.S: There’s catastrophic mistake in Microsoft documentation of User.Login as they documented it as ReadOnly field although it’s not.How we can call the above method?
Server sqlInstance = new Server(
new System.Data.SqlClient.SqlConnection(“.”))); //connects to the local server
Database database = sqlInstance.Databases[“adventureworks”]; //initialize new object from database adventureworks
CreateDatabaseUser(database, “RamyMahrous”); //creates user RamyMahrous on database adventureworks
October 18, 2009
May be it’s my bad luck may be something else, but I didn’t find a complete post how to deploy Reports, and Data Sources in Reporting Services in away like BIDS.
First it’s a tool I developed to automate the deployment of BI solution (Creating Data warehouse, installing SSIS packages, creating Jobs, create Cubes and installing reports on Reporting Services Server).
If you don’t have time to read and just need to download the tool, here you’re
Source Code: http://cid-3e2288e7a8e55f56.skydrive.live.com/self.aspx/Public%20folder/Deploying%20Reports%20in%20Reporting%20Services%20Programmatically.zip
Herein, I’ll talk about the last thing which is deploying reports.
P.S: It’s my way in designing such task (Installing reports on Reporting Services Server) and it’s not standard or anything else just (follow your heart :))
Read the rest of this entry »
October 13, 2009
I really liked this post which talks about how could we make use of Cloud Computing in building Business Intelligence solution to draw the Big Image for the organizations
With Cloud Computing fast becoming the next big thing in IT, the jury is still out on how it can best be matched up with Business Intelligence (BI) to deliver real and sustainable benefits to business.
The focus of BI is the gathering, modelling, transforming and analysis of data (often from disparate systems), in order to provide a “big picture” to a business. Traditionally, BI has lagged behind the business it is meant to support. Reporting and data analysis can take a long time to process, and may run outside of business hours in order to reduce impact on the day-to-day operations. Businesses must wait to understand what is going on, and rely on old information to make decisions.
Enter Cloud Computing. The main benefits include lower cost, multiple redundant sites, and scalable provisioning of resources, which in turn allow for business continuity, disaster recovery and on-demand performance improvements.
More on http://xqrx.com/writing/a_cloud.php