Do You Still Use CHAR?
When designing a database, choosing good datatypes is important, but not necessarily all the time. Today Steve wonders if you still use fixed sting data types.
SQL Server Development Using Free Tools
You can make SQL Server database development faster and easier with a FREE toolkit!
Reporting on the Progress of a Flyway Database Development Project
This article demos a novel way to report on the progress of your Flyway development project. It provides both SQL and PowerShell versions of code that extracts information for each database version from the Flyway schema history table and then plots it in a Gantt chart.
Vertipaq optimization and its impact on columnstore compression
Vertipaq optimization is a critical component of the columnstore compression process. Edward Pollack explains how it works and what you need to know to manage it.
The Cloud as a Foundation
The innovations and possibilities of cloud computing are exciting to Steve.
Share your insights and help shape the Summit 2022 program
We want to hear from you! Tell us what's important to you by sharing your insights and preferences for PASS Data Community Summit 2022. Community feedback is at the heart of everything we do for Summit and your insights will help guide our planning for this year's conference, taking place online and in-person in Seattle, November 15 - 18, 2022.
Transformations by the Oracle Optimizer
To troubleshoot poorly performing SQL in Oracle, you must understand which transformations the optimizer has made. Jonathan Lewis demonstrates several possible optimizations for one query.
PostgreSQL in Azure using the Azure Data Studio Extension
Learn how to create a PostgreSQL database and work with it from Azure Data Studio.
Speedy Break Fix
Is DevOps and Agile better than waterfall? Steve has a few thoughts after a recent experience.
Enterprise SQL Server Performance Tuning and Management with dbWatch
We need to transition our team from single instance management and monitoring to managing the overall environment and addressing our most pressing needs to support the organization. How can we move from managing the trees to managing the forest in an efficient and automated manner with a small team?
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