Looking Back at Software Development Trends
Steve looks at some of the software development trends from last year, and if they apply today.
Clarifying Data Warehouse Design with Historical Dimensions
The standard data warehouse design from Kimball with facts and dimensions has been around for almost 25 years. In this article, Vince Iacoboni describes another way to design slowly changing dimensions.
Deployment Suite for Oracle: What’s New? Git Integration in Redgate Change Control v3.0
In Redgate Change Control v3.0, you can now commit your database changes to your local Git repository and collaborate with your team by pushing and pulling changes from the remote Git repository. If you’re using branches, you can also create and switch Git branches from within Redgate Change Control.
Of Hedgehogs and Database Design
One of the finest songs of the sixties had the following lines … "Sitting one day by myself, And I'm thinking, "What could be wrong?" When this funny little Hedgehog comes running up to me, And it starts up to sing me this song. Oh, you know all the words, and you sung all the […]
Native SQL Backups for Amazon RDS Databases
Use native SQL Server backups with Amazon RDS databases to easily import and export data between local server and the AWS cloud.
What's the Bus Factor?
Today Steve asks about the people that might be critical in your organization.
Compare Artificial Intelligence Models Built with T-SQL
This tip looks at using artificial intelligence models with SQL Server to predict outcomes.
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.
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 Asia Mega Mas Tlpn/wa:085373737551
Jl. Komp. Asia Mega Mas Jl. Asia Raya No.42 Blok B, No. 41, Sukaramai...
BCA KCP Sumatera Tlpn/wa:085373737551
Jl. Aiptu K.S. Tubun No.46, Pandau Hulu I, Kec. Medan Kota, Kota Medan, Sumatera...
BCA KCP Pusat Pasar Tlpn/wa:085373737551
Medan Mall, Kompleks No.10, Pusat Ps., Kec. Medan Kota, Kota Medan, Sumatera Utara 20212
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