Love: A good DBA loves his data and DBMS. And like any good relationship, they communicate with each other SQL Server: “What a day! “
DBA: “What happened? “
Read more →
1) Denial Only other developers have this problem and I will be able to implement this business model into the database. After all, it has been over 35 years since “the paper“ and I am sure there is someone out there who does a decent job of it.
Read more →
Before time, space and matter, there was the infinite nameless one.. CREATE TABLE TheInfiniteOne(Name VARCHAR(?) PRIMARY KEY, CHECK COUNT(*) = 1)
INSERT TheInfiniteOne (Name) VALUES ('Nameless')
It was an impossible relation of course because time did not exist.
Read more →
My project is getting ready to roll, so data versioning has commenced.. Backup, restore, BCP etc... Digging around in the toolkit, I dredge up an old procedure I wrote for load/unload in version 7.
Read more →
The “object” type of SQL Server is hardly used and with good reason. RDBMS are meant to be “strongly typed“.. it is the foundation of the domain/type concept. RDBMS : “What are you INSERTing Dave?
Read more →
A “well done“ to the boys and girls who code the SQL Server optimser is a bit of an understatement.
A “summarising” view I created contained 3 scalar subqueries. Working against the view, I found the optimiser ignoring (not resolving) some of the subqueries.
Read more →
4 blisters, 2 bits of flesh missing and 3 splinters is the inevitable consequence of manual labor when applied to computer hands.
Sheds are cheapish (world steel prices jumped at the end of February), cement is not, so to cut costs I volunteered to be a concreter’s laborer for our new shed.
Read more →
The marketing has cranked up a gear, which would seem to indicate they are getting a good response from the betas.
Looking here (features) and here (pricing), we see 4 commercial breeds of SQL Server 2005.
Read more →
The job market in Australia is pretty good at the moment for any decent programmer/DBA. After the blood letting of post 2000, many charlatans where uncovered and removed. The days of the “Database Fix“ began.
Read more →
In my last blog, I asked the question for breaking 1NF for a particular situation involving Points.
Graz hit the nail on the head with the question about the relevance of the internal data components to the outside world.
Read more →
I am storing graphical objects in SQL Server.
A Line, Rectangle, Ellipse, Image and Text object can all be represented spatially on the drawing surface by 2 elements StartPoint and EndPoint (Point= X INT > 0,Y INT > 0).
Read more →
10 hours and counting…
Good luck and be nice to the inhabitants! Link
Legacy Comments
Brett
2005-01-21
More of Titans secrets to be unveiled on Jan.
Read more →
Financial, health, demographic, taxation, production, defence etc...There is some serious data out there all under the control of the men and women we call DBAs. Several years ago I remember being given a CD containing the entire electoral roll.
Read more →
A long time ago just down the road, no matter who asked you your name, you always gave the same reply. " I am Connor MacLeod of the Clan MacLeod."
Read more →
I am hoping this will be the first of many, but time constraints or other circumstances may alter the hope.
A desk a mate of mine built, is the main workstation which is not far from the kitchen.
Read more →
It's 2:45AM and I have been on the road for nearly 11 hours. The car is packed to and on the roof and the dogs are sleeping with one eye open.
Read more →
Just about every article and blog being written on Yukon is about XML or the CLR integration. If you didn't know better, you would swear that Yukon is just a .
Read more →
1 It is March 1st and the first day of DBMS school The teacher starts off with a role call..
Teacher: Oracle? "Present sir" Teacher: DB2? "Present sir" Teacher: SQL Server?
Read more →
I have seen several times people requesting to place a unique constraint on a column that should allow many NULLs but only allow unique values.
Personally, I have never had to implement such a constraint, and when I see the question posed I assume it is needed because of a underlying design problem.
Read more →
The Expressions that can be formulated for a calculated column in a DataTable are a very handy thing. The problem is the aggregation operators only work for a parent-child relationship. This feature really stood out when I started working with the MSDE DBMS.
Read more →