Subscribe: A SQL Server Blog
http://blogs.msdn.com/ashvinis/rss.aspx
Added By: Feedage Forager Feedage Grade B rated
Language: English
Tags:
action  conference  database  earlier today  earlier  flop  folks  great  parameters  sql server  sql  ssis  support  team  today  working 
Rate this Feed
Rate this feedRate this feedRate this feedRate this feedRate this feed
Rate this feed 1 starRate this feed 2 starRate this feed 3 starRate this feed 4 starRate this feed 5 star

Comments (0)

Feed Details and Statistics Feed Statistics
Preview: A SQL Server Blog

A SQL Server Blog





Last Build Date: Mon, 20 Jul 2015 17:24:36 +0000

 



The impact of Gemini (Or the power of a simple question)

Wed, 08 Oct 2008 20:14:00 +0000

If you’re reading this, you’ve probably heard about Project Gemini, the Self Service Analysis capabilities to be delivered as part of SQL Server Kilimanjaro. It’s great to be able to finally share some details about what we’ve been working so hard on. We’re extremely proud of the engine that enables this experience and can’t wait to talk...



Big news at the BI Conference. Are you coming?

Tue, 09 Sep 2008 17:13:00 +0000

Hi folks, It’s been a while since I posted. I’m back in the Analysis Services team now where we’ve been busy finishing off SQL Server 2008 and working on a set of technologies that will be unveiled at the BI Conference. I remember a conference back in the 7.0 days when we introduced OLAP Services and...



Nsort is ready!

Tue, 14 Mar 2006 20:42:00 +0000

For the past few months, a few of us have had the pleasure of working with Ordinal to create an extremely performant sort component. Chris, from Ordinal, sent an email earlier today announcing that they’re done with a production ready version. This is really great news, especially if you know the history of Ordinal and...



Metadata tool and whitepaper for BI components

Wed, 21 Dec 2005 17:15:00 +0000

Hi again, Over the last few months a lot of you have expressed a need to do impact analysis and lineage investigations across the different BI components we’ve got…. if I change this table here what packages, cubes, reports will be affected. Well, earlier this week the BI team released a metadata pack that you...



Biztalk, SSIS, Indigo, SSB, AAAAA!

Mon, 14 Nov 2005 17:42:00 +0000

This is a FAQ that we get at least once every time we present. I got it last week doing launch activities in Portugal, and then earlier today on a webcast on extending SSIS. For those not familiar with the excellent whitepaper on this, check this one out: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/bts_2004wp/html/14bc36a8-69a9-48ed-8e4c-1c85202544c0.asp regards



Finally!

Thu, 27 Oct 2005 17:09:00 +0000

As you know, we just declared SQL RTM earlier today. For those familiar with the changes in this release, my goodness. This has been a huge release. I’ve had a kid along the way, some have had two. Shipping software of this magnitude is probably one of the most gratifying experiences, and I had to...



SSIS: Lookup from Text Files

Mon, 24 Oct 2005 15:33:00 +0000

Ever want to do a lookup on a text file without putting it in a database or using a merge join? Grant from the Project REAL team found a great nugget: Openrowset now allows the BULK clause to be specified which accepts a filename and format specification. An OLE-DB driver for flat-files or XML would...



SSIS: Debugging foreach NodeList enumerators

Fri, 21 Oct 2005 22:06:00 +0000

Earlier today Fred S. asked a great question. “Using the following data I’m trying to get each node Element populated into their own variables.XML:          Sales      DBCC      1            Inventory      DBCC       1   Want to do:Name   -> vsDataBase     Action -> vsAction       FLOP   -> vnFLOP                       Where vsDataBase, vsAction and vnFlop are variables of...



SISS: Providing parameters when providers don’t support them

Thu, 20 Oct 2005 14:44:00 +0000

This has come up a few times recently, and I couldn’t find the information for them in the usual sources. The desire that some folks have is to support parameters in their SQL statements. Sounds reasonable. The OLEDB source, for example, supports parameters. However, some providers don’t support derivation of parameters from a statement. The...



SSIS Best Practices – Performance

Tue, 27 Sep 2005 16:44:00 +0000

We’ve been slowly creating a list of best practices. Simon asked me about these at the PDC a couple of weeks back. It’s time to share them out not just to make folks aware of them but also to solicit other goodness you’d like us to include in the official list. First off, Performance:   [Oledb...