Search Results: Version

• 
  Useful queries #3: Get SQL Server Edition, Version, Build and Last Update date and time.

  Keeping track of all the versions and editions SQL Server instances can be a daunting task if you don?t have the right tools and documentation. A very easy way to obtain version, edition and build information from your SQL Servers is by querying the SERVE

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

  tags : build, cumulative, edition, editions, service pack, SQL Server, update
• 
  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
• 
  Show Me What You're Workin' With (the SQL Server Versions Remix)

  There may come a time, where you will want to find out what version of SQL Server you're working with. To do this, there are a couple things you will need to know: 1) You'll have to either run a quick script or examine your SQL Server connection to find a

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

  tags : Version, SQL Server
• 
  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
• 
  SSIS Expressions And 4,000 Character Limit (1/3)

  This blog post was originally going to be a quick hit on a technique used to overcome the 4,000 character limitation of expressions. This limitation will go away in SQL Server 2012. However, since some many of us will continue to work with older versions

  Author:  CraigLove     Date: 1/5/2012     Section: Blog

  tags : Package Configurations, SQL Server, SQL Server Integration Services
• 
  Create Access 2010 File

  With which version of SQL are you trying to build this? Are you going the 32-bit or 64-bit route? Which version of Office do you have installed and are you trying to use the ACE drivers? I have about an hour later in the day - I'll try to set up a test an

  Author:  KeithHyer     Date: 1/26/2012     Section: Forum

  tags : accdb, Access2010, ACE
• 
  Help with using a temp table instead of OLE_CMD

  Can someone walk me through this process? I found a blog on the subject, but it appears to be is missing a step or using a different version of BIDs than I am using. Here is the blog link I found on Dan Matisis' Blog(BIDN). http://www.bidn.com/blogs/DanMa

  Author:  JohnG     Date: 2/25/2011     Section: Forum

  tags : OLE_CMD, SSIS, TempTable
• 
  SSIS: parallel processing not supported by analysis services processing task

  I'm getting the following warning in SSIS when using the Analysis Services processing task: Parallel processing not supported on Standard edition of Analysis Services SQL version Edition: Enterprise Edition PatchLevel: 10.2.4000.0 SP: 2 Version: 10.2.4000

  Author:  amrit     Date: 3/18/2011     Section: Forum

  tags : Analysis Services, parallel, sql server 2008, SSAS, SSIS
• 
  Is my SQL Server Pre-Release

  I get to work with a lot of different clients and client environments and like many companies they are often running mixed versions of SQL Server. This can make things challenges when doing training since if some folks are missing service packs, etc.. The

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

  tags : KBs, Versions, SQL Server
• 
  Analysis Services Webinar Recording and Q&A

  I hope you were able to attend my free webinar on Introduction to Analysis Services on April 2, 2013. If you weren’t you can now download the recording here . Because I covered new material all the way to the end of the webinar i thought I'd also an

  Author:  DevinKnight     Date: 4/2/2013     Section: Blog

  tags : Analysis Services, Multidimensional, PowerPivot, Tabular
• 
  OLAP PivotTable Extensions Update

  OLAP PivotTable Extensions is a really cool free add-in for Excel that’s been around for quite a while now. It allows you to have some exposure to what’s going on under the covers (Among many other features) while you browse a cube using an Ex

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

  tags : Excel 2013, PivotTable
• 
  Database Source Control - version control

  I am curious about what people out there are using for managing database code, database data, and version control of databases. For example, we have an application that is installed and a number of clients and each client potentially has a different versi

  Author:  bretupdegraff     Date: 12/17/2009     Section: Forum

  tags : SQL, Stored Procedure, Source Code Management, Version Control
• 
  SSIS and Oracle connections

  ***UPDATE*** The new SSIS connectors for Oracle and Teradata are available now. http://blogs.msdn.com/b/mattm/archive/2012/04/04/microsoft-connectors-v2-0-for-oracle-and-teradata-now-available.aspx FYI the 2.0 version is for 2012 only… You want the

  Author:  MMilligan     Date: 6/9/2011     Section: Blog

  tags : Attunity, OLE DB Connection Manager
