Number of Rows Read / Actual Rows Read warnings in Plan Explorer
Rob Farley looks at information exposed in query plans about residual predicates and actual rows read, showing how Plan Explorer helps identify the issue.
Databases in Azure: Copy and Exports
Toady we are going to make a copy and export your DB to Azure Storage. Lets get started.
Scary Deployments
Today Steve Jones talks about the problem of having code that people are afraid to change or deploy.
Planning for a Successful Database Lifecycle
Although it is well-known that the best efforts of a development team can be derailed by mistakes in the architecture, design and general governance of a development project, few attempts have been made to describe what needs to be done to increase the chances of success in the development of a database application. William Brewer steps into the breach to itemise what a delivery team needs to succeed.
Delivering Rapid Improvements to SSMS
SSMS has spent years being neglected, merely being kept compatible with SQL Server and its features: But now we have, instead, the promise of monthly delivery of new functionality
Security is Getting Serious
Today Steve Jones notes that back doors could be inserted into chips, which would be a huge problem.
SQL Authentication Via AD Groups Part III: What About Orphaned Users?
With AD Authentication via groups, SQL Server is vulnerable to orphaned Windows users' logins being added to SQL Server at a later date. This article gives an improved user audit script that detects orphaned DB Users and also a delete script.
Encrypting and Decrypting SQL Server Stored Procedures, Views and User-Defined Functions
You work in a shop that puts business or application logic in SQL Server using stored procedures, views and functions to return values to the calling applications or perform tasks. This is not unusual for companies that use the SQL Server layer to perform
SQL Server 2016 - what's changed in the SQL Toolbelt?
Over recent months, Redgate’s development teams have been busy updating the tools in the SQL Toolbelt to support the valuable new functionality released with SQL Server 2016. To achieve this, most tools now support the syntax for SQL Server 2016’s key features, letting you do even more with them. Learn mor.
The Remote DBA
This Friday, Steve Jones asks if you're like to work remotely. With the trend moving this way, mostly for extra hours, maybe you'd like to move that way for most of your work time.
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 Kertopaten Telpon. 083135766741
WhatsApp 083135766741 Jl. Pegirian No.114, RT.007/RW.10, Sidodadi, Kec. Simokerto, Surabaya, Jawa Timur 60145
BCA KCP Kas Palu Barat Telp:Cs.083831618816
Whatsapp:083831618816 Jl. Sungai Malei No.35, Ujuna, Kec. Palu Bar., Kota Palu, Sulawesi Tengah 94111
BCA KCU PALU Telp:Cs.08216977726
Whatsapp:08216977726 Jl. Moh. Hatta No.29, Lolu Utara, Kec. Palu Sel., Kota Palu, Sulawesi Tengah...
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