Daily Coping 21 Nov 2022
Today’s coping tip is to revisit a coping tip from the past and see if it helped you.. I came up with this one after I tried to do...
2022-11-21
15 reads
Blog Posts
Leaving (or minimizing) Twitter
Fairly short post here. Due to the recent events around Twitter (which I will not get into), I’m making an effort to reduce or completely cease my activity on...
2022-11-21
36 reads
Sale on SQL Server 2022 Query Performance Tuning
Just a quick post to let you know that there’s a great sale right now at Springer on my brand new, completely rewritten, query performance tuning book. Get your...
2022-11-21
58 reads
SQL Temporal Tables — Gotcha!!!
Hello, again reader… Today, I will discuss a gotcha I ran across with SQL Server Temporal Tables. In my day-to-day environment, we do not use Temporal Tables widely. However,...
2022-11-21 (first published: 2022-11-01)
997 reads
Tales From The Field Weekly Wrap Up for the Week of 11-14-2022 Live! 360
Hello Dear Reader! Last week was a week we have been building towards since the launch of Tales from the Field. My favorite conference every single year, Live! 360. ...
2022-11-21
39 reads
Where Is My SQL Server Errorlog?
If you need to find the SQL Server ErrorLog in a hurry and don’t want to spend 30 minutes drilling into every drive on the server: “I don’t watch...
2022-11-21 (first published: 2022-11-01)
262 reads
Session Materials – PASS Data Community Summit and Cloudbrew
You can find the slides and demo scripts for my sessions at Cloudbrew (Snowflake) and PASS Data Community Summit (Migrate SSIS skills to ADF) in my Github repo. If...
2022-11-19
18 reads
2022 PASS Data Community Summit Recap: Power BI Meets Programmability – XMLA, TOM, C#
Thank you to everyone who made it out to PASS Data Community Summit! I have greatly enjoyed meeting so many fellow data nerds and have learned so much from...
2022-11-18 (first published: 2022-11-17)
21 reads
Daily Coping 18 Nov 2022
Today’s coping tip is to be creative, cook, draw, write, paint, make, or inspire. While I do play some guitar, I’m not much for painting. Certainly I write a...
2022-11-18
13 reads
Data Manipulation with Word and Excel
Recently I had to go through some training that asked me to evaluate some text. I needed to tally some data up, and decided Word and Excel were quick...
2022-11-18 (first published: 2022-11-07)
422 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...
Is Fabric a Reliable Service or a Ripped Resource?
Comments posted to this topic are about the item Is Fabric a Reliable Service...
locking down agent for new user on our dev machine
hi , a new user wants to be able to add sql agent jobs...
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