Find the version of the Master DB from a backup
Try researching recovering the master database online and you will see countless references to having to have SQL at the...
2012-01-25 (first published: 2012-01-20)
3,030 reads
Blog Posts
How to set the default replication agent profile
Over the last couple of years I've come to the conclusion that the default replication agent profiles just don't cut...
2012-01-25 (first published: 2012-01-22)
7,088 reads
Improving cube processing time
As your SSAS cube gets bigger, cube processing time will become a problem. This is especially true as more and...
2012-01-25
11,375 reads
Notes from 'Putting a Better SQL Server in Production' - the Ideal Pre-Prod checklist from Robert L. Davis
Last week, I sat in on Putting a Better SQL Server in Production - this is an ideal pre-prod checklist from...
2012-01-25
1,328 reads
Nothing Changes If You Don't Volunteer
http://www.flickr.com/photos/cubagallery/4690390650/
Hello Dear Reader, last time on Day's of Our Lives there was an election, some people resigned, and other's...
2012-01-25
801 reads
So then, what’s the definition of an object……..?
Not blogged for a while due to client and project commitments but something which has surprised me when speaking with...
2012-01-25
592 reads
SQL Saturday #104 Colorado Springs, CO
Janet, my girlfriend, and I went to Colorado Springs a day early, Thursday, to ski on Friday before SQL Saturday...
2012-01-25
707 reads
Venting Frustration
We as DBA’s face an ever growing list of things to do and services to support. We work in high...
2012-01-25
598 reads
Windows 8 Easy Refresh?
I saw this write up about the built in ability to both restore to factory settings as well as just...
2012-01-25
661 reads
Windows Phone 7 and epic efforts to publish applications
Reblogged from betim drenica's blog:
There is plenty of time I am developing applications for Windows Phone and…
tools are great (aka...
2012-01-25
1,210 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