My dear friend Josephine Bush a.k.a HelloSQLKitty hosts this month’s T-SQL Tuesday. Josephine’s call to us is to share our understanding of the multitude of job titles available out...
2023-08-25 (first published: 2023-08-08)
174 reads
We have a guest editorial today from Mala Mahadevan on the changing data community.
2023-07-03
135 reads
This month’s T-SQL Tuesday is hosted by Gethyn Ellis(t). Gethyn’s Invite to us is to write about the best piece of career advice you’ve received. One of the most...
2023-06-20
26 reads
This month’s T-SQL Tuesday is hosted by Tomaz Kastrun – his call is to write about how we’ve used ChatGPT, and what are ethical issues, if any, that we...
2023-05-22 (first published: 2023-05-09)
409 reads
We all need guidance as we make our way through our careers and our lives. Some people are blessed with the right folks who can offer that by way...
2023-03-24 (first published: 2023-03-17)
134 reads
Get an introduction to the Stairway Series and learn about the power of the ScriptDOM library.
2023-02-22 (first published: 2022-03-09)
6,772 reads
In this level of the Stairway to ScriptDOM, we examine the way the tool parses scripts and creates tokens from the text.
2023-02-22 (first published: 2022-04-13)
4,143 reads
Learn how you can query for patterns in the Abstract Syntax Tree to analyze your code.
2023-02-22 (first published: 2022-06-08)
2,142 reads
This level of the Stairway to ScriptDOM looks at finding more complex instance of anti-patterns in your code.
2022-12-07
1,215 reads
I am writing this blog post as contribution to #NewStarNovember and what got me re-started as a tech speaker in 2020. I haven’t done a lot of tech speaking...
2022-11-30 (first published: 2022-11-29)
10 reads
The other day I came across an interesting repo on github, KubeDiagrams. What this...
By Steve Jones
I wrote about getting the Redgate Test Data Manager set up in 10 minutes...
SQL Server migrations are a headache, ask anyone who’s been through the pain of...
Hi we know (or believe) ssas saas gets stood up separately when a company...
Good Afternoon. I have been manually running an SSIS package on an adhoc basis,...
I have an always on availability group of 3 servers (1 primary and 1...
I have this code:
SELECT CHOOSE (MONTH (saledate), 'Winter', 'Winter', 'Spring', 'Spring', 'Spring', 'Summer', 'Summer', 'Summer', 'Autumn', 'Autumn', 'Autumn', 'Autumn') AS x FROM ProductSales;What is a good name for the column alias? See possible answers