Setting up powershell remote sessions
Hey guys, differing from usual this is a quick post on setting up powershell remote sessions. I know you can...
2016-05-02 (first published: 2016-04-22)
1,898 reads
The DBA Who Came In From The Cold
SQL 2016 – Dynamic Data Masking
One of the new features that’s coming with SQL Server 2016 is Dynamic Data Masking. DDM is designed to allow...
2016-04-22 (first published: 2016-04-13)
2,142 reads
Tools of the trade
I’ve been meaning to write this post for a while now, nice and simple, just want to list the tools...
2016-04-06
526 reads
Update to TRUNCATE TABLE in SQL 2016 (partition support)
Continuing my obsession with partitioning I thought I’d write this quick post about a cool change in SQL Server 2016.
This...
2016-04-12 (first published: 2016-03-29)
2,798 reads
Partitioning and filegroup restores
I’ve been playing around with partitioning quite a lot recently and wanted to write a quick post about how it...
2016-04-05 (first published: 2016-03-24)
1,752 reads
First foray into presenting
It’s been a while since I’ve posted as the run up to Xmas last year and this January have been...
2016-01-29
781 reads
Pass 2015 – Overall Thoughts
I know I only posted one other blog about Pass but I’ve been way too busy over the last couple...
2015-11-01
329 reads
Pass 2015 – First Impressions
It’s Pass 2015 this week and I’m attending (seriously I’m unbelievably chuffed)! As they’ll be a shedload of blogs about...
2015-10-27
511 reads
Pass 2015 – First Impressions
It’s Pass 2015 this week and I’m attending (seriously I’m unbelievably chuffed)! As they’ll be a shedload of blogs about...
2015-10-27
294 reads
Where is my data stored?
Tables within SQL Server can contain a maximum of 8060 bytes per row. However even though columns are limited to...
2015-09-21
647 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