A Health Check can keep your SQL database in great shape
Modern businesses are data-driven. Many business leaders will tell you it is the “lifeblood” of their company. Good data helps...
2018-11-07
281 reads
Blog Posts
Append Variable activity in Azure Data Factory: Story of combining things together
(2018-Oct-29) There are only a few sentences in the official Microsoft web page that describe newly introduced activity task (Append Variable)...
2018-11-07 (first published: 2018-10-29)
12,596 reads
Azure SQL Database – Aborting Scale Request
Scaling up or down an Azure SQL Database is a very common task. Whilst common it is also very easy...
2018-11-07
296 reads
Cannot Use the Special Principal – Back to Basics
Cannot use the special principal 'dbo'. This error message can be misleading. This article will take you on a journey of common mis-steps along with the appropriate fix for...
2018-11-07
447 reads
Explicitly Drop Temporary Tables Or Wait For Cleanup?
I was recently asked if we are going to see performance differences if we explicitly drop temporary tables. I couldn’t...
2018-11-07 (first published: 2018-10-29)
3,990 reads
Exporting configuration data from SQL Sentry
SQL Sentry is a pretty cool monitoring system but there's a downside to having so many knobs to turn:
it's next...
2018-11-07
242 reads
How do I ask for SQL Server help on Twitter?
For those of us who have been on twitter for a long time, we are familiar with the #sqlhelp hashtag....
2018-11-07
292 reads
Join us for FryeDay!
Once again it is PASS Summit week in Seattle. This is the biggest event in the world for SQL Server and Microsoft Data Professionals to gather to connect, share...
2018-11-07
12 reads
Join us for FryeDay!
Once again it is PASS Summit week in Seattle. This is the biggest event in the world for SQL Server...
2018-11-07
159 reads
Missing those we’ve lost
It’s the start of Summit for many of us (not me, sorry) and it seemed like a good time to...
2018-11-07
229 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
Alamat Kantor BCA KCU Cibubur Telp:082144477715
WA:0821-4447-7715 Jl. Alternatif Cibubur RT.005/09. Kel. Harjamukti, Cibubur, Kec. Cimanggis, Kota Depok, Jawa Barat...
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...
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