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
PlanTrace Now Supports PostgreSQL
PlanTrace Now Supports PostgreSQL The same plan analysis you know from...
A New Word: the Kinder Surprise
By Steve Jones
the kinder surprise – . the point in your early adolescence when you realize...
Crash-Consistent Snapshot Cloning - Hyper-V Edition
If you’ve been following my T-SQL Snapshot Backup series, most of what I’ve covered...
Forums
BCA KCP Plaza Sentral Telpon/wa.0853.7373.7699
BCA KCP Plaza Sentral Telpon/wa.0853.7373.7699.Jl. Jend. Sudirman No.Kav.47, Karet Semanggi, Kecamatan Setiabudi, Kota Jakarta...
BCA KCU RAWAMANGUN Tlpn/wa0853.7373-7551
Tlpn/wa0853.7373-7551 Jl. Paus No.81, RT.1/RW.8, Wil, Kec. Pulo Gadung, Kota Jakarta Timur, Daerah Khusus...
BCA KCP Tomang Raya Tlp/WA.(+62 821°3111°179
Tlp/WA.(+62 821°3111°179 Jl. Tomang Raya No.64, Jatipulo, Kec. Palmerah, Kota Jakarta Barat, Daerah Khusus...
Question of the Day
SSoL Support on the OS
On which Linux versions is SQL Server 2025 on Linux supported?
See possible answers