(Marcin Policht) SQL Server 2008 Integration Services offers a variety of ways to access Excel-based data. The most popular ones (such as Export and Import Wizard, Data Conversion Transformation, or Derived Column Transformation, which we have already presented on this forum) are quite straightforwa
Other News
Living with SQL’s 900 Byte Index Key Length Limit
(Bart Duncan) We recently had a situation where we needed to interface with an external non-relational data source that happened to use really long strings to identify entity instances. These identity strings had theoretically unbounded length, but in practice they were never more than 1000-2000 cha
Distributed Data – Opportunity for MS?
SSWUG.Org Virtual Workshop: Query Plans and Processing This Friday from AM – AM PST Here’s your opportunity to get a handle on making your queries work for you. Kalen Delaney, a name well known for things SQL Server will be hosting this workshop. That alone makes it worth the time. This is definitely the real thing. Kalen provides authoritative, in […]
Internationalization in SQL Server
More, smaller databases? Manage your checklists, our featured blog of the week for business intelligence…Also, the hotmail outage and SQL Server, 3rd party tools and more. [Watch the Show] Special Fireside Version: SelecTViews – SQL Server 2011 upcoming features, SQL Server tip, recent news and more. [Watch the Show] Devin Knight on the show today talking about dynamic security inside […]
REST: Preferred architecture and infrastructure for Web applications
(Jack Vaughan) It is debatable, but Java application servers may be said to have formed the first general off-the-shelf integration infrastructure. The earliest architecture of application servers was very much driven by Web application needs – more so as the Web itself became the most essential inf
Using the ASP.NET Cache to cache data in a Model or Business Object layer, without a dependency on System.Web in the layer – Part One.
(Robin Hames) ASP.NET applications can make use of the System.Web.Caching.Cache object to cache data and prevent repeated expensive calls to a database or other store. However, ideally an application should make use of caching at the point where data is retrieved from the database, which typically i
LINQ to XML Sorting
(Suprotim Agarwal) In this post, we will read data from the XML file using LINQ to XML, sort it by an element and then load it into a Dictionary.
Using ColdFusion Custom Tags To Help Explore Complex Regular Expressions
(Ben Nadel) At the beginning of March, I’m giving a talk on Regular Expressions at Scotch on the Rocks – Europe’s premier ColdFusion conference. If you have followed my blog for any time, you know that I think regular expressions are some kind of wonderful; I’ve even played around with ColdFusion cu
Summation over a bit data type column
One of the readers asked this question: “I have inherited a legacy application in which one of the columns in a table is declared as a bit data type.
VS 2010 SP1 and SQL CE
(Scott Guthrie) Last month we released the Beta of VS 2010 Service Pack 1 (SP1). You can learn more about the VS 2010 SP1 Beta from Jason Zander’s two blog posts about it, and from Scott Hanselman’s blog post that covers some of the new capabilities enabled with it. You can download and install t