Search Results: Excel

• 
  SQL Server blogs from Bhagwan Singh Jatav for the month of February

  Hi SQL Geeks, Here are the blog posts by Bhagwan Singh Jatav for the month of February. We would expect more of his informative blogs this month. Happy Learning! If you like our blogs do like us on Facebook at http://www.FaceBook.com/SQLServerGeeks Here i

  Author:  Admin Admin     Date: 3/1/2013     Section: Blog

  tags : Bhagwan Singh Jatav, sql server 2012 denali, sql server articles, sql server blogs, sql server content
• 
  SQL Server blogs from Suhas Kudekar for the month of August

  Hi SQL Geeks, Here are the blog posts by Suhas Kudekar for the month of August. We would expect more of his informative blogs this month. Happy Learning! If you like our blogs do like us on Facebook at http://www.FaceBook.com/SQLServerGeeks Here is a summ

  Author:  Admin Admin     Date: 9/1/2012     Section: Blog

  tags : Suhas Kudekar
• 
  Power Pivot and Power View now available in Excel 2013.

  In Excel 2013, much of that functionality, including the infrastructure that supports it, is built directly into the Data Model in Excel. Without installing a separate add-in, PowerPivot and ower View add-ins are installed by default. But they are not aut

  Author:  suhas kudekar     Date: 8/1/2012     Section: Blog

  tags : Excel 2013, Power View, PowerPivot
• 
  SQL Server - VertiPaq Engine Renamed as xVelocity in SQL Server 2012.

  VertiPaq engine is currently only available to PowerPivot for Excel in SQL Server 2008 R2. After the amazing success of PowerPivot for Excel in the previous release of SQL Server 2008 R2 this engine moved to the server side with the same InMemory BI and c

  Author:  suhas kudekar     Date: 5/24/2012     Section: Blog

  tags : SQL Server 2012, VertiPaq, xVelocity
• 
  How to Use CASE Expression in SQL Server???

  Hey Folks, you might have heard and used CASE in other languages. But SQL CASE expression is different. SQL Server’s CASE expression is a flexible and excellent means of building dynamic expressions. It is not used for programmatic flow of control,

  Author:  Piyush Bajaj     Date: 7/6/2011     Section: Blog

  tags : Boolean Case, CASE, CASE Expression, CASE expression in SQL Server, CASE in SQL Server, Searched Case, Simple Case
• 
  SQL Server Day, Bangalore, 28 July 2012, rocked us all !!!

  Hi Friends, Yet another SQL Server Day in Bangalore, yet another success story. 140+ SQL enthusiasts proved what this event means for them. On Saturday, 28 July 2012, attendees started coming in at Microsoft facility in Bangalore from 9 am onwards and wit

  Author:  Admin Admin     Date: 8/10/2012     Section: Blog

  tags : SQL Server 2012 events, SQL Server classes, sql server conference, SQL Server events, SQL Server events in India, SQL Server seminar, SQL Server workshops
• 
  SQL Server Day, Gurgaon (Delhi NCR), 8 September 2012 - 150 SQL Geeks turn up !

  Hi Friends, An unmeasurable amount of awesomenimity - SQL Server Day in Gurgaon on 8 Sep 2012 astounds all of us with 150+ SQL Geeks turning up for the event. Delhilites/Delhi NCR truly rocks ! Yet another SQL Server Day event, yet another success story!

  Author:  Admin Admin     Date: 9/21/2012     Section: Blog

  tags : SQL Server 2012 events, SQL Server classes, sql server conference, SQL Server events, SQL Server events in India, SQL Server seminar, SQL Server workshops
• 
  SQL Server: Using XLSX files in SSIS

  XLSX files, the new file type in Excel 2007/2010 can’t be open with Excel Source/Destination in SSIS. To use XLSX in SSIS we need to install ACE driver and use OLE DB Source/Destination to read read/write data in XLSX files. ACE is a set of componen

  Author:  Raksh Mishra     Date: 8/29/2011     Section: Blog

  tags : Rakesh Mishra, XLSX File Load
• 
  SQL Server 2012 - Create BI Reports from Tabular Project

  BI Semantic Model and Reporting Part 1 Hello! We at SQLServerGeeks.com are committed to spread the knowledge as we gain in the process of evaluating the newly released SQL Server 2012 CTP 3 release code named “Denali”. In this post, let’

  Author:  Raunak Jhawar     Date: 12/7/2011     Section: Blog

  tags : BI Semantic Model Reporting, BISM, DAX for Tabular Project, Measures in DAX for Tabular Project, SQL Server 2012, Tabular Model
• 
  Data warehouse(with partition) VS Data Mart.

  Hi Naveen, Apologies for the late reply. Datamart cannot do that automatically unless you create views but that would not give you good performance and Data Marta are generally not designed that way. I dont know the purpose of merging the three DBs, but i

  Author:  Amit Bansal     Date: 7/8/2011     Section: Forum

  tags : Data Mart, Data warehouse, merging tables, table partitioning
• 
  MS SQL Server Integration Services 2012 – Create New Excel File Dynamically to Export Data

  Recently I got a requirement to export error data to a newly created excel file every time the SSIS package runs. The challenge here was to create new excel file with time stamp every time the package ran and export data to that newly created file. In thi

  Author:  Bhagwan Singh Jatav     Date: 2/19/2013     Section: Blog
