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
995 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,181 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,371 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,313 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,340 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,091 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,092 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,398 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,782 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,333 reads
Blogs
New Job -> Week 2 -> Creating a Checklist
This is part of a series of new job blog posts. You can find...
SQL Server 2022 Administration Inside Out
By Will Assaf
SQL Server 2022 Administration Inside Out is now available for pre-order from Microsoft Press. This...
WIT/DEI Mental Health and Wellness Day Challenge to Present
Back in December 2019, I started presenting my session on mental health with lots...
Forums
Calculate log space required on principle for maintenance activity
Hi all, We have a database configured for asynchronous mirroring. We have some planned...
Get a Date Time Stamp of table when another columns value changes.
I have created a table as per below query CREATE TABLE [dbo].[mydbtemp]( [Datetime] [datetime]...
how to write a query by using some filter patterns in SQL Server?
what I want is to apply some filter patterns to search the data. For...
Ask SSC