The Phantom DBA
This week Steve Jones has a poll about the difficulties in getting the DBA position into companies. What's your current opinion of this profession?
2010-06-25
311 reads
Editorials
Dinosaur Databases
Do you work on a database system that's a dinosaur? A recent article called out RDBMSse as dinosaurs, but Steve Jones doesn't think that's correct.
2010-06-24
416 reads
The Schema Debate
There was quite a bit of debate over the use of schemas recently on the Internet. Steve Jones talks about some of the reasons why you might want a schema, and a few reasons why you might not.
2010-06-22
638 reads
Making Your Career Go Further
Steve Jones comments on a few things that can help you, and are worth keeping in mind as you interact with people.
2010-06-21
249 reads
Moving to the Cloud
There has been a lot of talk about moving to cloud based computing, and cloud based services. Steve Jones comments on what this might mean today.
2010-06-21
312 reads
2010-06-18
263 reads
Selling Used Cars
Today we have a guest editorial from Andy Warren that looks at the value of experience.
2010-06-17
209 reads
Archive Backups
The need to archive data is becoming more and more important as data sizes grow. However when you choose to archive data, you might need to reconsider how your DR plan is structured.
2010-06-16
247 reads
Google FUD
A recent headline that Google is dumping Windows because of security issues sounds like FUD to Steve Jones.
2010-06-15
229 reads
A new IDE for SQL Server?
Microsoft have been cooking up something for Database Developers in Visual Studio 2010, and Phil Factor has decided it's high time he looked into it. It's not as odd as it sounds, and is actually rather promising, as Phil discovers.
2010-06-14
371 reads
Blogs
Learn Better: Pause to Review More
By Brian Kelley
If you want to learn better, pause more in your learning to intentionally review.
Azure SQL Managed Instance Next-Gen: Bring on the IOPS
By John
If you’ve used Azure SQL Managed Instance General Purpose, you know the drill: to...
SQL, MDX, DAX – the languages of data
By DataOnWheels
Ramblings of a retired data architect Let me start by saying that I have...
Forums
Two foreign keys to the same table. Can't cascade deletes.
Not sure if this is really a relational theory question but it seems about...
Connecting Power BI to SSAS and effective user not working
Hi everyone, Below is a consolidated summary of what we validated Architecture & data...
High Availability setup - has anyone seen this method?
Hi all, I recently moved to a new employer who have their HA setup...
Question of the Day
Encoding URLs
I have this data in a SQL Server 2025 table:
CREATE TABLE Response ( ResponseID INT NOT NULL CONSTRAINT ResponsePK PRIMARY KEY , ResponseVal VARBINARY(5000) ) GOIf I want to get a value from this table that I can add to a URL in a browser, which of these code items produces a result I can use? See possible answers