Stupid DBA Tricks
Well, I just learned a valuable lesson about something you should not do as a DBA…
About a month ago, a...
2009-10-04
4,337 reads
Glenn Berry
SQL Server MVP Deep Dives Book available for pre-order
The "SQL Server MVP Deep Dives" book that I wrote two chapters for is up for pre-order. This will be...
2009-10-02
617 reads
More Evidence Why You Should Avoid Lots Of Conditional Logic In Stored Procedures
Gail Shaw, who is a SQL MVP from South Africa, has an excellent blog post about this subject.
The executive...
2009-09-25
812 reads
New Cumulative Updates For SQL Server 2008
Yesterday, Microsoft released SQL Server 2008 SP1 CU4, which is Build 2734, and SQL Server 2008 RTM CU7, which is...
2009-09-22
643 reads
Intel Westmere-EP Screenshots
CPUID.COM, which hosts the wonderful CPU-Z utility, has a post up that shows where someone has taken a screenshot of...
2009-09-20
774 reads
Memories Of PanzerBlitz
Back when I was a small tyke, I vividly remember playing an Avalon Hill board game called PanzerBlitz, which was...
2009-09-11
1,082 reads
Proper T-SQL Stored Procedure Formatting
Here is a very good blog post from Aaron Bertrand (another SQL MVP) on how to write and format stored...
2009-09-04
942 reads
Nice Discounts On Microsoft Certification Exams From Prometric
Prometric is offering 15% or 20%, or 25% off on selected Microsoft certification exams. The lower level Technology Specialist (TS)...
2009-09-02
601 reads
Shameless Self Promotion
NewsGator’s marketing department put up a nice post yesterday mentioning myself and Dan Larson, who are both Microsoft MVPs. I...
2009-08-27
675 reads
Upcoming Microsoft Gadgets
Microsoft has finally officially announced the long rumored price cuts for the XBox 360 Elite, which will go down from...
2009-08-27
645 reads
Blogs
RANK() vs DENSE_RANK(): #SQLNewBlogger
By Steve Jones
I haven’t done one of these in awhile, but I saw an article recently...
Using CAT for Testing of Data Agents
In last months one of the scenarios where you can use AI has been...
Are you getting value from your reporting?
By ChrisJenkins
Do you spend so long manipulating your data into something vaguely useful that you...
Forums
Creating JSON II
Comments posted to this topic are about the item Creating JSON II
Engineer Lessons
Comments posted to this topic are about the item Engineer Lessons
Question of the Day
Creating JSON II
On SQL Server 2025, what happens when I run this code:
SELECT JSON_OBJECTAGG( N'City':N'Denver' RETURNING JSON) GOSee possible answers