• 
  Help on installing the SQL Server 2012 integrated along with SharePoint 2010.

  Hello BIDN Family, After long time gap, I just want to post a blog that might be helpful to the one who is going to learn, try and setup these great products of Microsoft as SQL Server 2012 and SharePoint 2010. If you are going to learn, try and install S

  Author:  Anil     Date: 4/24/2012     Section: Blog

  tags : Sharepoint 2010, SSRS
• 
  SQL Server “Denali”: Details on the next version of SSAS

  At the recent TechEd North America 2011 conference, details on the next version of SQL Server called “Denali” were released. Part of those details were an update on the SQL Server Analysis Services ( SSAS ) roadmap. The main new feature in SSAS is a new d

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

  tags : Denali, SQL Server, SSAS, BISM
• 
  SQL Server 2012 - IIF Function

  In earlier versions of SQL Server, when you were writing T-SQL, how many time you asked yourself "is there a if function?". Even when you used CASE function, how many time did you said "if there was a if function, this was a lot easier". Well, finally wit

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

  tags : case, function, if, IIF, limitation, nested
• 
  BIxPress 3.5: Now with More Awesome!

  Pragmatic Works has now released version 3.5 of the award-winning BIxPress software ! For those not familiar with BIxPress it’s a tool that helps you develop SSIS/SSAS solutions faster, easily/quickly deploy SSIS packages, monitor performance SSIS p

  Author:  sqlchicken     Date: 5/21/2012     Section: Blog

  tags : BIxpress, Monitor SSIS, Monitor SSRS, Performance dashboard, SSRS
• 
  SQL Server “Denali”: SQL Server Developer Tools, codename ‘Juneau”

  Juneau is the code name for the new SQL Server Development Tool (SSDT), to be released along with the next version of SQL Server, codenamed " Denali ". Its purpose is to provide a single development environment for all database-related project types by br

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

  tags : Juneau, SQL Server, SQLServerPedia Syndication, SSDT, Visual Studio 2010, Denali
• 
  Creating a site collection in SharePoint 2013

  SharePoint 2010 was worlds apart from SharePoint 2007, and SharePoint 2013 continues that change with an updated interface, performance improvements, etc.. SharePoint 2013 looks very metro-ish, in line with Microsoft’s new Windows 8 operating system

  Author:  ChrisSchmidt     Date: 3/12/2013     Section: Blog

  tags : creating a business intelligence center, sharepoint site collections
• 
  PowerPivot 101 Q&A

  Once again, thanks to everyone that attended my session on PowerPivot. Here are my responses to some of the questions I received during my session but did not have time to answer until now. 1. Does the current version of PP support drill through? The curr

  Author:  DustinRyan     Date: 10/31/2012     Section: Blog

  tags : free training resources, PowerPivot
• 
  SQL Server New Version Denali - New Feature Sequence

  SQL Server New Version Denali - New Feature Sequence One of the new featured in SQL Server 2011 – Denali is Sequence. Whoever have worked in Oracle or DB2 can easily connect to this feature and it is in the SQL Server wishlist for long time. While m

  Author:  pkumar3     Date: 10/18/2012     Section: Blog

  tags : SQL Server, SQL Server 2011 CTP3
• 
  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
• 
  WinSCP from SSIS - secure FTP transfers

  Intro: Free software - it's always right in everyone's price range and when one gets more out of it than one paid for it - there tends to be contentment. Recently when tasked with transferring some files via sFTP, the author found ( ok - Google found ) Wi

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

  tags : Secure FTP, SFTP, SSIS, StandardInputVariable, StandardOutputVariable, WinSCP
• 
  SSIS File Copy Failure

  I have an issue with an SSIS package I have taken over from a previous developer. The code has been working since the beginning of the year and now if giving us issues. The server version recently was upgraded from Windows Server 2003 x64 to Windows Serve

  Author:  mcgufbd     Date: 1/5/2012     Section: Forum

  tags : error, file
• 
  SQL Update Syntax

  I apologize for the flippant response, caught me at a bad moment in the day. Fvcdata2011, the best place to get any information like that for SQL Server is Books Online http://msdn.microsoft.com/en-us/library/ms130214.aspx Please note that Books Online co

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