Admin Challenges Across Scale and Time
The challenges of large scale administration can be complex, but the more we share, the more we help others learn and better manage systems.
Getting started with SQL Server stored procedures
In this article we look at different examples of creating SQL Server stored procedures.
Introducing SQL Change Automation 4.3
The latest version of SQL Change Automation now integrates with SQL Clone to let you use a snapshot of your database’s schema as a baseline. This simplifies migration development in complex databases, avoiding problems like invalid objects or circular dependencies, and you can verify migration scripts on a copy of the currently released database.
A One-Slide Summary of the Differences Between TDE and Always Encrypted
Read a One-Slide Summary of the Differences Between TDE and Always Encrypted from Brent Ozar.
Redgate Streamed Returns
Our virtual community event is back with a global feel. Featuring speakers including Donovan Brown, Abel Wang, Kendra Little & Damian Brady, we have a full day of live content & networking opportunities, spanning world-wide time zones. So, wherever you are in the world, join us live on Wednesday August 26.
Recover database encrypted modules code with dbatools
If you own a database with encrypted modules but you don't have a decrypted version, this can be a horror story.
Learn how to get back the code of the encrypted modules using dbatools.
Maximize View of SQL Server Query Plans with Full Screen Option
In this tip we look at how to save an execution plan for future review as well as using the full screen mode to see more of a query plan at one time.
How to override Date Filters in Power BI
Problem A few weeks back, I got a request from a client of mine who had a very special requirement. They wanted to display values for a specific period in the past based on the selected dates in the Power BI report. Let us assume that if we select 30 June 2020, the report has to […]
Blogs
T-SQL Tuesday #198 Invitation: How Do You Detect Data Changes?
It's time for T-SQL Tuesday #198! This month's topic is change detection. The post T-SQL...
Understanding Fabric MCP
By James Serra
Model Context Protocol, or MCP, is one of those technical ideas that sounds more...
AWS RDS Aurora - our first approach
When starting with AWS RDS Aurora for managing relational databases in the cloud, many...
Forums
Alamat kontak resmi BCA KCU PURWOKERTO | Telp: 0817825533
phone, Wa: 0817825533, Jl. Jend. Sudirman No.391 A, Brubahan, Purwanegara, Kec. Purwokerto Tim., Kabupaten...
Kantor BCA Finance pusat Hub.0851•8812•0691
Kantor BCA Finance pusat Hub.0851•8812•0691 Jl. Metro Pondok Indah No.10 Lt 2, RT.3/RW.17, Pd....
Alamat kontak resmi BCA KCU PEKALONGAN | Telp: 0817825533
phone, Wa: 0817825533, Jl. Diponegoro No.27, Dukuh, Kec. Pekalongan Utara, Kota Pekalongan, Jawa Tengah...
Question of the Day
May the Fourth Be With You Fun
In honor of May the fourth and Star Wars (may the force be with you), finish this quote:
"Do, or do not. ..."See possible answers