The Database Giveth and Taketh Away
A database error at Southwest Airlines confused some customers and was embarrassing. Steve worries that we might want to be more careful in the future about making database mistakes.
Using Backup Encryption with an External Certificate
Learn how to load an external certificate into SQL Server to encrypt your backups.
Reporting Services Basics: Overview and Installation
SQL Server Reporting Services has changed quite a bit since it was introduced in 2004. Despite new analytic services like Power BI, SSRS is still a popular tool for paginated reports. In this article, Kathi Kellenberger explains the architecture of SSRS and walks you through installing an SSRS development environment on your workstation or laptop.
SQL in the City Summits – UK, US & Down Under
Redgate are inviting senior data professionals to attend one of the upcoming SQL in the City Summit events taking place in April, May and June. If you’re interested in learning how your business can benefit from implementing Compliant Database DevOps this event is for you. Find out who’s presenting and register for a Summit near you today. Register now
Tracking the number of active sessions on a database using SQL Monitor
Phil Factor creates a simple custom metric to track the number of sessions that have recently done a read or write on a database. Having established a baseline for the metric, you'll be able to spot, and investigate the cause of, any wild deviations from normal behavior.
Can Azure Stack Reduce Software Development Costs?
Azure Stack provides a hybrid cloud infrastructure platform. Steve wonders if this really helps reduce software development costs.
5 reasons why backup and restore doesn’t cut it in dev and test
The provisioning process is a critical part of database development. Redgate's Rebecca Edwards looks at a tool that can remove the pain points of backup and restore and replace them with a more efficient solution can hugely benefit your organization and the quality of life of you and your team.
SQL Server Database Users to Roles Mapping Report
In this tip we look at a SQL Server function that generates a report of all users and their assigned database roles.
Changing Context and Data Reuse
We don't have strong data consent rules in the US, but Steve thinks we should.
Uploading On-Premises Data as JSON to Azure Blob Storage using SSIS
Using Azure Feature Pack for Integration Services to access Blob storage from Azure into SSIS packages
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 KCU KUTA Telp:Cs.08216977726
Whatsapp:08216977726 Jl. Sunset Road No.88B, Kuta, Kec. Kuta, Kabupaten Badung, Bali 80113
BCA KCU PLUIT Telpon/WA:.085188120691
BCA KCU PLUIT Telpon/WA:.085188120691 Landmark Pluit, Jl. Pluit Selatan Raya Blok A8, RT.8/RW.10, Pluit,...
BCA KCP Kertajaya Indah No.Telp:087757645171
Whatsapp:087757645171 Jl. Manyar Kertoarjo No.95, Mojo, Kec. Gubeng, Surabaya, Jawa Timur 60285
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