(Siddharth Mehta) SQL Server Modeling CTP – Nov 2009 Release 2 which was formerly known as Oslo has been released and it ships with tools like Intellipad and Quadrant and also with languages like "M". In my view, these services and tools are more targeted towards .NET applications, but there are so

(Dinesh Priyankara) Geospatial Visualization is one of the key new features of SQL Server 2008 R2 Reporting Services.SQL Server provided geospatial data with SQL Server 2008 and you may have noticed (or perhaps used) the two geospatial data types in SQL Server 2008 : geometry and geography. This sup

(Tibor Karaszi) Short answer seems to be “yes”.

(Darren Green) Strangely enough for a predominantly SSIS blog, this post is all about how to perform data profiling without using SSIS. Whilst the Data Profiling Task is a worthy addition, there are a couple of limitations I’ve encountered of late. The first is that it requires SQL Server 2008, and

(Anu Chawla) SQL Server 2008 Enterprise moved forward on the compression capabilities that were introduced in SQL Server 2005 Service Pack 2. You should consider two compression technologies to reduce your database file size and to speed up your backups.

(Michael Zilberstein) Actually this post was born last Thursday when I attended Kalen Delaney’s “Deep dive into SQL Server Internals” seminar in Tel-Aviv. I asked question, Kalen didn’t have answer at hand, so during a break I created demo in order to check certain behavior. Demo goes later in this

(Jason Thomas) In many of my projects, I have heard my developers asking each other whether it is possible to get the solution file of a SSAS database and I have turned a deaf ear to almost all the cases in spite of knowing the answer. Now before you give me that flabbergasted look, let me try to ju

(Tim Cullen) The institution I work with has decided to migrate their database system to SQL Server 2008. One of the applications uses geospatial data, which consists of millions of rows. I understand that their are indexes that can be used for geospatial data, but have not worked with them. What’s

(Ami Levin) SQL Server implements three different physical operators to perform joins. In this article series we will examine how each operators works, its advantages and challenges. We will try to understand the logic behind the optimizer’s decisions on which operator to use for various joins usi

(Stacia Misner) If you have any experience at all with Reporting Services, you have probably developed a report using the matrix data region. It’s handy when you want to generate columns dynamically based on data. If users view a matrix report online, they can scroll horizontally to view all columns