• 
  Business Intelligence features of SQL Server 2012 RCO- Download Virtual Machine

  Business Intelligence features of SQL Server 2012 RC0- Download Virtual Machine Hi Friends, The Base ImageX Server is a virtual machine that allows a user to test out the latest Business Intelligence features of SQL Server 2012 – RC0; including Powe

  Author:  SQLnews SQLnews     Date: 2/14/2012     Section: Blog

  tags : Base ImageX Server, Business Intelligence, SQL Server 2012 RC0
• 
  SQL Server - Data Type Conversion Options in SSIS

  Data type conversion is one of the most common tasks in any ETL process. There are several ways of data conversion in SSIS. We have Special “Data Conversion” transformation task or we can use derive column to change data type of a column or we

  Author:  Raksh Mishra     Date: 8/7/2012     Section: Blog

  tags : data type, Rakesh Mishra, SSIS
• 
  20 excel files(each file’s column names are different) to be loaded to 20 different SQL Server tables through SSIS

  Hi, I have 20 excel files(each file’s column names are different ) to be loaded to 20 different SQL Server tables through SSIS . For eg Excel file 1 : will have column name as Emp ID, First Name, Last Name. It will be loaded to Employee table Excel

  Author:  Pankaj Paul     Date: 8/29/2011     Section: Forum
• 
  SSAS 2008 R2 - Role: Dimension Data Security

  Hi, Can anyone help me out im implementing Dimension data security in Role. I have to limit the user accessibilty based on company i.e User "xyz" can see the data only for company "CEED" in Cube1. Steps followed: 1. Created a Role "Company_CEED". 2. Membe

  Author:  pallavi pallavi     Date: 2/6/2013     Section: Forum
• 
  Translations in a cube

  I have created some translations for the monthname in a cube. The translations are visible when I browse the date dimension using object explorer in Analysis Server and by changing the language to Spanish or French. 1) Is there any way to use the translat

  Author:  Lata Lata     Date: 9/27/2012     Section: Forum
• 
  Creating Multiple excel files by dynamically by using SSIS

  See this thread, http://www.sqlservergeeks.com/forums/microsoft-data-platform/sql-server-bi/102/20-excel-files-each-file%E2%80%99s-column-names-are-different-to-be-loaded-to-20-different-sql-server-tables-through-ssis

  Author:  Amit Bansal     Date: 9/2/2011     Section: Forum
• 
  20 excel files(each file’s column names are different) to be loaded to 20 different SQL Server tables through SSIS

  Thanks Navratan for sharing the code. 1. I have Windows 7 and SQL Server 2008 R2 and the code is not running :( I changed to below code but still not executing. declare InsertDept cursor for SELECT DeptId,DeptName FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0

  Author:  Pankaj Paul     Date: 9/5/2011     Section: Forum
• 
  SQL Server - Locking webcast delivered - Index tuning coming up

  Hi Friends, 21 st Feb 2012 was a special day for me; we had our maiden webcast of SQLServerGeeks.com and I was delighted to see 120+ people turning up for the webcast. I talked about Locking Internals with some crisp demos and the audience loved it. This

  Author:  Amit Bansal     Date: 3/10/2012     Section: Blog

  tags : sql server events india, Sql server webcast
• 
  SQL Server: DBCC PINTABLE does nothing anymore

  Hi Friends, In one of my recent assignments, one participant asked if there is any way in SQL Server to warm up the cache of with some heavily used tables to achieve better performance. Which means, he wanted to load the data pages of a particualr table b

  Author:  Amit Bansal     Date: 8/31/2011     Section: Blog

  tags : DBCC PINTABLE, DBCC UNPINTABLE
• 
  What is the need of Common Language Runtime (CLR) in SQL Server?

  Hey Folks, Do you really know, why there’s a need of Common Language Runtime (CLR) required instead of having T-SQL? Well I have some keynotes here: Transact-SQL is specifically designed for direct data access and manipulation in the database. As Tr

  Author:  Piyush Bajaj     Date: 6/15/2011     Section: Blog

  tags : CLR, Common Language Runtime
• 
  Configuring SQL Server 2012 Denali SSAS Engine in tabular mode

  Configuring SQL Server 2012 Denali SSAS Engine in tabular mode Hello! We at SQLServerGeeks.com are committed to spread the knowledge as we gain in the process of evaluating the newly released SQL Server 2012 CTP 3 release code named “Denali”.

  Author:  Raunak Jhawar     Date: 11/22/2011     Section: Blog

  tags : Analysis Services, BIDS, Business Intelligence, Excel, MDX, PASS, PowerPivot, Reporting Services, SQL Server 2012, SSAS, SSAS Tabular Mode, SSAS Tabular Project, UDM
• 
  A Deep Dive into Transactional Replication

  A Deep Dive into Transactional Replication;Replication without a Snapshot;Proper Backups of Indexes and Statistics for Optimal Performance of the Reporting SQL Server.

  Author:  Satnam Singh     Date: 7/4/2012     Section: Article
• 
  Getting time for each log

  Excellent reply Amit

  Author:  Amit Bansal     Date: 6/12/2011     Section: Forum
• 
  Insertion and updation of Data using SSRS2005

  Amit, excellent !!! would love to see something like that. It would be really nice if you can write a small article and post it in articles section. Regards Amit

  Author:  Amit Bansal     Date: 3/31/2011     Section: Forum