2022-12-19 (first published: 2022-07-04)
2 reads
misc
Computer Disruptions
I travel a fair amount for work to speak at various events around the world. Traveling can be quite a disruption to my life, and I do work to limit the amount of time that I'm gone. As my kids have gotten older, I'm have less commitments at home and an extra night during a […]
2019-04-11
218 reads
Expediency versus Best Practice!
Rumour has it that some grand old houses in the British Isles may be haunted. A SQL Server consultant spends a night in such a house musing over the use of T-SQL versus SSIS. The story is entirely fictitious and the article has been written pro bono and dedicated to the SQL Server community. For its interest, amusement and imagination.
2015-02-02
3,125 reads
When will we look back at this?
It’s amazing how software has advanced. I look at the software I use, and I’m amazed. I still remember texting...
2013-05-31 (first published: 2013-05-24)
2,039 reads
2012-12-28
321 reads
Work Habits
I enjoy woodworking as a hobby and as I try new things I find that my work habits during the...
2009-08-31
2,092 reads
RE: Question of the Day for 18 Jun 2004
i have a gigantic 21 inch projection monitor. So, i turned my body upside down, did a hand-stand, try to read; then, my boss walked by.I owe you, Briscoe, boss said; "Franc, I love your dedication and excellent work!" :
2004-06-18
RE: inserting last record....
I agree with SQLBill, if you get bad data in the outputs from the select and try to insert you might be getting an error causing a rollback on the rows somehow. Also you say you are batching these. How are you batching: DTA, BULK INSERT, BCP, other?Finally you might consider instead of doing the […]
2004-02-10
1 reads
RE: Newbie question - Views & delete
Good questions can contribute just as much, or even more than good answers, and always are better than bad answers.
2004-01-16
RE: 2000 clustering
Your main issue in trying to set up an active/active failover cluster as a scale-out solution (as opposed to an availability solution which is what failover clusters are really designed for) is synchronising the content in both instances. The only way I can think of doing this would be to set up transactional replication with […]
2003-06-30
Blogs
Set a Runtime Variable in an Azure DevOps Pipeline
By Steve Jones
Note: I DO NOT recommend this. Any changes to a pipeline should be in...
A New Word: Symptomania
By Steve Jones
symptomania – n. the fantasy that there’s some elaborate diagnosis out there that neatly...
Query Store Keeps Switching Itself Off, Getting it Moving Again
I recently received a complaint that Query Store for a particular database was turned...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers