This editorial was originally published on Oct 9, 2007. It is being re-run as Steve is traveling. When I worked at JD Edwards, one of the goals of our business intelligence system was to house a single view of the truth. I recently saw a blog post by Andrew Fryer that does a good job of explaining what this actually is.
2012-07-12 (first published: 2007-10-09)
538 reads
In my last encryption post I showed how to encrypt and decrypt data with a symmetric key. However there was...
2012-07-11 (first published: 2012-07-03)
3,401 reads
Why don’t we have a function like the one in this article to convert from time zone to time zone?...
2012-07-10
957 reads
This coming weekend is SQL in the City – London 2012. Friday, July 13, and Saturday, July 14, I’ll be at...
2012-07-09
991 reads
This Friday Steve Jones asks what resources might help the new DBA learn to program better. Pick the language of your choice and let us know what resources have worked well for you.
2012-07-06
303 reads
The cloud can be good or bad for your company, but it can easily be a costly endeavor that doesn't save you money. Steve Jones some data analysis is needed to ensure you have a cost effective cloud infrastructure.
2012-07-05
139 reads
It’s been almost a month since I started the Standing Desk experiment. My first setup was down in the basement,...
2012-07-05
1,124 reads
Here you go. The raw ones.
It’s a holiday, and usually I’m spending time with the family and enjoying the...
2012-07-04
1,106 reads
2012-07-04
70 reads
2012-07-04
3,465 reads
By Steve Jones
anderance – n. the awareness that your partner perceives the relationship from a totally...
By gbargsley
We’ve all been there. Someone walks up and asks, “Is SQL Server having issues?”...
By Chris Yates
In the beginning, there was OLTP – Online Transaction Processing. Fast, reliable, and ruthlessly...
Hello, I think I need a recursive cte query but unsure of the logic....
Comments posted to this topic are about the item The Security of Old Tech
True or False: Tables with a SPARSE column consume more space than regular columns if most values are NOT NULL.
See possible answers