SQL Server Data Tools – Business Intelligence for Visual Studio 2012 released online

יום חמישי, מרץ 7, 2013

  Microsoft released SQL Server Data Tools – Business Intelligence for Visual Studio 2012 (SSDT BI) templates. With SSDT BI for Visual Studio 2012 you can develop and deploy SQL Server Business intelligence projects. Projects created in Visual Studio 2010 can be opened in Visual Studio 2012 and the other way around without upgrading or downgrading – it just works. The download/install is named to ensure you get the SSDT templates that contain the Business Intelligence projects. The setup for these tools is now available from the web and can be downloaded in multiple languages right here: http://www.microsoft.com/download/details.aspx?id=36843 The...
אין תגובות

SQL 2012 Linked servers

יום ראשון, דצמבר 16, 2012

sp_addlinkedserver (Transact-SQL) Creates a linked server. A linked server allows for access to distributed, heterogeneous queries against OLE DB data sources. After a linked server is created by usingsp_addlinkedserver, distributed queries can be run against this server. If the linked server is defined as an instance of SQL Server, remote stored procedures can be executed. Syntax sp_addlinkedserver 'server' 'product_name' ]      'provider_name' ]      'data_source' ]      'location' ]      'provider_string' ]      [ , [ @catalog=...
תגובה אחת

Linked Cubes

יום שבת, ספטמבר 8, 2012

This is something I used to use in SQLR2 to solve the perspective security challenge. What is it? A linked cube is an MDStore cube object with a Subclass Type of sbclsLinked. The contents of a linked cube are based on another cube that is defined and stored on a different Analysis server. Unlike a virtual cube, which can contain portions of one or more cubes, a linked cube references the entire contents of a single cube. A subscribing server is an Analysis server that contains a linked cube. A publishing server contains the source cube upon which...
אין תגובות

Tabular Models with DirectQuery Mode

יום שני, יולי 16, 2012

Tabular models are authored by using the model designer SQL Server Data Tools (SSDT). The model designer creates all models in memory, which means that when you are modeling, if your data is too large to fit into memory, you should import only a subset of data into the cache used by the workspace database. When you are ready to switch to DirectQuery mode, you can change a property that enables DirectQuery mode. For more information, see Enable DirectQuery Design Mode (SSAS Tabular). When you do this, the model designer automatically configures the workspace database to run in...
תגובה אחת

SQL&BI on June 11th 2012 Daniel Hotel Herzelia

יום שישי, יוני 1, 2012

Hi all! I would like to invite you to this event were I will walk you through a full day seminar on SQL 2012 end to end the complete BI solution. It will be DEMO oriented and lots of methodology & best practices. You can register here: http://www.microsoft.com/israel/sql-explore/content/Seminars/12067.aspx I am looking forwards to see you there! Ronen
אין תגובות