Thread Synchronization/Locking In .Net
When you are creating multiple threads that need to access a shared resource then you need to implement some form...
2012-02-05
63 reads
Blog Posts
A Script A Day - Day 4 - Estimated Time Left
Today's script allows you to keep track of how long left a statement has before it completes. I find this useful...
2012-02-04
484 reads
Dundas Dashboard – My observations
Dundas Data Visualization Inc, is well-known to SSRS developers. Microsoft had earlier acquired their SSRS controls (Charts, Gauges & Map) and integrated...
2012-02-04
1,549 reads
List SQL Server Instances using Powershell and Get-ItemProperty
This post explains how to list SQL Server Instances installed on the current server, using the Powershell Get-ItemProperty Cmdlet.
The Get-ItemProperty...
2012-02-04
2,654 reads
Sarasota IT Pro Camp
Join system administrators IT professionals and database professionals in addition to managers at all levels who work with Microsoft technologies...
2012-02-04
932 reads
..This operation must be performed in the master database."
"Cannot alter a server audit from a user database. This operation must be performed in the master database."
If you're trying...
2012-02-03
1,073 reads
A Script A Day - Day 3 - Live Change Data Edit Template
Today's script is a template I use for the occasions when a data edit is required to be run against...
2012-02-03
564 reads
AMD 2012-2013 Server Roadmap
AMD had their 2012 Financial Analyst Day today, which is basically a dog and pony show for stock analysts.
Previously,...
2012-02-03
1,168 reads
Atlanta MDF Presents Three Awesome Pre-Cons in Atlanta April 13, 2012
Atlanta MDF presents:
SQL Saturday #111 Pre-Conference Sessions
SQL Saturday is coming back to Atlanta on April 14, and once again, we’ve...
2012-02-03 (first published: 2012-02-01)
1,595 reads
Delivering Three PTI SQL 2012 Firestarter Webcasts
I have been given the opportunity to deliver a few webcasts about some of the new features of SQL Server...
2012-02-03
1,349 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
Does factory reset get rid of viruses on Android and iPhone devices?
A factory reset will also eliminate viruses and malware on both Android smartphones and...
Creating JSON II
Comments posted to this topic are about the item Creating JSON II
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