How to read the SQL Server Database Transaction Log
In this tip we will take a look at a SQL Server function that you can use to read the SQL Server transaction log to see what entries are made for database transactions.
In this tip we will take a look at a SQL Server function that you can use to read the SQL Server transaction log to see what entries are made for database transactions.
Learn how you can execute multiple scripts in a restrictive database environment that doesn't allow any third-party tools.
If you’ve got a great idea for transforming software development or IT processes in your organization, but you’re not sure how to get buy-in from key stakeholders, or how to change your company culture check out this free webinar featuring Ike Ellis, Data Platform MVP! In this session, Ike will draw on his experience as a consultant and leader in software development to give you real-world tips to define, shape, and share your pitch successfully.
Compare common approaches to provisioning test data to database development teams, and assess how they stack up in terms of delivering realistic test data, managing bottlenecks, and meeting data privacy regulations.
Today, more organisations are adopting DevOps over older, traditional practices. In this article, Robert Sheldon explains DevOps and compares it to Waterfall and Agile methodologies.
A government is fined for allowing inappropriate access to data. That might be something we deal with in other companies at some point.
Grant Fritchey shows how to provision a group of interdependent databases, masked to protect sensitive or personal data, to each machine in an Azure-based test cell.
Redgate's second annual State of SQL Server Monitoring survey provides new insights into how the world of SQL Server monitoring is adjusting and adapting to emerging challenges, such as compliance regulations and cloud technologies, while keeping on-top of the usual issues such as deployments, availability, and capacity.
Availability databases hosted on SQL Server Always On Availability Groups (AG) can be connected using a unique Virtual Network Name (VNN), called the Availability Group Listener. When an Availability Group is enabled, clients can connect to databases in both primary and secondary replicas without explicitly specifying the SQL Server instance name. You don’t even need […]
By Steve Jones
We’re coming back to New York, which is exciting for me. I love NYC....
I previously wrote about how the underlying technology for Fabric mirroring changed with SQL...
By Steve Jones
At the recent Redgate Summit in Chicago, I demo’d (lightly) the ML based Alert...
Comments posted to this topic are about the item Seeding a Fabric Warehouse with...
Comments posted to this topic are about the item Seeding a Fabric Warehouse with...
Comments posted to this topic are about the item Doing the Little Things
If I want to track historical data values, which mechanism should I use?
See possible answers