Search Results: Document

• 
  How to Document SQL Server- BI Documenter

  How to Document SQL Server So you created this amazing BI solution. You have SSIS Packages loading your data warehouse, you have SSAS Cubes, and you have reports in SSRS. But how do you document this entire solution? It used to be a long tedious process.

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

  tags : Database, Index, SQL Server, SSAS, SSIS, SSRS, Tables, Document
• 
  Document your SSIS Packages with BI Documenter Part3: Comparing Snapshots

  In the last two posts we?ve discussed how to use BI Documenter to document your SSIS packages and reviewed the documents that is generated. Another one of the very useful features of BI Documenter is the Snapshot Comparison. Let us suppose that you have s

  Author:  TomLannen     Date: 12/1/2011     Section: Blog

  tags : 3rd Party Documentation, BI Documenter, SSIS Documentation
• 
  SSIS Docuementation with BI Documenter

  BI Documenter is a fantastic tool for SQL Server documentation. It documents your servers, and the BI stack (AS cubes, IS packages, reports). However, there seems to be a lot of confusion when documenting SSIS packages. A common issue I see is that a user

  Author:  ShawnHarrison     Date: 9/7/2011     Section: Blog

  tags : BI Documenter, documentation, management objects, stuff you need
• 
  Documenting Your SSRS Reports and Data Sources

  If the organizations you've worked with are anything like the ones I've had the pleasure of working with, then they probably had or have thousands of SSRS reports spread out all over the place. And back around the time a majority of companies were gearing

  Author:  DustinRyan     Date: 11/10/2011     Section: Blog

  tags : BI Documenter, document sql server
• 
  BI Documenter - Where do those table and column descriptions come from?

  Table and column descriptions may appear in your documentation. Where do they come from? Descriptions are entered into the database when the table or column is created. Once that column is saved the description cannot be changed. This means whatever descr

  Author:  ogonzalez     Date: 8/30/2011     Section: Blog

  tags : BI Documenter, Column Descriptions, Extended Properties, Table Descriptions
• 
  Using the commandline feature in BI Documenter

  Step by step instructions on using the BI Documenter commandline with the Windows Task Scheduler. Create your Solution in BI Documenter. Add all the objects from your BI Stack that you would like to be documented. Select Schedule Snapshot on the bottom ri

  Author:  TMMichau     Date: 12/28/2012     Section: Blog

  tags : BI Documenter features, Commandline, Windows Task Scheduler
• 
  listing out cube properties

  Travis, Yes there is an awesome tool called BI Documenter available from Pragmatic Works. You can not only list all this out for SSAS, but also your SSIS, SSRS and SQL Databases. Check it out and download trial here: http://pragmaticworks.com/Products/Bus

  Author:  briankmcdonald     Date: 6/23/2011     Section: Forum

  tags : briankmcdonald, sqlbigeek, SQLBIGeek
• 
  The Best SQL Documentation Tool on the Market

  If you read my blog you know from time to time I will blog about an exceptional third party SQL tool. Previously I’ve blogged about Task Factory and BI xPress , two amazing SSIS development tools. Well this week I figured I would talk about a killer SQL d

  Author:  DustinRyan     Date: 7/11/2011     Section: Blog

  tags : Document SQL Server, Pragmatic Works, BI Documenter
• 
  Document your SSIS Packages with BI Documenter Part2: Reading the Documentation

  In my previous post we walked thorough the process of creating SSIS documentation using BI Documenter .  In this post we will reap the rewards of our work on from the last post and review the documentation(not much of a reward, I know, but its better

  Author:  TomLannen     Date: 11/30/2011     Section: Blog
• 
  Pragmatic Works Software for MVPs

  This is just a quick post to remind folks who are current Microsoft MVP s that Pragmatic Works offers NFR licenses of its software ! This NFR offer includes: BIxPress - Audit, Notify, Deploy and Manage SSIS Packages BIDocumenter - One Stop Documentation S

  Author:  sqlchicken     Date: 4/22/2012     Section: Blog

  tags : BIDocumenter, BIxpress, DTSxChange, MVP, software, task factory
• 
  BI Documenter-OLIA....

  BI Documenter tools - there are four powerful tools in BI Documenter. Object Lineage/Impact Analysis (OLIA) is an excellent tool. It gives you the ability to see the family tree of your objects in a graph. This graph can be saved as a graphic file or atta

  Author:  ogonzalez     Date: 8/28/2011     Section: Blog

  tags : BI Documenter, Impact Analysis, Object Lineage
• 
  Preparing for Sematic Search

  SQL Server 2012 introduced a number of new features. One of the more interesting is an extension of the full-text search capability, called semantic search or more formally statistical semantic search. The premise behind semantic search is that statistica

  Author:  cprice1979     Date: 4/20/2012     Section: Blog

  tags : full-text search, semantic search, statistical semantic search
• 
  Document SQL Server 2012 with BI Documenter v4.5

  A while back I wrote a series of blogs on using BI Documenter , and since then there have been some updates to BI Documenter which I believe are worth mentioning. The first new feature, or set of features if you think about it, all of the existing BI Docu

  Author:  TomLannen     Date: 6/1/2012     Section: Blog
• 
  Get a Count of Stored Procs in a Database

  This morning, I had to compare a documentation of a SQL database to what was actually in the database. More specifically, the stored procedures. The client wasn’t sure if all the stored procedures were showing up in the documentation. I looked at the stor

  Author:  ShawnHarrison     Date: 9/23/2010     Section: Blog

  tags : Management Studio, sysobjects, TSQL, Stored Procedures
• 
  Conditional formatting based on the Hidden property of a row group

  I'm trying to format the background color of some cells/text boxes in a report based on the current Hidden (Visible? Toggle? I'm not sure the right term) property/status of a Row Group (or it could be some other object--e.g., text box--in the report). I p

  Author:  Christian     Date: 3/16/2010     Section: Forum

  tags : expression, hidden, hidden property, row group, visibility, conditional formatting
