Who is online?
67
guests and
0
members
Login
|
Register
home
articles
forums
blogs
did-you-know
quick tip
podcasts
files
login
about us
events
join us
write for us
newsletters
register
home
» search results
Search Results: Excel
32 results found
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
Page 1 of 2 (32 items)
<< Prev
1
2
Next >>
Go to page:
[Go]