Search Results: view

• 
  Creating your first Data Mining Structure and Model

  Learn how to built a Data Mining Structure and Model. Understand how a view is set up to support the Data Mining.

  Author:  MikeDavis     Date: 8/9/2010     Section: Article

  tags : Data Mining, Mining Model, Mining Structure, SSAS
• 
  SQL Server Views: Some Great Views about Views

  Everybody has different views about VIEWS, that’s what make them interesting topic to discuss. Other thing is if you make some assumptions about VIEWS, they can lead you to problems. As my target audience is SQL beginners, today I’ll talk abou

  Author:  pkumar3     Date: 5/3/2012     Section: Blog

  tags : SQL Server, SQL Server 2008, SQL Server 2008 R2
• 
  NOLOCK and indexed views

  I'm current working on a new SSAS solution and am using views for the underlying dimension data source. I created the views myself (although I'm no DBA) and used the NOLOCK hint. But then I read that I should also index my views. However I can't index my

  Author:  EGAN     Date: 1/22/2010     Section: Forum

  tags : hints, NOLOCK, SSAS, Views
• 
  Building Your First Power View Report

  This has been reposted from a guest blog post I wrote on the Microsoft Business Intelligence team blog . Fulfilling User Needs Developing a Power View report has been touted as being so simple that within a handful of clicks you can add rather impressive

  Author:  DevinKnight     Date: 7/16/2012     Section: Blog

  tags : Power View, SQL 2012
