Do I Want to Design My Own Transaction Log?
The processing of the Transaction Log seems simple to reproduce, but be sure you consider all the possibilities.
On-Time, or Not
Today we have a guest editorial from Andy Warren that looks at the respect, understanding and compromise we might make with each other.
The New Men of IT
According to the New Men of IT, the industry changes so frequently that experience and qualifications quickly become obsolete and irrelevant. The argument won't wash with Phil Factor.
SQL Server Integration Services SSIS Package Configuration
As you develop, test and deploy SSIS packages, you need to specify different parameter values for things like database connection strings, file and folder paths, etc. without having to edit the individual SSIS packages to make these changes. Ray Barley looks at how you can accomplish this goal by taking advantage of the configuration capabilities that SSIS provides, in particular the SQL Server package configuration.
BYOD
In the future we may be required to bring our own devices to work. Does that make sense? Would you want to get an allowance and purchase your own laptop?
Queries to Monitor SQL Server Replication Backlog
When replicating data to other servers it is always a concern that the subscribers may be far behind. In this article, Tim Smith shares some queries to help monitor SQL Server replication row counts.
Documenting SQL Server with PowerShell
SQL Server instances are generally poorly-documented. How easily can you tell if something has changed? How easily can you check that there is adequate space for growth? Are you up-to-date with licenses? What errors are happening? Who has accessing the system? Before PowerShell, it was difficult to be on top of all this. Now you can, with the help of Sander's database documenter.
The Math on Automation
Is it worth automating things? Many people say yes, but Steve Jones says it isn't just about time saved.
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 BANK BCA KCU PEMATANG SIANTAR TLP/WA 08218200233
Telp Cs: 08218200233 Jl. Merdeka No.39, Proklamasi, Kec. Siantar Bar., Kota Pematang Siantar, Sumatera...
ALAMAT KANTOR BCA KCU ASIA TLP/WA 08218200233
Telp Cs: 08218200233 Jl. Asia, Simpang, Jl. Bakaran Batu No.1 C, Sei Rengas II,...
ALAMAT KANTOR BCA KCU WISMA ASIA TLP/WA 08218200233
Telp Cs: 08218200233 Wisma Asia, Jl. Letjen S. Parman No.Kav. 79, RT.4/RW.9, Kota Bambu...
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