PASS Summit 2016-Thursday Part II
The second half of the day was spent talking with various speakers and attendees. I got into a great conversation...
2016-10-28
803 reads
The Smiling DBA
PASS Summit 2016-Thursday Part 1
Today’s keynote was by David Dewitt. He did an excellent job explaining the architecture behind various Cloud Data Warehouse offerings....
2016-10-27
399 reads
PASS Summit 2016-Wednesday
As all Summits, the first Regular Session day in Seattle started with the Keynote. Well, really it starts with a...
2016-10-27
488 reads
PASS Summit 2016–Tuesday
For the first day at the Summit this year, I spent half my time in a Pre-Conference session with Idera...
2016-10-25
467 reads
VOTE!!! PASS Board of Director Elections
It is voting season again, and there is a great group of individuals running for the Board of Directors of...
2016-10-06
354 reads
Live! 360–Speaking at SQL Server Live Orlando 2016
If you are looking for a great conference to attend, please look at Live! 360. This event combines 6 different...
2016-09-10
603 reads
Using a Lookup Component in SSIS for Surrogate Keys in a Fact table
There are many suggestions for loading a data warehouse using SQL Server integration Services (SSIS). Once you get started, you...
2016-07-26 (first published: 2016-07-21)
5,305 reads
PASS Summit 2016 – Connect, Share, Learn
Please join me and about 4000+ other technology professionals for the annual PASS Summit in Seattle, WA October 24th – 28th....
2016-06-24
535 reads
Why use a Date Dimension Table in a Data Warehouse
In the Data Mart, or the Data Warehouse world, there is a date dimension table in all schemas if you...
2016-06-06 (first published: 2016-05-29)
7,108 reads
SQLSaturday Atlanta #521 May 19th & 20th 2016
SQLSaturday events are a pleasure to be a part of whether it involves speaking or volunteering. Volunteering definitely takes more...
2016-04-23
633 reads
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