Backup and Restore Strategies in SQL Server – Part 2
In this article of the series Arshad Ali discusses different types of restore processes and backup and restore scenarios.
Is Database Mirroring Causing The Transaction Log To Fill Up
In this article, I describe some steps a DBA can take to check for mirroring on SQL Server, give a status of the mirroring state and some options for resolving any problems with the transaction log that might be caused by Database Mirroring.
Free SQL in the City Seminar Washington DC – Dec 5, 2014
SQL Server MVP Grant Fritchey and Steve Jones will present the Stairway to Continuous Delivery in Washington DC again this December. Learn how to build an efficient development and deployment process for your organization. Register for this free event.
Stop Relying on Cloud File Stores as a Backup Strategy
There is a growing assumption that Cloud file-storage services represent an ideal way of backing up files. It seems a compelling idea because it is so easy and seems secure. The truth is, as always, more complicated. There is more to any backup strategy than just cloud storage.
SSRS - Report for Stored Procedure with Parameters
You receive a request from an analyst for a report to be built from a procedure they wrote. It will require parameters based on values currently in the database and ones that allow free-typing. This article will provide a basic walk-through on handling this type of request.
Getting Data Into and Out of PowerShell Objects
You can execute PowerShell code that creates the data of an object, but there is no cmdlet to generate the 'object notation' code from an existing PowerShell object; until now, that is. Phil Factor also produces a ConvertTo-YAML function and explains how they both work, with illustrative code.
Blogs
Overcoming Imposter Syndrome: A Plan
By Brian Kelley
My most recent bout with imposter syndrome was with ISACA’s Digital Trust Ecosystem Framework...
Advice I Like: Celebrate Success
By Steve Jones
“On the way to a grand goal, celebrate the smallest victories as if each...
Programmatically Retrieving MLV Lineage and Refresh Times
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Forums
BCA KCP Benoa Telp:cs.08218171955
Whatsapp:08218171955 Jl. Suwung Batan Kendal No.2, Sesetan, Denpasar Selatan, Kota Denpasar, Bali 80222
BCA KCP Gatot Subroto Timur Telp:cs.08218171955
Whatsapp:08218171955 Jl. Gatot Subroto Tim., Penatih Dangin Puri, Kec. Denpasar Tim., Kota Denpasar, Bali...
BCA KCP Radio Dalam telepon 083110611866
WhatsApp 083110611866Jl. Radio Dalam Raya No.5 B-C, Gandaria Utara, Kec. Kby. Baru, Kota Jakarta...
Question of the Day
Increase Deadlock Detection
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers