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,182 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,374 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,093 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,095 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,399 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,812 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,338 reads
Blogs
Moving to Rancher Desktop
By Steve Jones
I’ve been very happy with Docker Desktop for years, running it on both laptop...
Logging in Azure Data Factory data flows
By Rayis Imayev
(2025-June-15) Long gone are the days when a data engineer could simply focus on building...
ADF: Publish suddenly includes everything where it used to be incremental changes since the last publish
By Ed Elliott
I recently encountered an interesting issue with ADF where the publish feature suddenly attempted...
Forums
What is Between?
Comments posted to this topic are about the item What is Between?
skipping the second line in a spreadsheet being read by ssis
hi, my new user provided a new multi tab (sales, customer etc. not what...
disable remote access
If I configure remote access to 0 on my servers, am I right in...
Question of the Day
What is Between?
I have a table of products in SQL Server 2022. There are sequential items in the table with ProductIDs of 1, 2, 3, 4, 5, 6, 7, 8, 9, 10. If I run this code, how many rows are returned?
SELECT * FROM dbo.Products WHERE ProductID BETWEEN 4 AND 7;See possible answers