SQL Express and the Curse of the Perfmon Counters
On a dark and spooky night in the land of SQL Server make-believe, a young warrior was asked to slay...
2012-02-05
1,150 reads
Blog Posts
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
69 reads
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
489 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,565 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,668 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
938 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,085 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
571 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,176 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,602 reads
Blogs
Automated SQL Server Benchmarking with HammerDB and Docker: A Complete Testing Framework
I’m excited to announce the release of a new open-source project that fully automates...
T-SQL Snapshot Backups on Availability Group Secondary Replicas
One of my favourite features of SQL Server 2022 was the T-SQL Snapshot Backups....
The Book of Redgate: Hours
By Steve Jones
I have said and written this many times: Redgate Software is the type of...
Forums
AI Experience Gap that we keep talking about
Comments posted to this topic are about the item AI Experience Gap that we...
Squared Values
Comments posted to this topic are about the item Squared Values
I Don't Want To Do XX
Comments posted to this topic are about the item I Don't Want To Do...
Question of the Day
Squared Values
What happens when I run this code in SQL Server 2022?
SELECT SQUARE('12') See possible answers