2007-10-11
520 reads
Editorials
2007-10-08
67 reads
The Train to Katmai
We don't have a release date, the final feature set has yet to be released, but slowly I can see the train building steam. This week I found a number of blogs starting to look at various aspects of SQL Server 2008. If you look through the newsletter, you'll see coverage of data compression, clustering […]
2007-10-08
113 reads
The Value of Information
If I have accomplished anything, it is because I have stood on the shoulders of giants.
2007-10-03
160 reads
Seamless Upgrade
One of the things mentioned in a keynote at the recent PASS conference was the idea that SQL Server 2008 would be a seamless upgrade. Or maybe I misunderstood and it will seem less like an upgrade 🙂
2007-10-02
247 reads
Compliance
The Sarbanes-Oxley act has become a four letter word to many IT people in the US. Thankfully I only had to deal with it for about 9 months before I left to go work on my own, but it was a long 9 months. Especially since I did half the work with JD Edwards and then did it again with Peoplesoft 🙁
2007-10-01
255 reads
2007-10-01
484 reads
What Should A DBA Be Doing?
I came across an interesting blog post on jobs, which actually caught me eye after another blog on time spent on various things, many of which are not necessarily important to your business.
2007-09-27
2,381 reads
The September Energy Update
I think you'll be happy to know that there are interesting people out there. One of my neighbors, maybe a couple miles away, has a windmill that I've watched run regularly as I drove my daughter to school all last year. I finally grabbed their address one day and wrote them a letter, not wanting to just walk up to their door with a list of questions. I waited patiently for a couple weeks and finally got an email.
2007-09-26
173 reads
Free Training
I heard on Thursday a couple weeks ago that someone who had received a free admission to the PASS conference had cancelled and wasn't able to attend. It was last minute and that pretty much ruled out any chance to have a contest, so I called a friend in Denver who's a DBA and doesn't get much of a budget for training. I offered him the admission and he said he'd let me know Friday.
2007-09-25
1,437 reads
Blogs
How to Run Databases on Kubernetes: An 8-Step Guide
In this step-by-step tutorial, learn how to run MySQL, PostgreSQL, MongoDB, and other stateful...
Episode 11 of Simple Talks: Oracle
By Steve Jones
The 11th episode is now live, recorded a few weeks ago at the PASS...
A New Word: Mornden
By Steve Jones
mornden – n. the self-container pajama universe shared by two people on a long...
Forums
What is the best index strategy for a table that gets truncated?
Hi everyone My SSIS package does a bulk insert of csv files into a...
Blob Storage automated downloads
Dipping my toes into the waters of Azure and of course before I get...
Question of the Day
Running Steve's Code
Can you run this code in any of your SQL Server 2019 databases without error?
CREATE OR ALTER PROCEDURE [dbo].[StevesAmazingProc]
AS
SELECT Consumer_ID ,
Trend_Category ,
Bit_Trace
FROM NewWorldDB.dbo.MarketTrend;
GO See possible answers