An error occurred while executing batch. Error message is: Arithmetic Overflow
Recently an incident came across my desk where an end user was receiving an error trying to retrieve some records...
2014-07-31
2,498 reads
Log Shipping - Exclusive access could not be obtained because the database is in use
This story began as they almost always do - with a page at 4am local time...
--
'Alert: SQL Failed Jobs on InstanceName...
2014-07-31
10,842 reads
Please open this page in the Admin panel only
I am taking a slight deviation from the usual type of posts that I share. This time, I just want to share a quick and easy fix that I...
2014-07-30
8 reads
Please open this page in the Admin panel only
I am taking a slight deviation from the usual type of posts that I share. This time, I just want...
2014-07-30
1,401 reads
This Week in Awesome – Running at PASS, Cookie Jail, SQL Sats, Breakfast
If you’re in Seattle the week of November 2 – say, for example, you’re attending the PASS Summit that week – consider...
2014-07-30
1,036 reads
Building The SQLSaturday Orlando Marketing Plan–Part 27
Notes:
Email with the schedule went out this week, nice bump in registrations – we’re at 229 todayMailed the list twice (bad)...
2014-07-30
1,060 reads
PASS SQL Saturday in Parma
This year, 22 November, PASSSQL Saturday will come to Parma, my birth town. I’m proud to be the organizer of that event.Our community,...
2014-07-30
965 reads
The clustered index columns are in all of the non clustered indexes.
Did you know that whatever columns you pick as your clustered index will be included in any non clustered indexes...
2014-08-07 (first published: 2014-07-30)
9,434 reads
Top 10 Recommended Books…
So the title says it all, right? Well, only really partially. Recently an article was published listing the top 10 most recommended books for SQL Server. That’s the part...
2014-07-29
10 reads
Top 10 Recommended Books…
So the title says it all, right? Well, only really partially.
Recently an article was published listing the top 10 most...
2014-07-29
1,157 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