Last Week Reading (2019-11-10)
Hello all! An extraordinary week has just passed. Two big conferences took place in the USA, PASS Summit and Ignite, where Microsoft announced plenty of new products or updates....
2019-11-10
14 reads
Blog Posts
MAXDOP and Tempdb – SQL 2016
Starting SQL Server 2016 Max Degree of Parallellism (Max DOP) Macrosoft has made hanges on this and now we can set it at database level. This helps for replication...
2019-11-09
186 reads
Omaha Azure User Group Presentation Nov 18
I’m happy to announce that I’ll be presenting an in-person session for Omaha’s Azure Users Group on Monday, November 18 at 3:00pm, entitled “SQL Server in the Microsoft Cloud“....
2019-11-09
22 reads
Invest in Yourself Stop Making Excuses
Bob Pusateri (B|T) tweeted a quote image that really struck a chord with me and elicited a strong reaction from myself. It got me thinking I need to write...
2019-11-08 (first published: 2019-10-22)
1,559 reads
SQLSaturday Orlando Notes – Kahoot
The last two years we did Family Feud as part of our end of day gathering. Fun, exciting, and energetic are all words I’d use to describe it. Definitely...
2019-11-08 (first published: 2019-10-22)
178 reads
Create Azure Data Studio SQL Notebooks with PowerShell
At PASS Summit today I gave a presentation about SQL Notebooks in Azure Data Studio for the DBA. I demo’d the PowerShell module ADSSQLNotebook. which you can also find...
2019-11-07
33 reads
Finding out the most cached database in the buffer cache - The DMV Way
While there are many ways and criteria to find out what database is the most used, under optimized, trouble maker etc....., here is one more to find out the...
2019-11-07
196 reads
Getting Started With Terraform
TEST Getting started with using Terraform for infrastructure can be a bit daunting if you've not dived into this stuff before. I put this together as a write up...
2019-11-07
40 reads
Pass Summit 2019 Keynote Day 2
I’m blogging they Keynote! One of my bucket list things has always to live blog a keynote at Pass Summit ... Continue reading
2019-11-07
103 reads
PASS Summit 2019: Day 1 Keynote – my takeaways
I’ve been at the bloggers table for two years now. I felt honored to be selected this year too. The day has started a bit differently – bloggers were...
2019-11-07
5 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