• 
  Free Training Webinar - Maximizing the Data Exploration Capabilities of Power View

  Pragmatic Works hosts FREE live demos every Tues & Thurs @ 11 am EST. SQL Server, SharePoint, PowerPivot and Business Intelligence topics from Microsoft MVP's and industry experts. Join Melissa Coates for Free Training on the T's and support W.I.T. (W

  Author:  MWatts     Date: 3/27/2013     Section: Blog

  tags : apabilities, ata exploration, harepoint, Power View, xcel 2013
• 
  Creating a Data Source View(DSV) in SSAS

  Continuing with the series on building your first cube, Adam takes you through exploring the UDM in SSAS 2008 and creating a DSV from which your cube can be designed.

  Author:  AdamJorgensen     Date: 11/24/2009     Section: Article

  tags : SSAS 2008, SSAS Development, SSAS Projects, DSV
• 
  BULK INSERT

  « 1| 2 | 3 » Recently, there was a post where the user found himself in a problem when loading data utilizing BULK INSERT This post is the first from a series, wich I want to explain how to use BULK INSERT in multiple possible ways. BULK INSER

  Author:  marcoadf     Date: 1/13/2012     Section: Blog

  tags : bulk, bulk insert, column, csv, fieldterminator, file, firstrow, flat, fmt, format, identity, identity column, insert, lastrow, rowterminator, Server, skip, txt, view
• 
  Use a Function as a Parameterized View! The Best Thing Since Sliced Bread

  You have a query that gets data perfectly and you would like to make into a view so you can use it in a number of places without re-coding. But there’s a problem, it requires parameters such as a date range to filter and SQL Server views do not support pa

  Author:  bryan_cafferky     Date: 9/4/2012     Section: Article

  tags : SQL; views, t-sql; functions
• 
  Discover the power of Microsoft SQL Server with sql server business intelligence

  SQL 2005 or 2008, how do you configure security to allow a user to SELECT data from a table but not view the table definition?

  Author:  fvcdata2011     Date: 1/9/2012     Section: Article

  tags : sql Interview questions and answers, sql select statement, sql server error 18456, SQL Update Join
• 
  .NET GAC viewability....

  Ever wanted to see the full directory structure of the GAC....? Well here is registry hack to enable the viewing of the GAC as you would any other directory in Windows Explorer. 1. Run regedit. 2. Navigate to HKEY_LOCAL_MACHINE\SOFTWARE\MICROSOFT\FUSION.

  Author:  RobertHarris     Date: 3/4/2011     Section: Blog

  tags : Assemblies, C#, C++.NET, F#, GAC, VB.NET, .NET
• 
  MVC 3 View Bag

  A common task in MVC, or in any web page, is to display a page containing text, date time, and drop down fields used for editing and creating records. MVC 1 & 2 used view models to wrap up and send the data to the view, see my earlier blog post on vie

  Author:  mbrown     Date: 8/29/2011     Section: Blog

  tags : MVC 3
• 
  Unable to view webinar recordings

  At my company we facilitate/sponsor free monthly webinars for the BI community. After those webinars are over, you have the opportunity to go back to view those recordings at a later date(not past two months of the original recorded date). Sometimes what

  Author:  SMcDonald     Date: 5/27/2010     Section: Blog

  tags : free training, webinar recordings, pragmatic works
• 
  Beginning T-SQL

  Today I have attended the free webinar on T-SQL for SLQ Server from Pragmatic Works. This was a fantastic session by Patrick LeBlanc. Even though I had some experience in T-SQL I have learnt a few new things mostly the new features of SQL SERVER 2008. The

  Author:  indupriya     Date: 2/22/2010     Section: Blog

  tags : Grouping sets, Identity_Insert, Inner join, Left outer join, Right outer join, SQL
• 
  New Azure SQL Database Performance Features

  It appears that Microsft has silently refreshed some Services/Management portal as no blog or In specific im referring to the vizualization added to Windows Azure SQL Database We can now view Deadlock Failed Conections Throttled Connections etc You may vi

  Author:  nitya     Date: 7 days ago     Section: Blog

  tags : baseline, Database, indowsazure, metrics, QL, roubleshooting
• 
  Bulk Insert and Identity Column

  The problem is that your column file does not match the table column. Bulk Insert needs to know how to map columns even more if columns are in diferent order. If you dont want a format file and want to turn this all process automatic, try to use a View. Y

  Author:  marcoadf     Date: 1/10/2012     Section: Forum

  tags : bulk insert, Column, identity, view
• 
  SQL Lunch #68 – Designing Your First Power View Report

  Next week I will be speaking on designing your first Power View report for SQL Lunch . Be sure to join me for the event and as always “No fluff, just stuff”. Add To Outlook: Add To Calendar Date and Time: 7/18/2012 11:30:00 AM CST Topic: #68-D

  Author:  DevinKnight     Date: 7/11/2012     Section: Blog

  tags : Power View, SSRS
• 
  Limiting Table Access for Reporting Part 2

  In the first blog post of this series, I showed you how to create a database schema and how to create a view. In this post, I will wrap it all up and show you how to create a SQL Server login account. I will also show you how to give them access to the vi

  Author:  briankmcdonald     Date: 7/29/2010     Section: Blog

  tags : Locking users down, Permissions, Views, Brian K. McDonald, SQL Server
• 
  Helpful System Views to Keep in Mind

  When I'm at work, at least a couple times a week, I find myself needing to dive into some of the tiny little details of the environment that I'm working in. Whether I've been working on a database for a year, or it was a table that I just created a day ag

  Author:  kylewalker     Date: 9/10/2010     Section: Blog

  tags : data warehouse, System Views
• 
  Junk Dimensions with no Loading Needed

  When you are working with dimensional modeling there are some situations where several dimensional attributes don’t make since to be in any other dimension. When this occurs you can combine them into one dimension call a Junk Dimension. In this example yo

  Author:  MikeDavis     Date: 5/6/2011     Section: Blog

  tags : Cube, Dimension, DSV, Junk Dimension, SSAS
• 
  SQL Server Database 'Views'

  I wanted to spend a few minutes discussing the topic of VIEWS. When I first started reading about them, I admit, I was confused. To try to explain it to somebody would have definitely been hard to do. So let's start off with a couple of text book definiti

  Author:  SMcDonald     Date: 7/1/2010     Section: Blog

  tags : database views, pragmatic works, virtual tables, views
• 
  Increasing or Decreasing Sampling Size in SSAS Data Source View Data Explorer

  Recently, I have begun my quest of mastering SSAS. I realize that it may take time and I am more than willing to put in the time to achieve this monumental task. J At any rate, as a network bandwidth conscientious guy that I am, I wanted to decrease the s

  Author:  briankmcdonald     Date: 7/19/2010     Section: Blog

  tags : Data Source View, Explore Data Options, Increase or Decrease Sampling Size, SSAS
• 
  Visio as a Business Intelligence Tool?

  With this topic, I want to share Visio 2010 and sharepoint 2010 new features. But mainly, I would like to hear your feedback, ideas, experience and if possible, some examples where you find this would be interesting, but must of all if you use this in you

  Author:  marcoadf     Date: 12/21/2011     Section: Blog

  tags : 2007, 2010, Data Graphic, europe map, Portugal, ribbon, Visio, Visio Services
• 
  Free Training Webinar - High Volume Data Processing Techniques

  Pragmatic Works hosts FREE live demos every Tues & Thurs @ 11 am EST. SQL Server, SharePoint, PowerPivot and Business Intelligence topics from Microsoft MVP's and industry experts. Join Julie Koesmarno for Free Training on the T's and support W.I.T. (

  Author:  MWatts     Date: 3/25/2013     Section: Blog

  tags : Pragmatic Works Free Training, SQL Training, SQL Server 2008 R2
• 
  SQL Server™ Schemas and Data Warehouse Solution Organization

  Good organization helps us to develop efficiency and, even more importantly, increases our solutions understandability. Organizing the physical implementation of a business intelligence solution’s data tier within SQL Server™ is critical for organizing th

  Author:  JoeSalvatore     Date: 2/25/2011     Section: Blog

  tags : 2008, 2008 R2, Business Intelligence, Data Design, Schemas, SQL Server, SQL Server Versions, 2005
• 
  CHM File Action Canceled Screen/Unable to View CHM

  Late last week, I was able to assist a BI Documenter customer who was having an issue opening a .chm file generated by BI Documenter. Every time he tried to open the compiled help file, his screen showed “Action Canceled” and he was unable to view the .ch

  Author:  DustinRyan     Date: 11/23/2009     Section: Blog

  tags : chm file action canceled, unable to view chm file, can't view chm file