|
|
Front Page News
-
|
Great! Two of my development machines are now on SQL Server 2008 RTM. Earlier, the absence of Visual Studio 2008 SP1 was somehow the show stopper for me. However, upon further experimentation on the machines that were available to me which were readied...
|
-
|
It’s been 2 days since Katmai RTM’d. I have downloaded a 3GB+ ISO of SQL Server 2008 Developer Edition. Days prior to the RTM release, upon sensing that Katmai code is about to go gold, I have already readied my laptop, reformatted it, to accomodate the...
|
-
|
There is more than one way of securing SQL Server 2005 database. One that I will discuss is by means of Database Schema. I got first hand experience with this feature of Sql Server 2005 when one of our corporate customers have policy on Schema on every...
|
-
|
Well, just in case you happen to develop applications that are so particular with sorting characters. You might want to check this out. Supposing here is your data source from dbo.person: Name ----------- A B SIYV SIY-Y 1 1A 1B B1 A1 A. A- .A -A The following...
|
-
|
I had time to get back with Katmai earlier and explored it further. There was one item that caught my attention that I missed to discuss in my first blog on Katmai . In that blog, there was a feature refered to as Table Valued Parameters (TVP) which enables...
|
-
|
As we all know, SQL Server 2008 (codenamed "Katmai") has been made public more than a couple of weeks ago. The June CTP was quite a huge ISO download @ 840MB. With my limited time, I have managed to install and played with Katmai for about a couple of...
|
-
|
In most applications development, CRUD (Create-Update-Delete) is the most prevalent task we often hate to do as it requires us to do it over and over again. We have seen tools that provide us an automated way in handling this very easy, yet very pesky...
|
-
|
I just got over an old notebook of mine and saw that I have compiled some things to avoid when designing my databases. And it made me laugh. Check out the list, you might be guilty of doing one of these. #1. Age and BirthDate Columns. I always see this...
|
-
|
There has been quite a lot of commotion lately in the life of some DB Pros caused by tools such as NHibernate and a related tool from Microsoft that was “planned” for release with Orcas (the upcoming version of Visual Studio) known as ADO.NET Entity Framework...
|
-
|
Some years ago, we had a major decision to create one super DB for our product, a suite of applications. We though it was the right decision. It was a good decision but we never realized the non-technical implications of having such design. Having a single...
|
-
|
During these times when we have the likes of Google, Yahoo, and Ebay, CNN where-in their massive Internet applications and services are run in mammoth data centers filled with thousands of powerful servers ready to process millions of users request and...
|
-
|
What is the best thing about using LIKE operator in T-SQL? It is very convenient to use in doing some few pattern searching. Many of us are using LIKE just for this reason alone. For example, running the following query SELECT first_name FROM _name WHERE...
|
-
|
This case was raised to me by my colleagues in the company. I thought it would be nice to write it on my weblog. This isn’t a technical article but rather a reflection on when I think is the right time to create indexes based from the experiences I have...
|
-
|
It's been a while since I have posted something here. I was able to got some time to check out again some features of SQL Server which I have been eager to explore. I have been waiting for this eversince I experimented on it in version 2000. Ever heard...
|
-
|
One colleague of mine raised some intriguing points on why SQL Server's User Defined Datatypes can't be edited. You do the editing process by dropping the datatype and recreate the new one. His position was that, he avoided using UDDs simply because of...
|
|
|
|