Search Results: Team

• 
  The many facets of BI

  I recently had a client ask me to explain the different types of BI in SQL Server 2012, and explain what each tool could be used for and who the ideal target audience would be. I thought this would be a great blog post, as I’ve heard this question p

  Author:  ChrisSchmidt     Date: 11/28/2012     Section: Blog

  tags : BI, Corporate BI, PerformancePoint, Power View, PowerPivot, SSAS Multidimensional, SSRS, Team BI
• 
  Using Unary Operators to control Analysis Services hierarchy aggregations

  Analysis Services hierarchy aggregations can be easily controlled using unary operators. For example, in accounting there are GL accounts that are grouped in major GL account groups and used in different financial statements like Profit & Loss Stateme

  Author:  JoseChinchilla_SQLJoe     Date: 9/23/2011     Section: Blog

  tags : custom, operators, rollup, unary
• 
  An open letter to Microsoft - BI needs to be a single message across your products

  An open letter to Microsoft – BI challenges. To preface this letter, let me just say that I have drunk the kool-aid, just like the Merry Pranksters drank Ken Kesey’s koolaid ( http://en.wikipedia.org/wiki/The_Electric_Kool-Aid_Acid_Test ), and

  Author:  MarkGStacey     Date: 4/28/2012     Section: Blog

  tags : Office, PerformancePoint, PPS, Report Builder, Reporting Services, sharepoint2010, SQL Server, SQL2012, SSRS, Visio
• 
  Tour de Career: Team Roles

  In cycling each team is made up of nine riders. Each rider on a team can have a different specialization. A careful balance of skill sets on a team can determine if a team will stand triumphant on a champion's podium at the end of the day or simply fade i

  Author:  sqlchicken     Date: 7/26/2010     Section: Blog

  tags : profdev, tour de career, professional development
• 
  Terminology Differences between Team Foundation Server and Subversion

  I've been knee deep in Team Foundation Server 2010 reading and found a useful table describing the Terminology differences between Apache Subversion and Team Foundation Server. Not all the credit is mine, I got the list of differences from Wrox Profession

  Author:  Tyler     Date: 9/12/2011     Section: Blog

  tags : 2010, foundation, Server, Subversion, Team
• 
  Renaming Project Collections in Team Foundation Server 2010

  Team Foundation Server is a powerful tool that seamlessly integrates the Visual Studios with Source Control, Work Item Tracking, Automating Builds, Test Case Management, Reporting, and Virtual Lab Management. As such, it's necessary to develop Collections

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

  tags : 2010, Collections, foundation, Project, renaming, Server, Team
• 
  SQL Server “Denali”: CTP3 now available!

  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 from the Analysis Services and PowerPivot T

  Author:  jamserra     Date: 7/12/2011     Section: Blog

  tags : Juneau, Project Crescent, SQL Server, Denali
• 
  The Simple Truths of Our Service

  I read a book today called "The Simple Truths of Service" by Ken Blanchard and Barbara Glanz. As a support engineer at Pragmatic Works, I’m always looking for ways to add value and help clients resolve any issues they experience. At the end of the d

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

  tags : Customer Support, Pragmatic Works Customer Service
• 
  SQL Server Agent - Creating an instance of COM component with CLSID

  Today, one of my team members faced an issue that I was not able to give the answer right away. The problem was, in SSMS while he was connected to DEV JOBs, he couldnt edit steps, as image below: First we started for privileges/permissions issue. But that

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

  tags : @@version, 2008, Creating an instance of the COM component with CLSID, r2, Server, version
• 
  Conditional cell formatting

  You could create an expression using the Switch function. Its like a case statement. =Switch( Fields!Team.Value = "Bengals" , "Orange", Fields!Team.Value = "Ravens" , "Purple", Fields!Team.Value = "Browns" , "Brown", Fields!Team.Value = "Jaguars" , "Teal"

  Author:  ChrisAlbrektson     Date: 10/31/2011     Section: Forum
• 
  Sequence generator using SSIS

  hi jampa. Are you working with SQL Server 2012? Have you seen sequence object ? If not, and if you want to know if you have a task in toolbox to do so, the answer is no. You have other options like row_number . But I believe you cte solution is a good sol

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

  tags : generator, row_number, sequence
• 
  Why not use an SSIS SQL Server Destination

  Once upon a time, in SQL Server 2005, the SQL Server team was working tightly with the SQL Server product team to reserve a special spot of shared memory for SQL Server for SSIS to dump into and then as SQL Server would write into the database seamlessly.

  Author:  BrianKnight     Date: 6/24/2010     Section: Blog

  tags : performance tuning, sql server destination, ssis
• 
  Microsoft Business Intelligence Firestarter - Full BI Project Life Cycle

  Course Overview This one day seminar provides an end-to-end overview and direction for BI developers, administrators and managers who want to excel at leading high-performance teams and their organization through the Full BI Project Life Cycle (DW,ETL,OLA

  Author:  Slava     Date: 2/23/2011     Section: Blog

  tags : Dashboard, DW, SSAS, SSIS, SSRS, BI Training
• 
  I have been Knighted

  As I announced on my 2000-2010 a Decade in Retrospect blog post I have joined the ranks at Pragmatic Works and started my first day today. I’m excited to join such a great professional team, full of experts in the SQL Server and Business Intelligence fiel

  Author:  JoseChinchilla_SQLJoe     Date: 1/10/2011     Section: Blog

  tags : job, pass, server, sql, works, pragmatic
• 
  Meet Marco

  Hi. My name is Marco. I'm from Portugal and I am 26 years old. I've been working in BI in the past 4 years. Less than a year with oracle and the last 3 with SQL Server. I've a deep knowledge with SQL Server BI tools (SSIS, SSRS and SSAS). I've worked in a

  Author:  marcoadf     Date: 1/16/2010     Section: Blog

  tags : Marco Francisco, marcoadf, Portugal, presentation, Marco
• 
  SSIS: How to Make Use of the DSV

  In my experience, Data Source Views are not commonly used in SSIS packages. I can imagine a use for them. If I were the ETL architect leading a large team of developers on a data warehouse project, I might use the DSV to simplify the development efforts o

  Author:  MMilligan     Date: 5/3/2012     Section: Blog
• 
  SQL Azure

  I recently received a Mail from Microsoft Associate to participate in the 50GB preview for SQL Azure (find my tweet here ) I've been doing quite a bit of poking around on it which resulted in me blogging my findings on it. One of the most fundamental chan

  Author:  nitya     Date: 5/2/2010     Section: Blog

  tags : azure, embarcadero, redgate, sql, tools
• 
  Pragmatically Thankful

  This season, as we continue to grow and partner with some of the best of the best in the industry. I find myself very thankful. We have been blessed to hire many that were under or unemployed and are now kicking butt in the BI, SharePoint and SQL Server w

  Author:  AdamJorgensen     Date: 12/15/2010     Section: Blog

  tags : funny, hiring, Holidays, thankful, SQLJobs
• 
  MDX and Parameters??

  Here is what my current query looks like. I am using the [Current Teams] in a subselect because since it is dynamic I have SSRS can't doesn't allow me to use the dimension value in my chart because there is no metadata. The reason I am using date in a sub

  Author:  skerr     Date: 5/23/2012     Section: Forum
• 
  Advanced fill color expressions

  Hello. I work on a team that provides support to software developers for source control, build and deployment tools. Each tool has metrics related to the associated entity, such as the source control repository, build workflow, and deployment workflow. Th

  Author:  JustinJohnson     Date: 12/28/2010     Section: Forum

  tags : color, expressions, fill, text box
• 
  Obtaining Sharepoint

  rboorgapally said: Hi, I am student learning Microsoft BI stack. Though I obtained SQL Server and BIDS from dreamspark, thanks to my university collaboration with microsoft; I want to know if I can get Sharepoint server for free from microsoft ? If you wo

  Author:  BrianKnight     Date: 12/2/2009     Section: Forum

  tags : license
• 
  Pragmatically Yours Day 2 – Our Team

  One of the things I’m most proud of at our company is our team.You can see some of our team below taking down our booth at PASS this year. I get asked a lot of the same questions so I thought it was time for some Pragmatic Mythbusters to dispel some myths

  Author:  AdamJorgensen     Date: 2/11/2011     Section: Blog

  tags : Pragmatically Yours
• 
  Project Crescent - BI Tool for Denali

  I found the following interesting announcement on the SilverLight Team Blog about Project Crescent . Here is an extract from the announcement. Project Crescent allows business users to manage data and show information in a truly innovative and exciting wa

  Author:  indupriya     Date: 11/24/2010     Section: Blog

  tags : Denali, Project Crescent
• 
  Next Generation Of Analysis Services : BISM

  I watched the recorded session from Tech Ed " What's New in Microsft SQL Server Code-Named "Denali" for SQL Server Analysis Services & PowerPivot " and looks like its going to be new evolution for SSAS and BI. I would recommend every BI professionals

  Author:  meganathank     Date: 5/22/2011     Section: Blog

  tags : Denali, PowerPivot, SSAS, BISM
• 
  SQLRally Community Vote - Go Vote!

  SQL Rally Voting started last week and ends at 1PM PST on Friday, February 24th. SQL Rally 2012 will be in Dallas Texas on May 10-11 . This year Dustin Ryan and I have teamed up and have submitted a couple of sessions for the coming SQL Rally in Dallas. P

  Author:  ChrisAlbrektson     Date: 2/22/2012     Section: Blog

  tags : #SQLPass, #SQLRally, PASS, SQLRally