Recapping SQL Saturday Albany 2020 (virtual)
This weekend was SQL Saturday Albany 2020. This was my third time attending the Albany event, my second time presenting, and my first virtual SQL Saturday. As always, Ed...
2020-07-26
4 reads
alevyinroc
- Website: https://flxsql.com
Finding & Downloading Required SQL Server Updates
A little while back, I offered up a one-liner to scan your SQL Server instances and report which ones are out of date. But what if you need to...
2020-07-21
31 reads
Finding & Downloading Required SQL Server Updates
A little while back, I offered up a one-liner to scan your SQL Server instances and report which ones are out of date. But what if you need to...
2020-07-21
177 reads
Three Ways to Create a Temp Table
Taking it back to SQL 101 today because I recently saw something that floored me. I’m a big fan of temp tables. I use ’em all over the place...
2020-07-06 (first published: 2020-06-23)
2,548 reads
Virtual SQLRun for PASS Summit 2020
Just because we aren’t all together in Houston doesn’t mean we can’t have a #SQLRun at this year’s Summit. It might even be easier for some folks as there’s...
2020-07-02
10 reads
Three Ways to Create a Temp Table
Taking it back to SQL 101 today because I recently saw something that floored me. I’m a big fan of temp tables. I use ’em all over the place...
2020-06-23
37,260 reads
Three Ways to Create a Temp Table
Taking it back to SQL 101 today because I recently saw something that floored me. I’m a big fan of temp tables. I use ‘em all over the place...
2020-06-23
3 reads
Speaking at SQL Saturday Albany
For the second consecutive year, I will be speaking at SQL Saturday Albany 2020 on July 25th, 2020. I will be presenting “Keys to a Healthy Relationship with SQL...
2020-06-16
4 reads
T-SQL Tuesday #127 - Non-SQL Tips & Tricks
T-SQL Tuesday is a monthly blog party hosted by a different community blogger each month, and this month Kenneth Fisher (blog | twitter) asks us for non-SQL tips &...
2020-06-09
19 reads
Home Office Desk Evolution
Setting up a home office can be a daunting task. Doubly so when you don’t get an opportunity to plan it out and you have to set things up...
2020-06-02
8 reads
Blogs
Advice I Like: Respect
By Steve Jones
“Don’t aim to have others like you; aim to have them respect you.” –...
Blue Sky Programming – The Optimism Trap
Many years ago, before I joined Oracle, I was working on a major modernisation...
Setting Up a Mac for Data Engineering and AI Work
If you work with data pipelines, SQL, notebooks, or machine learning models, a Mac...
Forums
SQL Art, Part 4: Happy 4th of July — A British DBA's Guide to Celebrating a War We Don't Talk About
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
ALAMAT BCA KCP Ampera Tlp:08218154393
WA:08218154393 Gedung Aurum, Jl. Ampera Raya No.37, RT.8/RW.2, Cilandak Tim., Ps. Minggu, Kota Jakarta...
ALAMAT BCA KCP Mayestik Tlp:08218154393
WA:08218154393 Jl. Kyai Maja No.77, RT.12/RW.3, Gunung, Kec. Kby. Baru, Kota Jakarta Selatan, Daerah...
Question of the Day
BIT_COUNT I
In SQL Server 2025, I have a table (dbo.UserPermission) that contains this data:
UserID UserPermissions 15 23 37What is returned when I run this code:
select bit_count(UserPermissions) as PermissionCount from dbo.UserPermission where UserID = 3;See possible answers