Apply for the 2019 Idera ACE Program
Sharing this before I forget, Idera is taking applications for their 2019 ACE Program. If you’re wanting to do more...
2018-09-19
762 reads
Blog Posts
Careful with your SQL Server Max Memory settings
Quite often I see database administrators set SQL Server max server memory thinking everything related to SQL Server uses this...
2018-09-19
614 reads
Databases and DevOps, It’s Not Just Me
Anyone who subscribes to my blog or my YouTube channel as well as anyone following me on social media knows...
2018-09-19
316 reads
Midlands PASS Reboot!
If you’re in or near the Columbia, SC area, we are rebooting the Midlands PASS Chapter. Here is our first...
2018-09-19
629 reads
Only one Log Reader Agent can connect to a database at a time error – Transaction Replication/CDC
An interesting issue regarding SQL Server Transaction Replication/CDC log reader agent job can’t be started with the following error:
Msg 18752, Level...
2018-09-19 (first published: 2018-09-10)
8,015 reads
Overview of SQL Joins in SQL Server
The ability to combine results from related rows from multiple tables is an important part of relational database system design. In SQL...
2018-09-19
620 reads
PASSITON discount code for PASS Summit 2018
This week only PASS has a new discount code of PASSITON for an additional $200 off 3-day registration. This is in addition to registration going up next by $200...
2018-09-19
20 reads
Powershell Error – Import-Module AzureRm
I was playing with SQL Azure on my brand new Surface pro device. I open the Windows Powershell ISE as administrator to...
2018-09-19
1,137 reads
Public Service Announcement: check your backup notifications
The Azure cloud platform lost a data centre for a number of hours recently due to inclement weather. This affected...
2018-09-19
232 reads
Rescheduled Performance Troubleshooting Webinar
With Hurricane Florence no longer a hurricane, we have rescheduled the webinar for next Wednesday, September 26, 2018.
Free sign up...
2018-09-19
216 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