A Script A Day - Day 2 - Database Mail Troubleshooting
Today's script is a collection of simple queries I have saved for a time when I need to troubleshoot database...
2012-02-02
490 reads
Blog Posts
PowerPivot for Excel Install Issues
At one of my customers, we had a very frustrating experience while trying to get PowerPivot for Excel (SQL Server...
2012-02-02
992 reads
Returning Results from an Insert – OUTPUT clause
I needed to return an identity value recently from an insert for use in another piece of code. For a...
2012-02-02 (first published: 2012-01-30)
3,596 reads
SmartPaster
I recently discovered this great little free Visual Studio Add-in that allows pasting text as preformatted strings in VB or...
2012-02-02
823 reads
Speaking for Baton Rouge UGs and SQL Lunch Next Week
I have been quiet over the past year trying to get acclimated to my new job and my new found...
2012-02-02
392 reads
SQL Server – COPY TABLE from another SQL Server
To copy a table from another SQL Server Instance is easy. Create a Linked Server on the destination server and...
2012-02-02
1,019 reads
2012-02-02
31 reads
2012-02-02
10 reads
2012-02-02
9 reads
2012-02-02
6 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