Redgate at SQLBits
Redgate and the Advocates are attending SQL Bits next week in London. I’m excited to see Grant and Kathi in person, as it’s been far too long since I...
2022-03-03
66 reads
Blog Posts
Saving your requests
The other day a friend of mine mentioned that they were questioned on one of the scripts they ran recently ... Continue reading
2022-03-03
286 reads
Saving your requests
The other day a friend of mine mentioned that they were questioned on one of the scripts they ran recently ... Continue reading
2022-03-03
23 reads
Using curl to Automate Multipage Logins
Watch this week's video on YouTube
I like solving the daily New York Times crossword on paper. However, logging in to download the PDF every day and printing it is...
2022-03-03
11 reads
Using curl to Automate Multipage Logins
Watch this week's video on YouTube
I like solving the daily New York Times crossword on paper. However, logging in to download the PDF every day and printing it is...
2022-03-03
12 reads
Architecture – Commonality is an accelerator
In IT, commonality is an accelerator. When I say commonality, I mean commonality of: Components, like libraries Object models Interface definitions Tools Let me give you an example. Imagine...
2022-03-02
185 reads
Azure Synapse and Delta Lake
Many companies are seeing the value in collecting data to help them make better business decisions. When building a solution in Azure to collect the data, nearly everyone is...
2022-03-02
590 reads
Daily Coping 2 Mar 2022
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2022-03-02
21 reads
Data Analysis Techniques
This is part of a series on my preparation for the DP-900 exam. This is the Microsoft Azure Data Fundamentals, part of a number of certification paths. You can...
2022-03-02
117 reads
Don’t change your default SQL Server port for security reasons
Since we’re on a recent theme of revising long-held best practices that are not, here’s a timely one for you: Don’t change your default SQL Server port for security...
2022-03-02
233 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