What is a good Disaster Recovery Plan?
During a Q&A session I hosted at our local Calgary SQL Server User Group last month, one of the attendees...
2017-07-19
150 reads
Randolph West
- Twitter: @_randolph_west
- Website: https://bornsql.ca/blog/
- LinkedIn: https://linkedin.com/in/rabryst/
Be Wary of Date Formatting in T-SQL
Today’s public service announcement is a reminder to be wary of date formatting in SQL Server. On a recent mailing...
2017-07-12
151 reads
Balanced Power Saving T-SQL script
We can easily spend tens of thousands of dollars on core licences for SQL Server, and then we go and...
2017-07-05
172 reads
Where To From Fundamentals?
The Database Fundamentals series is now done. We started with understanding what a database is, and then spent a little...
2017-06-28
345 reads
Why You Need A Test Environment
In 2017, there’s no excuse not to have at least a testing environment, and preferably a development environment as well,...
2017-06-21
131 reads
How to write a DELETE query
My First DELETE Statement Here are the links to the previous posts in this series: My First SELECT Statement My...
2017-06-14
142 reads
How to write an UPDATE query
My First UPDATE Statement Last week we covered how to put information into a table using an INSERT statement. This...
2017-06-07
130 reads
How to write an INSERT query
My First INSERT Statement Last week we covered how to get information out of a table, using a SELECT query....
2017-05-31
390 reads
How to write a SELECT query
My First SELECT Statement Microsoft SQL Server makes it really easy for us to query tables. In SQL Server Management...
2017-05-24
160 reads
Querying a Database
When we want to retrieve information from a database, we query the structure with language appropriate to the database. Remember...
2017-05-17
99 reads
Blogs
The Book of Redgate: Meetings
By Steve Jones
I think we might have forgotten this a bit, but on one of the...
New article: Automating SQL Server Builds
By Brian Kelley
I refresh my test SQL Servers at least monthly with a fresh VM. Setting...
Leading with Accountability: How Extreme Ownership Transforms Leadership
By Chris Yates
Embracing Total Responsibility In every organization there comes a moment when teams must choose...
Forums
MySQL 5.6 not writing any logs
We are using MySQL version 5.6 in our Windows Server 2012 R2 environment. We...
How to resolve issue of custom Audit log table containing incorrect data?
We have created a parent table, child table & Audit log table in SQL...
Change Tracking Default Retention
Comments posted to this topic are about the item Change Tracking Default Retention
Question of the Day
Change Tracking Default Retention
I run this command on my SQL Server 2022 database:
ALTER DATABASE AdventureWorks2017 SET CHANGE_TRACKING = ON;What is the default data retention period? See possible answers