SQL Server BI & SharePoint eBooks, Guides and Resources
There are many free eBooks & resources available from Microsoft and members of the MVP community. This is a collection of...
2012-08-10
1,350 reads
Blog Posts
Standing Desk – Flooring
My standing desk experiment has worked out well. I have gotten used to standing there and I’ve slowly found places...
2012-08-10
1,203 reads
Tampa Code Camp Announced
The next Tampa Code Camp will be held October 13 at University of South Florida, 4202 East Fowler Avenue,Tampa, FL...
2012-08-10
492 reads
August 2012 – Monthly SQL Server Checklist
Summer is beginning to wrap up for those of us in the northern hemisphere and were finally to August. Maybe...
2012-08-09
1,153 reads
Don't Use Passwords That Can Be Social-Engineered
A Facebook thread by one of my friends brought this one to mind. He was asking about what the current...
2012-08-09
1,948 reads
Excluding Schemas in SQL Compare
I saw this question posted the other day and thought it was a great idea.
I haven’t been a big...
2012-08-09
2,415 reads
Forcing network protocol to connect SQL server
Whenever there is a network issue or a SQL server browser issue we might need to connect SQL server in different...
2012-08-09
1,242 reads
How to prevent ‘Select *’ : The elegant way
UPDATE 2012-09-12 For my latest adventures with TSQL Parsers please see this post.
I’ve been doing a lot of work with the...
2012-08-09
1,987 reads
Lenovo’s Cancellation Policy is not consumer-friendly
I recently placed an order for a ThinkPad W530 from Lenovo. One day before the estimated shipping date, I noticed...
2012-08-09
3,381 reads
Nacho Mama’s Training Class
That is what I wanted to name the new training series that we developed at my employer, Perpetual Technologies (PTI.net)....
2012-08-09
1,016 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