THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Denis Gobo

Since A Long Weekend Is Coming Up And You Might be Bored...

Since most people in the United States do not work on Monday I decided to give you some stuff to read just in case you don't know what to do with yourself this weekend.

SQL Server 2008 Whitepapers 

There are 16 whitepapers that Microsoft has made available. Most of them are about 10 pages so it should not take that long to go through all of them

HTTP Endpoints to be deprecated in SQL Server 2008

Another one bites the dust, Notification Services is not alone after all. Bob Beauchemin has more info.

Bob Beauchemin has also two post that deal with Spatial Data: Using SQL Server 2008 spatial and the Virtual Earth map control - 1 and Using SQL Server 2008 spatial and the Virtual Earth map control - 2. The Spatial Data posts are more for people who do front end as well as back end development.

Two Interesting articles by the PSS SQL Server Engineers

How it Works: SQL Server Per Query Degree Of Parallelism Worker Count(s) and How It Works: SQL Server 2005 Connection and Task Assignments

If that is not enough for you there are also a bunch of SQL Server 2008 Webcasts available as well as a bunch of SQL Server 2008 Videos.

If you are still bored then maybe it is time for you to get out of the house  :-)

Published Thursday, February 14, 2008 1:18 PM by Denis Gobo



Geoff said:

The spatial addition is huge. I need to figure out how to model irregular polygons in the database. Zip codes, towns, states, countries, etc.

As to the weekend, I seriously suggest spending time with friends and family. Life needs balance.

February 14, 2008 12:53 PM

Denis Gobo said:

>>As to the weekend, I seriously suggest spending time with friends and family

I took of tomorrow, it is the birthday of my oldest son. After spending a couple of hours with 20 four year olds I will need to escape  :-)

February 14, 2008 12:57 PM

Geoff said:

Wow, that is balance! I think you need to go to Triumph in Princeton and grab a beer. And then go home and read whitepapers.

As to the spatial stuff, I think it would be useful if there was an easy way to put in known territories into the database. I mentioned zip codes, but I think political territories would be extremely useful. New Jersey, Mercer county, Princeton Township. Things along those lines.

Does anyone know of how an oddly shaped territory like New Jersey gets modeled/created in the database? I've done some searches, but I haven't seen anything along those lines. Not everything in life is a rectangle. Although, like computer graphics, I suppose one could model irregular shapes with lots of little polygons.

February 14, 2008 1:10 PM

steve dassin said:

This point of view is quite interesting coming from sql server white papers. The devil is in the details:)

SQL Server 2008 Product Overview

'A trend among database developers is to define high-level business objects, or  

entities, that they then map to the tables and columns stored in a database. Rather than programming against tables and columns in a database, developers use high-level  entities such as ‘Customer’ or ‘Order’ to represent the underlying data. The ADO.NET Entity Framework enables developers to program against relational data in terms of such entities. Programming at this level of abstraction is highly productive and allows developers to take full advantage of entity-relationship modeling.'

Microsoft SQL Server 2008 and Microsoft Data Platform Development

'Developers often spend countless hours deciphering database schemas and writing

complex queries to retrieve the data that they need in their applications. The ADO.NET Entity Framework simplifies these tasks and enables developers to focus on the business logic of their applications.'

'The ADO.NET Entity Framework, which is based on the Entity Data Model, enables  

developers to transform the relational data in database schemas into conceptual entities that can be used directly in applications. For example, the customer data in your application may be stored across multiple tables in a database. By using the ADO.NET Entity Framework, architects and developers can define a single conceptual customer entity that neatly abstracts the complex relations that are required to access and update customer data from an application. This layer of abstraction isolates the data access logic into a set of well defined entities that can be used in an application and the abstraction helps developers to concentrate on developing the application logic.'

Apparantly the devil like to wear 'white' dresses as well as blue dresses :)

February 14, 2008 3:53 PM

Denis Gobo said:


Regions are usually stored in the database as poly lines.  The difficult part is determining if a point is contained within a polygon

I have emailed you with additional info

February 14, 2008 4:08 PM

steve dassin said:

Oh yes, from the devil himself, Bill Gates: :)

"You should be able to do things on a declarative basis," Gates continued. But this has not caught on partially because of weak data models -- first Codasyl and then relational. Stronger data models since have emerged, such as rich schemas around XML as well as modeling work being done by Microsoft and others, Gates said. "We're bringing the data models up to be much, much richer, and we think in that environment, a lot of business logic can be done in a declarative form. Now, we haven't totally proven this yet. We're doing a lot of internal developments ourselves that way," including some Microsoft business applications, he said.



'Gates talks up declarative modeling language effort'

Now connect all the dots including those in the white papers. There's a very big picture here, is anyone listening? :)

February 14, 2008 4:10 PM

Srikanth said:

Great collection of links and i read your blog often, and thanks for refering to Bob's blog. Learned a lot today!

February 17, 2008 10:26 AM
New Comments to this post are disabled

About Denis Gobo

I was born in Croatia in 1970, when I was one I moved to Amsterdam (and yes Ajax is THE team in Holland) and finally in 1993 I came to the US. I have lived in New York City for a bunch of years and currently live in Princeton, New Jersey with my wife and 3 kids. I work for Dow Jones as a Database architect in the indexes department, one drawback: since our data goes back all the way to May 1896 I cannot use smalldates ;-( I have been working with SQL server since version 6.5 and compared to all the other bloggers here I am a n00b. Some of you might know me from or even from some of the newsgroups where I go by the name Denis the SQL Menace If you are a Tek-Tips user then you might know me by the name SQLDenis, I am one of the guys answering SQL Questions in the SQL Programming forum.

This Blog


Privacy Statement