Friday Reading 2018-05-04
Phew, busy week. In the middle of updating presentations and making sure demos work!
Here’s a few of the articles...
2018-05-04
341 reads
The DBA Who Came In From The Cold
Changing the location of docker named volumes
A few weeks ago I was presenting at SQL Saturday Raleigh and was asked a question that I didn’t know...
2018-05-09 (first published: 2018-05-02)
1,804 reads
Shiny Tech Syndrome
This is the name I give to anyone who, whilst learning a new technology, suddenly thinks it’s the best thing...
2018-04-30
368 reads
T-SQL Tuesday #101: My Essential SQL Server Tools
This month’s T-SQL Tuesday topic comes from Jens Vestergaard (b|t) who is asking us about our essential SQL Server Tools.
I’ve...
2018-04-10
308 reads
Friday Reading 2018-04-06
Feels like an age since I posted some links. So busy these days!
I’m really excited today as tomorrow I head...
2018-04-06
265 reads
Changing the port for SQL Server in Azure Container Services
I got asked this question last week and it’s a very good one. After all, running Sql Server in Azure...
2018-04-05 (first published: 2018-04-04)
1,748 reads
Imposter syndrome
Last week I posted the following “joke” on twitter: –
I’ve called it a “joke” but I wasn’t really joking. This...
2018-04-02
298 reads
How I became a Data Platform MVP
As I spent last week attending my first MVP Summit in Seattle I thought I’d write this post about how...
2018-03-14
396 reads
A gotcha when switching partitions
When working with partitioning the SWITCH operation has to be my favourite. The ability to move a large amount of...
2018-02-28
3,142 reads
Indexing and Partitioning
Partitioning tables is a great tool to increase the manageability of your data. Being able to move large amounts of...
2018-02-21
3,854 reads
Blogs
Learn about Modern Microsoft Apps in San Diego
By Steve Jones
I wrote about learning today for the editorial: I Can’t Make You Learn. I...
How To Deploy Fabric SQL and Azure SQL Databases with Azure DevOps
By ReviewMyDB
Fabric has CI/CD built in, but if you've tried to use it for database...
A New Word: Attriage
By Steve Jones
attriage – n. the state of having lost all control over how you feel...
Forums
SSRS Reminded Me of the Time Microsoft Retired TMG
Comments posted to this topic are about the item SSRS Reminded Me of the...
Getting results from a Procedure to join to a query
I have a need to execute a stored procedure and return the results to...
Upgrade 2016 Standard to 2022 Express
Title pretty much says it all - can this be done? I've tried several...
Question of the Day
BIT_COUNT II
In SQL Server 2025, I have a table (dbo.UserPermission) that contains this data:
UserID UserPermissions 15 23 37 4 NULLWhat is returned when I run this code:
select bit_count(UserPermissions) as PermissionCount from dbo.UserPermission where UserID = 4;See possible answers