CREATE DATABASE – I’ve not seen that before.
TweetG’day,
It’s been a while
I thought that I’d make a quick blog post about an incident that I encountered today...
2017-01-22
1,002 reads
Marty
- Interests: Playing Guitar, Music Theory
- Website: http://martincatherall.com/
What’s happening in Asia Pacific?
TweetG’day,
I really am going to make an effort to blog more, and this post is really the start of that.
I...
2015-09-30
1,190 reads
TSQL Tuesday #68 – backup checksum default
Tweet
G’Day,
Well it seems like TSQL Tuesday #68 is providing me with a real good reason to get back into my...
2015-07-07
1,380 reads
More Azure SQL Database Enhancements – Meet RLS (cloud first debut)
TweetG’day,
Well, it was only a few days ago that I blogged about some major Azure SQL Database enhancements. Primarily, in...
2015-01-30
2,319 reads
2014 – A year in review.
TweetG’day,
And so another year passes, and as I’ve never wrote a “year in review” post before now seems like a...
2014-12-31
1,346 reads
I’ve joined the SQL SERVER MVP community – Thank you!
TweetG’Day,
Today I awoke to find an email from Microsoft informing me that I’d been awarded an MVP. Wow.
I had to...
2014-10-01
1,100 reads
A real life table variable performance problem.
TweetG’day,
I’m sure we’ve all heard and read about the differences between table variables and temporary tables. In case you haven’t...
2014-09-30
2,111 reads
SQL Saturday #316, MVP’s, MCMs and a baby.
TweetG’Day,
Saturday June 14th 2014 seen the Christchurch, New Zealand SQL SERVER user group host its second SQL Saturday (#316).
We learnt...
2014-06-27
1,404 reads
Import export wizard at the commandline
TweetG’day,
Well, it seems like even if you’ve worked with SQL SERVER for a while, you’re always lightly to learn something...
2014-05-12
1,818 reads
Two IDs, One database and a Magic Number (and maybe even an empty string)
TweetG’day,
I noticed something odd recently when looking at sys.dm_exec_requests. Specifically the system processes listed in that DMV – well at least...
2014-03-26
1,347 reads
Blogs
“We love to debate minutiae”
By Brian Kelley
I am guilty as charged. The quote was in reference to how people argue...
Advice I Like: Knots
By Steve Jones
Learn how to tie a bowline knot. Practice in the dark. With one hand....
Shifting Mindsets: Why FinOps is Essential for Cloud Efficiency
By HeyMo0sh
As a DevOps practitioner, I’ve always focused on performance, scalability, and automation. But as...
Forums
how to write this query?
Hi everyone I asked this earlier but the desired outcome is a bit different...
Windows logins for users migrated from DomainA to DomainB
Hi, I have a SQL Server instance where users connect to via Windows Authentication,...
Multiple Deployment Processes
Comments posted to this topic are about the item Multiple Deployment Processes
Question of the Day
Upgrading Admin Queries
I have a query from a former DBA that we run on SQL Server 2025 to check on database metadata. This query references sys.sysaltfiles. I want to refactor this code to be more modern. Which DMV should I reference instead?
See possible answers