Monthly Archives: July 2011

Dual monitors, dual laptops, and the best way to manage them

Posted on July 29, 2011 by

Here is a tip that could make you much more productive:  At home, I have a desktop computer with dual-monitors (via a HDMI connection and a DVI connection with 1920×1080 resolution.  One monitor is 24-inch, the other 21-inch).  I also have … Continue reading →

Posted in Career, SQLServerPedia Syndication | 5 Comments

SQL Server does not script indexes by default

Posted on July 27, 2011 by

Here is a got-ya that happened to me.  In SQL Server I want to generate a script of all the tables in case I need to re-create them.  This is usually the case in a development environment when I’m building … Continue reading →

Posted in SQL Server, SQLServerPedia Syndication | 5 Comments

Setting role security in SSAS for a role-playing dimension

Posted on July 25, 2011 by

Here is a common got-ya.  You are modifying the cube dimension security for a role-playing dimension.  You make the changes and the cube processes successfully.  But when you try to connect to the cube, you get the following error message: The ‘XXX’ attribute in … Continue reading →

Posted in Security, SQLServerPedia Syndication, SSAS | 1 Comment

Visual Studio vNext

Posted on July 22, 2011 by

“vNext” is the codename Microsoft has chosen for the next version of the Visual Studio. A big feature is improving the application lifecycle management (ALM) process.  Check out this pdf “Visual Studio VNext: Application Lifecyle Managment” or the video The Future of Microsoft Visual … Continue reading →

Posted in SQLServerPedia Syndication, Visual Studio vNext | Leave a comment

SQL Server 2012 (“Denali”): New Certifications

Posted on July 20, 2011 by

According to the post SQL Server “Denali” Experts–We Need You! that asks for your feedback on the Microsoft certifications for the next version of SQL Server, there will be seven exams: Four certification exams are planned for SQL Server 2012, code … Continue reading →

Posted in Certification, SQL Server, SQL Server 2012, SQLServerPedia Syndication | 7 Comments

SQL Server 2012 (“Denali”): Details on the next version of SSIS

Posted on July 18, 2011 by

CTP3 of SQL Server 2012, code named “Denali”, was made available recently, and it offers a lot of new features for SSIS.  Some of my favorites are: SSIS Projects, which is an encapsulation of multiple packages into a single unit … Continue reading →

Posted in SQL Server 2012, SQLServerPedia Syndication, SSIS | 4 Comments

SQL Server 2012 (“Denali”): Installing SSAS Multidimensional vs Tabular Mode

Posted on July 15, 2011 by

As I play with the recently released CTP3 of SQL Server 2012, code name of Denali, I wanted to point something out about installing SSAS, since there is now two “modes” you can choose from due to the the new BI Semantic Model … Continue reading →

Posted in BISM, SQL Server, SQL Server 2012, SQLServerPedia Syndication, SSAS, Tabular | 1 Comment

SQL Server 2008 R2 Service Pack 1 Released

Posted on July 14, 2011 by

Microsoft has released the final build of SQL Server 2008 R2 SP1. It includes fixes from SQL Server 2008 R2 RTM Cumulative Updates 1 through 6, and some new features introduced since those cumulative updates.  Release notes for SQL Server 2008 R2 SP1 is available here. SP1 adds several … Continue reading →

Posted in SQL Server, SQLServerPedia Syndication | Leave a comment

SSIS package taking forever to load when you open it?

Posted on July 13, 2011 by

When you open a SQL Server Integration Services (SSIS) package in SSIS Designer or add components to a package, SSIS by default checks the data sources used by the various components. This process for SSIS package validation ensures that the … Continue reading →

Posted in SQLServerPedia Syndication, SSIS | 3 Comments

SQL Server 2012 (“Denali”): CTP3 now available!

Posted on July 12, 2011 by

CTP3 of SQL Server Code 2012, code name “Denali”, was made available for download this morning.  You can download the 32-bit and 64-bit versions here.  Official announcement from the SQL Server team blog and the announcement from the Analysis Services … Continue reading →

Posted in Power View/Project Crescent, SQL Server, SQL Server 2012, SSDT/Juneau | 9 Comments