Search Results: R2

• 
  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
• 
  Creating 5 Star Rating using Indicators in SSRS 2008 R2

  Creating 5 Star Rating using Indicators in SSRS 2008 R2

  Author:  aseem.sb     Date: 1/3/2012     Section: Article

  tags : Indicators, Reporting Services 2008 R2, SSRS R2
• 
  Report Services 2008 R2 - Data Bar

  In this article, you will learn how use the new data bar control in SQL Server Reporting Services 2008 R2 just released a few short weeks ago.

  Author:  briankmcdonald     Date: 5/26/2010     Section: Article

  tags : Data Bar, SSRS, Reporting Services 2008 R2
• 
  SSRS 2008 R2 June Webinar Details

  Today I gave a presentation on how to create some awesome reports using the Sparkline, Map and Data Bar (all R2 features). I also discussed some of the different areas you could use expressions and showed some different examples. I am really excited that

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

  tags : Databars, Maps, Pragmatic Works, Sparklines, SSRS, SSRS 2008R2, Training on the T's, Sherri McDonald
• 
  Upgrading from 2005 to 2008 (R2?)

  I'm looking at upgrading some ( 13 including my DR site ) servers from 2005 to 2008 or 2008 R2. I don't work for a huge shop ( in terms of SQL installations ). I support primarily 3rd party applications on the servers, an increasing number of in-house app

  Author:  KeithHyer     Date: 10/5/2010     Section: Forum

  tags : 2005, 2008, 2008 R2, reasons, upgrading
• 
  Free SSRS Training – SQL Lunch #23 (SSRS R2 – Shared Datasets & Report Parts)

  Join SQL Server MVP, Patrick LeBlanc, next week on the SQL Lunch to learn about Share Datasets and Report Parts in SSRS R2. Go to SQL Lunch and add this event to your calendar or use the link in this posting. To receive notifications about upcoming SQL Lu

  Author:  PatrickLeBlanc     Date: 7/9/2010     Section: Blog

  tags : Patrick LeBlanc, Speaking, SQL Lunch, SSRS R2
• 
  Group Level Page Numbering using Reporting Services 2008 R2

  In this article, Brian will show you how to include group level page numbering along with total report page numbering. This comes in handy when you have a large report with sets of grouped data.

  Author:  briankmcdonald     Date: 12/15/2010     Section: Article

  tags : Brian K McDonald, Group Page Numbering, Page Numbering, ResetPageNumber, SSRS, Reporting Services
• 
  SQL Server 2008 R2 for the DBA Recording and PowerPoint

  I recently had the opportunity to do two presentation on SQL Server R2 for the DBA. In the first session there were approximately 150 attendees and at the second there were approximately 400 attendees. The recording is available here and you can download

  Author:  PatrickLeBlanc     Date: 7/23/2010     Section: Blog

  tags : Patrick LeBlanc, Speaking, SQL Server, R2
• 
  Convert Address to Spatial Data - Geocoding for SQL Server R2

  If you want to use the new mapping feature in SQL server R2. You may want to get the Spatial data for the address data you have. There are several websites that can do this for you. Here are a few: http://batchgeo.com/ http://www.findlatitudeandlongitude.

  Author:  MikeDavis     Date: 5/5/2010     Section: Blog

  tags : Address, Geocoding, R2, Spatial, SSIs
• 
  SQL R2 Map Change map type, Road, Aerial, Hybrid

  With the new Map control in SQL 2008 R2 there are three different map types, Road, Aerial, and Hybrid. If you want to allow your users to change the map type you would think you could map a parameter to the property on the tile layer with these three type

  Author:  MikeDavis     Date: 8/6/2010     Section: Blog

  tags : Aerial, Hybrid, Map, Road, SSRS
• 
  SQL Server Reporting Services R2 - Publishing Report Parts

  SQL Server Reporting Services R2 – Publishing Report Parts SQL Server Reporting Services R2 (SSRS) allows report developers to not only publish reports and data sources to the report server, but now they have the ability to publish report parts. You can p

  Author:  PatrickLeBlanc     Date: 5/16/2010     Section: Blog

  tags : Report Builder 3.0, Reporting Services, SQL Server
• 
  Creating an inline bar chart (databar) for SSRS 2005.

  First let me say that I much prefer working in SSRS 2008 R2. In fact prior to my current project I hadn’t ever really worked in SSRS 2005. Now, however, I really appreciate how much more user friendly 2008 R2 is over 2005, not to mention all the additiona

  Author:  TomLannen     Date: 9/22/2010     Section: Blog

  tags : Databars, SSRS 2005, SSRS 2005 data bars
• 
  LookUp and LookUpSet Functions New in SSRS 2008 R2

  With the release of R2 came a couple of pretty nifty new expressions in SSRS. The LookUp function allows us to perform a look up against a separate data set in our report using a field in our source data set where there is a 1 to 1 relationship. Likewise,

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

  tags : Join function, LookUp function, LookUpSet function, SSRS 2008 R2
