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.
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.
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 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.
A few stored procedures that are not documented in SQL Server 7.0, but may come in handy for DBAs
Continuing with Andy Warren's series on Worst Practices for a DBA, Steve Jones joins in this week with his worst practice.
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.
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
Steve Jones presents his case for why certifications should be required. Read this and the counter point article by Andy Warren to hear the other side of this argument - then post your comments
I’m hosting a free webinar at MSSQLTips.com at the 19th of December 2024, 6PM...
By Steve Jones
I looked at row_number() in a previous post. Now I want to build on...
Recently I received a cry for help over Teams. The issue was that an...
How to merge two tables with unlike fields. I have two table with one...
Hello, First of all, I find it odd/annoying that I can't exclude a Project...
Hi - I'm looking for advice regarding the best & quickest way to establish...
I have this data in a SQL Server 2022 table:
player yearid team HR Alex Rodriguez 2012 NYY 18 Alex Rodriguez 2013 NYY 7 Alex Rodriguez 2014 NYY NULL Alex Rodriguez 2015 NYY 12 Alex Rodriguez 2016 NYY 9If I run this code, what are the results returned in the hrgrowth column?
SELECT player , yearid , hr , hr - LAG (hr, 1, 0) IGNORE NULLS OVER (ORDER BY yearid) AS hrgrowth FROM dbo.playerstats;See possible answers