Viewing 15 posts - 1 through 15 (of 207 total)
Forgive (unwashed!) isn't generate_series() available?
February 26, 2025 at 9:10 am
Anyone else thought exactly as Steve did (do it manually better than testing a script), but thought again when the "force encryption" was cleared? Can't work out how it happened,...
February 17, 2025 at 9:02 am
Does it recommend against using '--' as comment delimiters
But seriously, good luck on this, Steve.
October 6, 2023 at 7:54 am
Good timing - the current feature list for SQL Server 2022 includes the function GENERATE_SERIES(), which looks like a handy way to generate the Numbers or Tally rows.
September 5, 2022 at 9:31 am
You can use something like the below to indicate a total failure somewhere. At least in the testing phase.
DELETE
FROM dbo.star_wars_film
WHERE film_id IN (
SELECT film_id
FROM dbo.purge_test
WHERE purge_type...
July 14, 2019 at 11:01 am
As a near-senior citizen, I’d like to know how one goes about protecting and remembering 30 or 40 different accounts/passwords. Password vaults are only as secure as the password...
June 25, 2019 at 2:28 pm
I will still continue asking stupid questions about queries until I feel fit enough, after all I’m a junior BI Developer now
And that is the very reason Steve's approach...
April 12, 2019 at 3:47 pm
Some great points, Steve, but please don't go down the sensationalist/quasi-abusive route to spark debate.
April 9, 2019 at 9:06 am
Nice one David.
These issues come up time and again: the need for an environment that support honesty, while still maintaining accountability. The need to identify and learn from...
May 19, 2017 at 2:37 am
May 18, 2017 at 1:05 pm
One of my devs had exactly this problem a few weeks back. My advice was:
* always alias tables
* always prefix column name references with the table alias
* it's...
May 18, 2017 at 4:00 am
If you don't already enjoy your work, find a way to enjoy it. Whatever you're employed to do, you'll be better at your job; you, your colleagues and your employers...
March 30, 2017 at 2:37 am
Yup. If only politicians could adopt the same approach.
December 15, 2016 at 3:53 am
Viewing 15 posts - 1 through 15 (of 207 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy