Scott Stauffer 🇨🇦

@SQLSocialite@techhub.social
210 Followers
146 Following
102 Posts
SQL, Power BI, Puppy Raiser
more det's to come...

Time for me to spread puppy love!
https://ami.ca/category/blind-trust-a-guide-dogs-journey/media/guide-dogs

I'm betting you'll need some tissues for tears. At the end if this 22 minute episode, if you manage not to cry, okay, but if you do, please give $5 to my fund raiser to help me reach my goal.

https://www.canadahelps.org/en/pages/teamannie/

Guide Dogs

Guide dogs can have a profound impact on the lives of their handlers, but the journey from puppy to guide dog doesn’t happen overnight. Meet the amazing people who help raise, train and team up with these incredible dogs.

Accessible Media Inc.

Annie - a pUpdate - where is she today? 🐕‍🦺

"I have been meaning to sit down and write this post for several months..."

"We had Annie, our Service Dog in Training for significantly longer than most puppy raisers..."

Read, and see more picture here:
https://www.canadahelps.org/en/pages/teamannie/

#TeamAnnie

#TeamAnnie!

Scott turns 52 on Oct 1. Help him support his favourite charity: BC & Alberta Guide Dogs Also celebrate Annie's graduation as a PTSD Dog.

CanadaHelps - Donate to any charity in Canada

The best way to spot an idiot is to “look for the person who is cruel”, Pritzker says. “When someone’s path through this world is marked with acts of cruelty, they have failed the first test of an advanced society. They never forced their animal brain to evolve past its first instinct … Over my many years in politics and business, I have found one thing to be universally true – the kindest person in the room is often the smartest.”

https://www.theguardian.com/commentisfree/2023/jul/23/how-to-spot-idiots-jb-pritzker-northwestern-speech

Want to quickly spot idiots? Here are five foolproof red flags

The governor of Illinois went viral with a speech about seeing idiots in one’s midst. I have a few pointers of my own to offer

The Guardian
Before I head off to sleep, I would like to say that my interest in social media and news has plummeted since taking up reading again (I was a voracious reader in my youth). And because there are so many books out there in your public library’s virtual app, you can read many books for free. And, if there’s a book you don’t like, you can return it and pick a new one. It’s like magic, and it’s why we should keep funding public libraries. Save yourself from social media. Read or listen to a book.

The full quote and where Ike said it.

"I think the women, therefore, must be concerned with these values, and I return to my statement that if a political party does not have its foundation in the determination to advance a cause that is right and that is moral, then it is not a political party; it is merely a conspiracy to seize power." - President Dwight David Eisenhower, at the Fourth Annual Republican Women's National Conference (6 March 1956)

Today in 1972, Beatrice Worsley died. Born in Mexico in 1921, she was the first female computer scientist in Canada.
She wrote the first program to run on EDSAC, wrote the first compiler for Toronto's Ferranti Mark 1 & taught at the University of Toronto for over 20 years.

#computers #womenshistory #computerscience #canada #history #histodon #histodons

I have two performance tips for #sqlserver #SSMS users.
1. If you are working with a very busy database where backups or deletes are holding locks and SSMS can't expand OE nodes or open property sheets, use this registry hack to put SMO queries in Read Uncommitted mode. https://guibubbles.wordpress.com/2017/06/05/ssms-and-smo-query-isolation/

2. When opening Object Explorer to an Azure SQL Database instance as a non-admin user is taking a long time, set your "Connection Timeout" value to a small number like 10 or even 5 seconds. This will cause some background connections to fail more quickly and unblock the real work.

SSMS and SMO – query isolation

We Can Do Better
If you have missed the news 😬 , make sure to check this out: "Calling REST endpoints from #AzureSQL Database" on #AzureFriday, to learn how you can easily integrate with Azure Functions, Event Grid or Event Hubs, Power BI, Cognitive Services and more! 🤩 https://www.youtube.com/watch?v=R6l-2XJyu2c
Calling external REST endpoints from Azure SQL Database | Azure Friday

YouTube

In addition to Home Depot, which was the focus of the Privacy Commissioner's report, CBC found the following retailers were sharing customer data with Meta when customers asked for electronic receipts:

- Anthropologie.
- Bed, Bath & Beyond.
- Best Buy.
- Gap.
- Hudson's Bay.
- Lululemon.
- PetSmart.
- Sephora

Full CBC story here: https://www.cbc.ca/news/business/retailers-sharing-data-meta-1.6737484

#canada #privacy

These retailers share customer data with Facebook's owner. Customers may not have been told | CBC News

A CBC News review of Facebook user data suggests a variety of well-known retailers, including Hudson's Bay, Lululemon and Best Buy, have been sharing customer details with the platform's parent company. A watchdog recently said Home Depot breached privacy law by not properly getting customers' consent.

CBC

I guess I can’t edit a post here either - oh well.

My old one has okay speakers on them. The 2 new monitors, just headphone jack. :(