|
|
-
|
|
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 a laptop that I travel with and on that laptop is all m......
|
|
-
|
|
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 a database. So in Object Explorer I click on the Tables folder, open the tab Object Exp......
|
|
-
|
|
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 the ‘YYY’ dim......
|
|
-
|
|
“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 Microso......
|
|
-
|
|
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 “Denali” Business Intelligence ......
|
|
-
|
|
CTP3 of SQL Server Code Name “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
that you build, deploy & execute. See
......
|
|
-
|
|
As I play with the recently released
CTP3 of SQL Server 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 (I covered these new features
......
|
|
-
|
|
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 important ne......
|
|
-
|
|
<p>
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
external metada......
|
|
-
|
|
CTP3 of SQL Server 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 fro......
|
|