Stairway to Transaction Log Management in SQL Server, Level 1: Transaction Log Overview
The transaction log is used by SQL Server to maintain data consistency and integrity. If the database is not in Simple-recovery mode, it can also be used in an appropriate backup regime to restore the database to a point in time.
How to Load a Date Dimension in Microsoft Fabric using Macros in dbt?
The article A gentle introduction to dbt explains how you can get dbt in the cloud version, how you can set up a free account, and how to create a connection to a Microsoft Fabric warehouse.
Navigating Your Test Data Challenges: Insights and Solutions
Join Redgate on May 1st for an insightful webinar cohosted with analyst firm, Bloor Research, featuring independent Senior Analyst Daniel Howard and Redgate's Steve Jones. Discover the biggest test data challenges, the latest approaches like AI synthetic data generation, and how effective test data management can benefit your entire organization. Don't miss out on this opportunity to gain valuable insights and solutions.
Is SQL Server Feature Complete?
Steve asks the question about whether you think SQL Server is feature complete today.
Using try catch in SQL Server stored procedures
A great new option that has been around since SQL Server 2005 is the ability to use the Try..Catch paradigm that exists in other development languages. Doing error handling in SQL Server has not always been the easiest thing, so this option definitely makes it much easier to code for and handle errors.
Life Moves Pretty Fast
Driving my soon-to-be granddaughter to school today (my son is getting married and will adopt the young lady), we saw a dead armadillo, a turtle in the road (rescued it) and an escaped cow (left it alone). THEN... old soon-to-be granddad had forgotten lunch, so had to deliver that back at the school (cow must […]
50 Years of Microsoft
Steve looks back at his history with Microsoft and asks what your memories are of using their products.
Retrieving Data Using the REST API in Data API Builder
I wrote a piece on getting started with the Data API Builder (DAB), which looked at how this product works and how to start using it. That was a basic look, but it gives data professionals an idea of how this might help them work more closely with front-end developers who are more comfortable with […]
Blogs
Five Ways Redshift Serverless Quietly Eats Your Budget
It is Friday, the queries are running, and nobody is watching the bill. That...
A Career of Memories
By Steve Jones
Annabel retired from Redgate Software this week. Across most of my career at Redgate,...
Rethinking Index Maintenance: Why avg_fragmentation_in_percent Is Outdated and What You Should Do Instead
By Tim Radney
As a SQL Server DBA with years of experience tuning production environments, I’ve seen...
Forums
Alamat Kantor BCA KCP Bumiayu Telp:0817866887
WhatsApp:0817-866-887 Jl. Kalierang No.Ruko 3-5, Dukuhturi, Kec. Bumiayu, Kabupaten Brebes, Jawa Tengah 52273 (@bcakcpbumiayu)
BCA KCP Permata Ujung Menteng Tlp:0817839777
WhatsApp: 0817839777 Jl. Raya Bekasi Km. 25 Blok A/17, RW.18, Ujung Menteng, Wil, Kota...
Alamat Kantor BCA KCU RAWAMANGUN Tlp:0817839777
WhatsApp: 0817839777 Jl. Paus No.81, RT.1/RW.8, Wil, Kec. Pulo Gadung, Kota Jakarta Timur, Daerah...
Question of the Day
BCP on Linux
When running bcp on Linux, what is the field terminator?
See possible answers