A Script A Day - Day 25 - Performance Counters
Today’s script is based on performance counters and in particular the sys.dm_performance_counters DMV. There are many ways in which to...
2012-02-29
2,320 reads
Blog Posts
A Script A Day - Day 26 - RESTART a Database Restore
Today’s script is another one based on database restores. There is a little known clause of the RESTORE DATABASE command...
2012-02-29
2,865 reads
A Script A Day - Day 27 - Missing Database Backups
Today’s script is one I have used many times in the past to check for missing backups. The script will...
2012-02-29
3,489 reads
AdventureWorks in SQL Server 2012 RC0
The sample databases for SQL Server 2012 haven’t been completely finalized, but I was able to find the latest version...
2012-02-29
1,941 reads
Azure is Down
I saw a note about an outage on Windows Azure, apparently one that’s been going on for seven hours. Once...
2012-02-29
1,751 reads
Download free eBook for SQL Server 2012
Microsoft has released one more free eBook, this time it is on SQL Server 2012. However, this is the second...
2012-02-29
3,577 reads
MERGE with OUTPUT clause
A few days back I was presented with a theoretical challenge, and now I thought I would share my solution...
2012-02-29 (first published: 2012-02-21)
9,087 reads
PASS SQLRally Dallas 2012 Pre-Con: How to Perform a SQL Server Health Check
If you are attending the PASS SQLRally this May in Dallas, I will be presenting a one day preconference session...
2012-02-29
2,524 reads
Script SQL Server Agent Jobs Using PowerShell
It’s that time of the month again, no not that one, it’s T-SQL Tuesday time and this weeks topic is...
2012-02-29
4,756 reads
SQL Server 2012 (“Denali”): Extended Events
Extended Events is a general event-handling system for performance monitoring that was introduced in SQL Server 2008. It has a highly scalable and highly configurable...
2012-02-29
2,706 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
Kontak BCA KCP Citra Raya [083178278662]
ALAMAT : Perumahan Citra Raya Blok KD.02 No. 10, 15, RW.Mardigrass, Mekar Bakti, Kec....
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
Question of the Day
Squared Values
What happens when I run this code in SQL Server 2022?
SELECT SQUARE('12') See possible answers