Free Tools, Does Innovation Matter?
Today we have a guest editorial from Brian Walker, the developer for SQLFacts. He discusses the value from his toolkit and why it can be useful for developers.
Horizontal Trees
Introduction The sp_HorizontalTree procedure introduced here may be used to audit tables with dependent columns. A column is dependent on another if the meaning of the first column depends on the meaning of the second. For example, in a table containing accounting information, the meaning of a Fiscal Quarter column depends on the Fiscal Year to […]
How to Visualize Timeseries Data with the Plotly Python Library
Learn how to use the Plotly library to visualize time series data in Python in this step-by-step article.
Using Windows Security and Encryption with Flyway
This article describes a simple technique that will allow you to use Flyway securely, even in cases where more than just the login credentials need to be protected. It uses a PowerShell technique that converts an encrypted Flyway configuration file into an array of parameters that Flyway can read just as if you were typing them in.
Actively Choosing Compatibility
Do you actively choose which compatibility level makes sense for your SQL Server databases? Or do you just take the defaults? Steve has a few thoughts today on actively managing your system.
Building a Kimball Data Warehouse
Learn about the Kimball method for data warehouses and how you can get started building one.
Calculating Prime Numbers With One Query
This article looks at calculating prime numbers less than n with one query.
Are PostgreSQL memory parameters magic?
Ordinary PostgreSQL users often do not know that PostgreSQL configuration parameters exist, let alone what they are and what they mean. Some parameter tuning can improve the database performance, and we are usually talking about 10%, 20%, and in rare cases, up to 50% performance improvement.
T-SQL Scripts to generate the HTML-formatted database storage report
This article will show how to generate an HTML formatted report of your disk space.
Using the Lightweight Tools
This week Steve is interested in whether the newer lightweight environments, like VS Code and Azure Data Studio, are capturing your interest.
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