20 September 2008
Vector: A Concept-Driven Approach to UDT
Introduction Have you tried searching for anything about SQL Server User Defined Type (UDT) in your favorite developer portal? More often than not, you’ve ended finding something that ultimately culminates to debates about the author’s choice of model or whether UDT does have a place in software development... Read More...
Filed under: ,
21 August 2008
SQL Server 2008 Compressed Backup
Often, most of us relied on built-in capabilities of SQL Server. In version 2005, unless we use specialized 3 rd party products, we are left with a very limited backup capability. One of the limitations that we had in 2005’s backup capability is in compression. In 2005, we cannot do a compressed backup... Read More...
14 August 2008
SQL Server 2008 RTM Installation Experience
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 for SQL Server 2008 RTM, I was able to install SQL... Read More...
08 August 2008
SQL Server 2008 RTM Has To Wait Until Visual Studio 2008 SP1
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 brand new SQL Server 2008. And last night was my... Read More...
11 September 2007
Add security to your data with Database Schema
There are more than one way of securing SQL Server 2005 database. One of which I will discuss first 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 application they outsource in software... Read More...
01 August 2007
COLLATION Revealed
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 shows the differences between sorting in... Read More...
29 June 2007
Katmai Adventure - Part 2 : User Defined Table
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 SPs and functions to accept table-like structures... Read More...
21 June 2007
Katmai Adventure - Part 1 : TSQL Enhancements
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 weeks now. In this adventure with Katmai... Read More...
09 June 2007
CRUD-Buster by Design, and A Lot More!
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 repetitive task. Some tools would generate the code... Read More...
05 June 2007
Top 5 Funny Database Designs
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 kind of design if it is called as one. Age can be... Read More...
30 April 2007
MSSQL Pros Life About To Be Shaken
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 . There are others of its kind but let us... Read More...
09 March 2007
SQL Server 2005 : Single vs Multi-DB Design, and Synonym
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 super DB for multiple inter-operating applications... Read More...
09 March 2007
SQL Server: Real Time Data Processing? When Not To ...
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 data streaming through mega bandwidth networks,... Read More...
09 March 2007
SQL Server: Avoid LIKE Like A Plague
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 first_name LIKE '%electra%' on a several... Read More...
09 March 2007
SQL Server: When Is The Right Time To Create Indexes
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 been through every time I design databases and... Read More...
More Posts Next page »