Consolidating Email Accounts
I am consolidating my professional email accounts into one place. If you’ve previously contacted me using my linchpinpeople.com or either...
2014-10-21
538 reads
Databases – Infrastructure – Security
SQL Server Security Benchmarks
If you’re not familiar with the Center for Internet Security, here’s the organization’s mission statement:
The Mission of the Center for...
2014-10-20
872 reads
#TSQL2sday #59 – My Heroes
Here is my list of heroes for #TSQL2sday. None of them are directly tied to technology, much less SQL Server....
2014-10-14
550 reads
Slides and Code for SSIG Talk
Thank you for those who made it out to the SQL Server Innovators Guild last night in Greenville, SC. I...
2014-10-08
608 reads
Carolina Technology Conference: Presentation Materials
For those able to attend my session at this year’s Carolina Technology Conference, thank you! As promised, here are the...
2014-10-06
802 reads
The Fallacy of Internal Access Only
In the wake of Shell Shock, I’ve seen some vendor advisories indicate that while their product is vulnerable, it’s only...
2014-10-07 (first published: 2014-09-30)
7,117 reads
Four Things PASS gets Right
PASS has taken a lot of heat recently. A few folks have pointed out that you only seem to hear...
2014-09-29 (first published: 2014-09-24)
6,777 reads
[Off-Topic] Beating Childhood Cancer
Note: I feel this post is important enough to post across all my blogs.
September is Childhood Cancer Awareness Month here...
2014-09-09
552 reads
Audit Webinar Tomorrow (4 September 2014)
I will be given a webinar on how to audit SQL Server through MSSQLTips.com.
Webinar Registration Link
The abstract:
Don’t become a statistic....
2014-09-03
506 reads
4 Attitudes I Wish I Had Earlier as a DBA
I was tagged by Mike Walsh (blog | twitter) in his post 4 Attitudes I Wish I Had Earlier As a...
2014-09-05 (first published: 2014-08-28)
8,127 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