The Multiple Instance Dilemna
SQL Servers seem to proliferate in many companies, making management a headache for DBAs. Steve Jones asks a Friday poll about how you handle all those service account.
2008-06-27
315 reads
Editorial
2008-06-26
270 reads
Scary Questions
I spent most of my time at TechEd two weeks ago, volunteering to answer attendee's questions at Microsoft's SQL Server 2008 booth.
2008-06-25
349 reads
Dataphor
Over the years, there have been several attempts to turn conventional RDBMSs into object relational databases, by inserting an intermediate layer. The driving force behind this was the generally-held assumption that the relational model could not handle complex data types.
2008-06-24
270 reads
The Back Door DBA
Steve Jones is taking well-earned break. In his guest editorial slot, Brad McGehee discusses three simple techniques to help DBAs manage their time more effectively.
2008-06-23
551 reads
Rules, Defaults and the SQL Standard
I see, with some relief that the threatened removal of Rules and Defaults in SQL Server 2008 hasn’t happened. There has been a stay of execution. Even though they are documented, they still come with a dire warning that they are deprecated and will be removed in future versions. They have fallen foul of the SQL Standards committee, and we are now supposed to use check constraints instead.
2008-06-23
170 reads
2008-06-20
193 reads
In The Zone
Are you in the Zone at work? Can you find those times when you are amazingly productive? Tim Mitchell asks a question in this guest editorial.
2008-06-19
94 reads
Double Check
Steve Jones looks at the positive side of someone else doing your work when you're on vacation. There's an interesting benefit for the company.
2008-06-18
129 reads
The Green Stuff
Money. It's part of the reason why we all work, though hopefully not all of it. Steve Jones comments a bit on financial matters.
2008-06-17
125 reads
Blogs
Monday Monitor Tips: CIS Compliant
By Steve Jones
A new feature added to Redgate Monitor Enterprise automatically. CIS compliance is something many...
My 2024 in Data: Music
By Steve Jones
This is my last week of the year working (I guess I come back...
A New Word: Suente
By Steve Jones
suente– n. the state of being so familiar with someone that you can be...
Forums
String Variable and sp_executesql
I am not understanding why this command completes "successfully" and it seems correct to...
printing complete path
get-ChildItem C:\ -recurse -erroraction silentlycontinue | sort length -descending | select -first 10 FullName,length...
Question of the Day
Superseded Indexes
Which of these indexes is superseded by another?
See possible answers