Building Helpful Commit Messages
Using a VCS is a core skill, according to Steve. One part of that is learning to write better commit messages.
A MongoDB to SQL Server Migration: Data Typing and Un-nesting
Importing data from one system to another is a common task for database professionals. It’s possible to spend a lot of time figuring out what the schema should be for the target table. In this article, Rodney Landrum demonstrates an interesting solution to automatically figure out the data types and un-nest delimited data.
Download your free copy of the 2019 State of SQL Server Monitoring Report
Over 800 SQL Server Professionals took part in the State of SQL Server Monitoring survey. Providing insights into how they monitor their SQL Server estates, the technologies they work with, what their biggest challenges are, and what the future trends for the industry are likely to be. For the detailed analysis of the responses, download your free copy of the report.
Some of my greatest mistakes
You are never too experienced to make mistakes. An occasional dose of humble pie serves as a reminder to up our game.
Summer Break
Just one day between a holiday and a weekend, so Steve asks for the ways you escape work this summer.
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.
SSIS as an Execution Engine for Multiple Sql scripts
Learn how you can execute multiple scripts in a restrictive database environment that doesn't allow any third-party tools.
Blogs
In Memory of Andrew Clarke, AKA Phil Factor
By Steve Jones
One of the parts of getting older that really sucks is I seem to...
Leading Through the Noise: Harnessing Data in the Age of Digital Overload
By Chris Yates
The New Leadership Frontier In today’s digital landscape, leaders are no longer just visionaries....
A New Word: Anderance
By Steve Jones
anderance – n. the awareness that your partner perceives the relationship from a totally...
Forums
taking the rcsi dive
Hi, we put together an extract that runs every 15 minutes against what i...
Parameter Sensitive Plan Optimization in SQL Server 2022
Comments posted to this topic are about the item Parameter Sensitive Plan Optimization in...
Minimum Change Tracking Retention
Comments posted to this topic are about the item Minimum Change Tracking Retention
Question of the Day
Minimum Change Tracking Retention
If I am running this code:
ALTER DATABASE AdventureWorks2017 SET CHANGE_TRACKING = ON (CHANGE_RETENTION=xxx);What is the minimum amount of time I can set? See possible answers