Point-Counterpoint - Why you Should be Certified.
In this view, Steve thinks that certifications are invaluable (especially in this economy).
Point-Counterpoint - Why You Should NOT Certity.
Andy Warren thinks certifications are worthless. That's opinion came after he obtained his MCDBA and MCSE certification. Find out why he thinks you should not be certified in this debate with Steve Jones.
Point-Counterpoint - Certification Debate
A new series on SQL Server Central - Two of our regular columnists take opposing looks at certification. In our first of the series, Steve Jones takes on Andy Warren in a certification debate.
THE PROGRAMMER'S QUICK GUIDE TO THE LANGUAGES
A brief description of some well known, and not so well known programming languages. Have you worked with any of these?
PASS Chat on SQL Server 2000 SP2 BETA Today!
PASS Chat on SQL Server 2000 SP2 BETA Post Mortem this week! Your peers will be there - Don't miss the chance to get involved! PASS Chats are exclusively co-hosted with Microsoft TechNet.
SQL Server 7.0 Undocumented Extended Stored Procedures
A few stored procedures that are not documented in SQL Server 7.0, but may come in handy for DBAs
Worst Practices - Assigning Users Rights
Continuing with Andy Warren's series on Worst Practices for a DBA, Steve Jones joins in this week with his worst practice.
DBA Job Description: What type of DBA are you?
One of the common questions that Brian Knight sees in the newsgroups is what is a DBA officially supposed to be doing? In this article, Brian covers the many hats a DBA can and does wear.
Certification Counterpoint - Why You Should NOT Certity
In this article, Andy Warren presents his views on why obtaining certification is not a good idea. Read this one and the one by Steve Jones that supports certification - which has the more compelling argument
Blogs
When Read Committed Snapshot Goes Bad – Version Store Filling TempDB
We all had those calls, it’s the middle of the night and we get...
Daily Coping 17 Jun 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
#PowershellBasics: Finding a common AD group for a set of users.
A while back (almost 7 years ??) I wrote a post on finding the...
Forums
UniqueIdentifier as Primary Key, non-clustered index, fragmentation issue
I've been working a little bit with a few tables here, they've got "CreatedDate"...
Multiple deadlocks occuring on simultaneous deletions from temporal table
We have a stored procedure which is attempting to delete 1-2 rows at a...
Foreign key for Xml Datatype
Is foreign key constraint possible in xml data type? OR Is it possible to...
Ask SSC