Database Transaction log file full in the full recovery model
AdvertisementsI am seeing in more environment the database recovery model is set FULL and there is no transaction log backup...
2018-10-16
293 reads
AdvertisementsI am seeing in more environment the database recovery model is set FULL and there is no transaction log backup...
2018-10-16
293 reads
AdvertisementsThis month’s T-SQL Tuesday topic is “SQL Server Bugs & Enhancement Requests” and hosted by my favorite and inspirational Brent Ozar.
Here...
2017-01-10
578 reads
AdvertisementsAlwaysON database not synchronizing mode SQL service account change
Suddenly, one of our alwaysON server databases are went not synchronizing mode.
Errors...
2016-11-24
2,586 reads
AdvertisementsAlwaysON database NOT SYNCHRONIZED and RECOVERY PENDING
I have recently come across an issue that, one of my alwaysON secondary replica...
2016-08-16 (first published: 2016-08-06)
16,188 reads
AdvertisementsMove database without breaking alwaysON
This post is going to show the database movement from one drive to another drive, without...
2016-08-08 (first published: 2016-08-03)
15,748 reads
AdvertisementsThere are many blog posts talking about, how to recover “SysAdmin” password in case if it’s lost OR the server...
2014-08-01 (first published: 2014-07-27)
15,870 reads
AdvertisementsRecently one of my application website went down.
I checked all the basic connectivity troubleshooting and seem everything was looking and...
2013-11-25
1,363 reads
AdvertisementsLogin failed for [SQLSTATE 28000] (Error 18456) the step failed
When you query the data from another SQL server (Linked server)...
2012-06-18
53,323 reads
AdvertisementsRecently one of our SQL server unable to start it. The problem with the storage LUNs.
Things you have to do:...
2012-04-09
6,307 reads
AdvertisementsUse the simplest script to find the latest database backup and the location.
-- To get the backup history
SELECT top 100...
2012-03-05
863 reads
By Steve Jones
“Don’t aim to have others like you; aim to have them respect you.” –...
Many years ago, before I joined Oracle, I was working on a major modernisation...
If you work with data pipelines, SQL, notebooks, or machine learning models, a Mac...
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
WhatsApp:0817-866-887 Area Street Festival, Ruko No 1 & 1A, CBD, Jl. Galuh Mas Raya,...
Comments posted to this topic are about the item Is Fabric a Reliable Service...
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