Teaching and Learning
You learn a lot when teaching someone else, whether that be writing articles or books or actually teaching a class....
2009-12-23
668 reads
Holiday gift for your favorite SQL Server Professional
If you have been putting off ordering your copy of "SQL Server MVP Deep Dives", now is your chance to...
2009-12-23
495 reads
The Problem with Striped Backups
I noticed a post recently from Bru Medishetty on Striped Backups. I commented, but thought I should explain a little...
2009-12-23
3,710 reads
Keyboard Shortcuts
I’m perusing things I’ve in the ‘blog about someday’ category of my list and found this one – a very nice...
2009-12-22
597 reads
Deploying Reports on Windows Seven
Recently I tried to deploy a report to a Report Server on my laptop, which is running Windows 7 Ultimate....
2009-12-22
517 reads
Apology
I’ve been somewhat light in my blogging of late. Unfortunately, I just haven’t hit any interesting or difficult problems lately...
2009-12-22
532 reads
SSIS - Single Package Deployment from BIDs
I have read several articles about deploying SSIS packages.Most focus on using the deployment wizard or simply copying the files...
2009-12-22
2,055 reads
Getting Your Blog Started
I realized that I haven’t written enough recently on this blog myself, being occupied with other projects for work. Recently...
2009-12-22
745 reads
Sql Server- Difference between Stored Procedure and Function
In Sql Server, both functions and stored procedures can be defined as the logically grouping of Sql statements formed to...
2009-12-22
2,183 reads
The Exceptional DBA’s Code of Conduct
This is a reprint of chapter 11 of my book, How to Become an Exceptional DBA, 2nd Edition, which is...
2009-12-21
735 reads
Blogs
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...
How to Check TDE Progress and Elapsed Time in SQL Server
By SQLPals
How to Check TDE Progress and Elapsed Time in SQL Server ...
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