• 
  Intro to MDX at SQL Saturday #130 – Jacksonville, FL

  This weekend is SQL Saturday #130 in Jacksonville, FL. On Friday, April 27th, is a great pre-con session by SQL Server MVP, Kevin Kline on Performance Tuning SQL Server 2008 R2. Go here to get registered for this phenomenal opportunity to learn from an un

  Author:  DustinRyan     Date: 4/26/2012     Section: Blog

  tags : free training, SQL Saturday
• 
  New features of SSRS 2008 R2 - Part 3 Map and spatial data visualization

  My 3rd favorite new feature of SQL Server Reporting Services (SSRS) 2008 R2 is Map and spatial data visualization . While this is my 3rd favorite (based on use for my current project), this feature is likely the coolest feature that has been added to SSRS

  Author:  bretupdegraff     Date: 12/4/2009     Section: Blog

  tags : Reporting Services, Spatial Data, SSRS, Maps
• 
  Rock Your Reports Series 3 of 3

  In this series finale, Sherri McDonald will show you to create a drill through from 1 map report into a detailed report for the state as well as include a map of the state.

  Author:  SMcDonald     Date: 3/28/2011     Section: Article

  tags : Maps, Pragmatic Works, Reporting Services R2, Spatial data, SSRS R2, Sherri McDonald
• 
  Hacking the SQL Server 2008 R2 AdventureWorks Installer

  I recently installed SQL Server 2008 R2 on a server that our company to test out and demo new technologies. I was geared up and excited about the promise of learning about some of the new features in SQL 2008 R2. I want to be able to blog about my finding

  Author:  bretupdegraff     Date: 12/1/2009     Section: Blog

  tags : AdventureWorks
• 
  SQL Server 2008 R2 Developer Installation

  Anyone else run into this? I'm installing a development / testing VM in Virtual PC 2007 and when attempting to install SQL 2008 R2 ( developer - from MSDN ) under Win XP SP3 ( fully patched ) - otherwise, a clean install, I get the following error: "Insta

  Author:  KeithHyer     Date: 7/26/2010     Section: Forum

  tags : error, Installation, setup
• 
  Error: Connect to ssas 2008 R2 cube through excel 2010

  I am trying to connect to a SSAS 2008 R2 cube via Excel 2010 I built on server A that I only have access through a VPN. When I enter the informaion required to connect to the database server, I get the following error. I am using a windows username and pa

  Author:  jflores8737     Date: 4/11/2012     Section: Forum

  tags : error, excel 2010, oledb, redirector, sql server 2008 r2, sqlbrowser
• 
  SQL Server 2008 r2 login

  Looks like I've botched installation of SQL 2008 r2 I installed for SharePoint Server 2010. I tried to follow least-privileges guidelines for SharePoint and not sure where I made mistake. I had 3 accounts: spsqlsvc - I used as sercvice account for SQL Ser

  Author:  mdexch     Date: 5/18/2011     Section: Forum

  tags : sharepoint 2010, SQL 2008 R2 installation
• 
  FreeNAS and SQL Server Virtual Machines - any interest?

  As a developer, I've build up a really nice little trio of (test) servers that I use to do experiments and learn new things about SQL Server, replication, encryption and the BI stack in my spare time ( both minutes of it per week! ). The overview of the t

  Author:  KeithHyer     Date: 10/28/2011     Section: Forum

  tags : FreeNAS, iSCSI, sql server 2008 r2
• 
  Rock Your Reports Series 2 of 3

  In the 2nd of a 3 part series, Sherri McDonald will show you how to utilize an R2 feature into a report to give the end user information based on the U.S. Map as well as a comparison that has been done in a table using a data bar.

  Author:  SMcDonald     Date: 3/14/2011     Section: Article

  tags : Free Training, Pragmatic Works, SSRS Map reports, SSRS R2 Map, Webinar, Sherri McDonald
• 
  SQL Server 2008 R2 - Free ebook

  Microsoft has released an ebook named -- " Introducing Microsoft SQL Server 2008 R2 , by Ross Mistry and Stacia Misner!" The book contains 10 chapters and 216 pages, like so: PART I Database Administration CHAPTER 1 SQL Server 2008 R2 Editions and Enhance

  Author:  indupriya     Date: 5/6/2010     Section: Blog

  tags : learning, sqlserver 2008 R2 ebook
• 
  New features of SSRS 2008 R2 - Part 1 Naming Excel sheets when exporting reports

  This is the first of what I hope to be a long series of posts that demonstrate some new features of SQL Server Reporting Services in the 2008 R2 upcoming release. At some point I may define and go into more detail but for now, I simply want to expose you,

  Author:  bretupdegraff     Date: 12/4/2009     Section: Blog

  tags : Excel, SQL Server 2008 R2, Reporting Services
• 
  New features of SSRS 2008 R2 - Part 2 Report Part Gallery

  Report Part Gallery is a promising addition to the SSRS product in SQL Server 2008 R2 (currently using Nov CTP release). Imagine this: Jerry, a member of your team of developers, creates a series of cool data regions or charts that show key company metric

  Author:  bretupdegraff     Date: 12/4/2009     Section: Blog

  tags : Report Part, SQL Server 2008 R2, Reporting Services