SQL Server Security Checklist
In this article I will share the Microsoft SQL Server Security Checklist that I have used for many of my clients to help them achieve PCI compliance. This can...
2023-09-11
278 reads
Blog Posts
T-SQL Tuesday #166: Extended Events
When I was put on the list to host September’s T-SQL Tuesday, well, I forgot to put it in my calendar. So I’m late (and in the doghouse with...
2023-09-11
54 reads
A Multitude of Summary Views in SQL Compare 15
A client asked for a summary of changes, so I wrote a post to show where to find this in SQL Compare 15. As I was checking out the...
2023-09-08 (first published: 2023-08-07)
217 reads
A New Word: Vulture Shock
vulture shock – n. the nagging sense that no matter how many days you spend in a foreign country, you never quite manage to step foot in it –...
2023-09-08
37 reads
Focusing on a Different S Curve
At the beginning of the year, I took a step back and looked at how far my career had grown. In large part because of the incredible data community,...
2023-09-08 (first published: 2023-08-16)
151 reads
I don’t blog anymore, but not because I work at Microsoft
Last year I had a health scare that got my blood pressure at 200-and-something over 100-and-something, soon to be wired up to an IV drip, put through a CT...
2023-09-08
53 reads
Raiders of the Lost ADX – dataminds connect 2023
I’m very excited for this year’s edition of dataminds connect. It’s the first time I’m going to co-present a live session. My fellow explorer is the amazing bearded Johan...
2023-09-08
21 reads
Speaking at the Future Data Driven Summit 2023
I’m going to give a lightning talk at the online (free) Future Data Driven Summit. The subject is How I saved 80% on my Azure Data Factory Costs. The...
2023-09-08 (first published: 2023-09-07)
11 reads
Future Data Driven is Coming Sept 27 for FREE
The Future Data Driven 2023 virtual conference is coming on September 27. Register today and save a note in your calendar. I have been honored to speak at this...
2023-09-07
28 reads
Power BI VertiPaq Engine: Optimizing Column Encoding
Power BI encoding is a powerful optimizing option that is often overlooked because it’s not visible in neither the Power BI Desktop tool nor in Power BI Service. Natively,...
2023-09-07 (first published: 2023-09-06)
701 reads
Blogs
Advice I Like: Respect
By Steve Jones
“Don’t aim to have others like you; aim to have them respect you.” –...
Setting Up a Mac for Data Engineering and AI Work
If you work with data pipelines, SQL, notebooks, or machine learning models, a Mac...
Want to look at cloud reporting but not sure what the costs will be?
By ChrisJenkins
Have you been thinking about migrating your reporting to Microsoft Fabric or Snowflake but...
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...
locking down agent for new user on our dev machine
hi , a new user wants to be able to add sql agent jobs...
ALAMAT BCA KCP Saharjo Tlp,Cs:0821-8154-393
WA:08218154393 Jl. Dr. Saharjo No.149 G-H, RT.5/RW.4, Manggarai Sel., Kec. Tebet, Kota Jakarta Selatan,...
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