I’m Speaking! SQL Saturday #402 – Indianapolis
One of benefits, among several, in moving to Kentucky is the close proximity to several SQL Saturday events. I am...
2015-08-04
506 reads
John Morehouse | Sqlrus.com
I’m Speaking! Edmonton SQL Server User Group
I am honored to be speaking at the Edmonton SQL Server User Group. I always find it humbling to be...
2015-07-20
485 reads
Validating Cluster Instance Owner with Powershell
A few weeks ago, for TSQL Tuesday, I wrote about how I used Powershell to manage failing over clusters. At work,...
2015-07-17
1,014 reads
I’m Speaking! Omaha SQL Server/BI User Group
Well, it has finally happened. In the 7+ years that I helped to run the Omaha SQL/BI User Group, I...
2015-07-02
567 reads
T-SQL Tuesday #67 – Extended Events
This month’s T-SQL Tuesday topic is about extended events and comes from Jes Borland (B|T).
Like in most environments, we utilize...
2015-06-16 (first published: 2015-06-09)
1,881 reads
Why NULL Placement Matters
Not those Benjamin’s
Benjamin Franklin once said, “A place for everything and everything in it’s place“. While I assume that he...
2015-06-10 (first published: 2015-06-04)
3,159 reads
SQL Server 2008 R2 SP3 Install Errors
Whenever it is time to install a service pack every DBA silently hopes that nothing will go wrong. I would...
2015-05-28
2,091 reads
Why not jump in and help?
If you know me, you know it is in my nature to help. Whether it’s helping a friend move, helping...
2015-05-21
406 reads
Database Growth
Last week I got into a conversation with a colleague about how SQL Server grows the database. We were both fairly...
2015-05-14
1,152 reads
Free Your Mind. Release Your Inner Developer
I have always liked the drawings done by MC Escher. Looking at his drawings has always forced me to look...
2015-05-07
421 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