• 
  Installing Applications on Windows Server through RDP

  A little more than a year ago, we at Pragmatic Works encountered a small problem installing BI Documenter on Windows Server 2003. Installation seemed fine until the end at which point, the user would receive the error message ‘BI Documenter installation e

  Author:  ShawnHarrison     Date: 8/1/2011     Section: Blog

  tags : admin rights, BI Documenter, RDP, software installation., Windows Server
• 
  SQL Saturday #49 Documenting your BI Stack

  I am excited to announce that I will get the opportunity to present a Mini Session at the next SQL Saturday in Orlando on October 16th at 1:15pm. I will be presenting a tool (BI Documenter) that documents your major SQL Server components and the "entire"

  Author:  SMcDonald     Date: 9/21/2010     Section: Blog

  tags : documenting BI, Pragmatic Works, SQL Saturday
• 
  SQL 2011 Denali New SSIS Parameters

  Normal 0 false false false false EN-US X-NONE X-NONE SQL 2011 Denali New SSIS Parameters SQL 2011, code name Denali, has some great new features for SSIS. One of the most powerful features is parameters. These are a lot like variables in the package. But

  Author:  MikeDavis     Date: 2/22/2011     Section: Blog

  tags : denali, sql 2011, ssis
• 
  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
• 
  Notes from PowerPivot Example

  We had a bit of an impromptu session today during today's webinar. You can find the recording for that session at http://www.PragmaticWorks.com and click Webinars. Here's my scripted demo which shows DAX, PowerPivot and more from the AdventureWorksDW2008(

  Author:  BrianKnight     Date: 5/25/2010     Section: Blog

  tags : PowerPivot, SQL Server 2008 R2, Power Pivot
• 
  "OutOfMemory" Exception in BI Documenter

  Have you seen an OutOfMemory Exception with BI Documenter? Some users have encountered this message and we have a couple of things you can do to workaround this issue. 1. Try turning off Generate Table Profile Data, Generate Sample Data, and Include Objec

  Author:  TMMichau     Date: 11/19/2012     Section: Blog

  tags : BI Documenter, OutOfMemory
• 
  PASS Elections Portal

  If you've been under a rock the last few weeks you may not know that PASS is currently undergoing their board elections process. I'm not going to rehash the entire saga here but this is just a quick post to let everyone know about a great resource PASS ha

  Author:  sqlchicken     Date: 8/25/2010     Section: Blog

  tags : board of directors, BOD, elections, PASS, pdiddy, portal, vote, vote or die, wtf
• 
  SSRS governance

  Practical experience in managing the SSRS environment seems not to be shared. Governance and process around shared datasource creation. Managing security. Migration of objects from a report development environment to a production environment. General guid

  Author:  syale     Date: 3/9/2011     Section: Forum

  tags : attribute, format, governance, guidance, migration, SSRS, variable, xquery
• 
  Orphaned Users for Sql Server Databases

  A customer of ours is using one of our products to document their sql environment. The problem they were having was they were able to document everything except for 2 specific databases. There environment is SQL 2008R2. They have the DBO permissions to bo

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

  tags : pragmatic works, Property Owner is not available for Database, This property, Orphaned Database User
• 
  Tips for using the BIDN forums

  I really have not posted much in the way of blogs on here lately. I've been putting together what I'm hoping will be a useful ( and free ) .PDF that you ( as a BIDN user ) will be able to pass on to people you meet that helps them get set up and familiar

  Author:  KeithHyer     Date: 6/29/2011     Section: Blog

  tags : forum etiquette, HOWTO, tips-n-tricks, BIDN