Save Money On Your Azure Monthly SQL Database Bill
Microsoft gives you two purchasing models for your Azure SQL Databases (SQL DB), a DTU and a vCore based model...
2018-09-05 (first published: 2018-08-22)
2,248 reads
SQLEspresso
Contained Database – No more need for Server Level Logins
Starting in SQL Server 2012 and in Azure SQL Database, Microsoft introduced the concept of a contained database. A contained...
2018-07-11 (first published: 2018-07-05)
2,915 reads
Congrats to DCAC Staff on MVP Renewals
July 1st is a day all Microsoft Most Valuable Professionals (MVP) wait patiently at their computers hitting F5 over and...
2018-07-02
332 reads
Replication Max Text Length
Ever seen the below error? Until this week I hadn’t. So, I figured I’d take a little time and introduce...
2018-06-28 (first published: 2018-06-20)
10,836 reads
Respectfully Responding
I typically don’t write opinion posts, but given recent events I thought it was important to follow up on one of my tweets....
2018-06-29 (first published: 2018-06-14)
2,267 reads
How to get started with Always Encrypted for Beginners Part 4: Change is Coming
A few weeks ago, I wrote Part 1, 2 and 3 of this series, which was a beginner’s guide to Always Encrypted. In part...
2018-06-25 (first published: 2018-06-13)
2,576 reads
Importance of Statistics
Following up on my last post about the Cardinality Estimator let’s talk about column statistics and how they work and...
2018-05-30
591 reads
Query Predicates
Sometimes people speak “SQL” and expect you know all the terminology. In recent a conversation about query plans I was...
2018-05-24
955 reads
5 Ways to Examine Cardinality Metrics
In SQL Server the query optimizer uses a cardinality estimator to answer data SELECTIVITY questions like the ones below. The...
2018-05-02
379 reads
Live, Learn, and Grow
Ever look back at old work and wonder what was I thinking when I did that? Or even better you...
2018-04-25
332 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...
locking down agent for new user on our dev machine
hi , a new user wants to be able to add sql agent jobs...
SQL Server Enum Implementation: A Single-Row View Strategy for Avoiding Magic Values
Comments posted to this topic are about the item SQL Server Enum Implementation: A...
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