Data Privacy – Playing your part
Tuesday 28th January 2020 was “Data Privacy Day 2020” Some may refer to this as Data Protection Day, but it is really just a day to draw attention to...
2020-03-10 (first published: 2020-02-03)
188 reads
measure twice, cut once.
2020-02-02
3 reads
Is NoSQL still a thing?
G’day, Looking back, perhaps one of the (many) mistakes that I’ve made in my career was to initially ignore the N0SQL movement. I’ve focused my career on Relational Database...
2020-01-27
14 reads
Moving to a Modern Microsoft Platform
Melbourne Event – Monday 17th June 2019 (Free – including lunch and prizes) PASS, in conjunction with Microsoft, Intel and community leaders are offering free training on Moving to...
2019-06-06
4 reads
Speaking at Events
G’day, I recently got the opportunity to speak at the “PASS Marathon, The New World of Data Privacy”. I had not spoken at a virtually event for quite some...
2019-05-28
2 reads
Generating Insert Statements
G’day,
I been asked a few times lately the best way to generate INSERT statements.
I’d always replied to use SSMS.
I know...
2020-03-03 (first published: 2019-02-02)
2,522 reads
Azure Notebooks – a nice little tool.
Gday,
I’ve been playing with Azure notebooks lately and have found them invaluable as
A teaching aidA test sandboxI’ve been using Python...
2019-01-31
1,093 reads
T-SQL Tuesday #109 – Mentors and Mentees
G’day again,
So, it’s time for T-SQL Tuesday again, the blog party
started by Adam Machanic (
This time we're talking about people...
2018-12-11
158 reads
TSQL Tuesday #108 – Learning to Learn
G’day,
One attribute that I think is more relevant today than ever is to have a broad base of skills with...
2018-11-15
176 reads
A lack of foreign keys – a bad culture example.
G’day,
One of the things that I’ve been seeing more often than I would like to lately is large databases with...
2020-03-03 (first published: 2018-10-28)
3,186 reads
Blogs
Parsing EXE Output in PowerShell
By Steve Jones
I saw a post internally that asked this question: Anyone have a handy powershell...
Connect With More Clients: Our Partner Directory Has Arrived
By Rob Sewell
The partner directory connects your agency with new customers.
Can You See Who Forced a Plan
I had an excellent group of people in Gothenburg Sweden when I taught there...
Forums
GIT Configuration and Automated Release for Azure Data Factory
Comments posted to this topic are about the item GIT Configuration and Automated Release...
Split concatenated column data into separate rows
My table1 has a column that has the following in it: (2)Joystick,(3)Candies,(6)Wires I want...
Do same query without (insert into tables or using windows functions)
CREATE TABLE TempA ( InvoiceNo VARCHAR(50) NOT NULL, Date TIMESTAMP NULL, Type VARCHAR(50) NULL,...
Question of the Day
Concat Addition
What is the result of this code?
SELECT CONCAT(1, 2, 3) + 4See possible answers