THE SQL Server Blog Spot on the Web
Welcome to SQLblog.com - The SQL Server blog spot on the web
Browse by Tags
SQL Server 11
SQL Server 2005
SQL Server 2008
SQL Server 2011
SQL Server 2016
sql server integration services
Start / Stop SQL Server, SSIS, SSAS, SSRS and SQL Server Agent at once with a batch file
A lot of developers have SQL Server and its different services running on their PC or notebook to develop or test BI solutions. Unfortunately this slows down your system quite a lot. To speed things up when not using SQL Server, I used to stop and start each service manual quite often. Recently I found out that it's possible to start and stop all ...
January 6, 2009
Is Microsoft serious about BI?
The short answer is yes. The long answer is that Microsoft should still improve in many ways. I thought about this many times before writing this post, because I want to be constructive and I hope that my words will not be misunderstood. My consideration start from the lack of a BI client. If Microsoft want BI for the masses, a low-cost end-user ...
SQLBI - Marco Russo
May 26, 2007
SSIS: ForEach Looping through a recordset
I was trying to find a way to repeatedly run the same MDX CREATE GLOBAL CUBE statement 70 times, building 70 different offline cubes for sales rep type folks to carry around for a client, and I just couldn't get it. I have some experience with SSIS, mostly from writing a tutorial on how to do RSS feeds with SSIS earlier that I am not sure ...
January 19, 2007
Brought to you by