2020-01-24
291 reads
Career Growth
How Do We Prove Expertise?
Today, Grant Fritchey talks about the two paths to expertise for database professionals and why it’s hard to really know if someone is an expert.
2020-01-17
406 reads
Great Writers Get Hired
Steve thinks one of the ways you can stand out with your resume or CV is by writing well and attracting the attention of hiring managers.
2020-01-07
170 reads
2020-01-02
324 reads
The Best DBA Gifts
Today Steve asks if there is anything you'd want as a gift that would make your job better.
2019-12-27
286 reads
Learn to Change
This week Grant talks about the need for change and growth to adapt to the changing world.
2019-12-21
156 reads
The Evolving DBA
Steve thinks the DBA job is evolving and we will always need people to manage data.
2024-05-17 (first published: 2019-12-16)
515 reads
Finding Your Own Career
Learning to find the career that's important to you can be a challenge. Today Steve has some advice.
2023-05-15 (first published: 2019-12-11)
367 reads
What's a forgivable mistake?
Today Steve wonders if your company is understanding of your human frailty.
2019-12-06
260 reads
It's More Than What You Know
I'm a firm believer in keeping your tech skills up to date, as well as your social skills, What better way than attending or presenting at a conference or group meeting. The reason to attend an event I'm very fortunate that my company allows me training days and time for personal development, covering all expenses […]
2019-12-03
1,944 reads
Blogs
How to Build Data Management for Unstructured Data
The post How to Build Data Management for Unstructured Data appeared first on Joyful...
Grinding Away: Brent Ozar
By Steve Jones
Brent Ozar is a very successful DBA/consultant/speaker/business owner in the data platform space. Many...
Monday Monitor Tips: Am I Patched?
By Steve Jones
One of the things that I think is neat is that Redgate Monitor helps...
Forums
Peer review SQL Central articles
Hi, I would like to contribute to SQLServerCentral in peer reviews. As there are...
Getting ANY of the data
Comments posted to this topic are about the item Getting ANY of the data
Why Would You Do That?
Comments posted to this topic are about the item Why Would You Do That?
Question of the Day
Getting ANY of the data
I have this data in two tables:
-- Beer table BeerIDBeerNamebrewer 5Becks Interbrew 6Fat Tire New Belgium 7Mac n Jacks Mac & Jack's Brewery 8Alaskan AmberAlaskan Brewing 9Kirin Kirin Brewing -- Beercount table BeerName BottleCount Becks 5 Fat Tire 1 Mac n Jacks 2 Alaskan Amber 4 NULL 7 Corona 2 Tsing Tao 4 Kirin 12What is returned from this query?
SELECT * FROM dbo.BeerCount AS bc WHERE bc.BeerName=ANY (SELECT b2.BeerName FROM dbo.Beer AS b2);See possible answers