Easy CDC part 2: Automating a Quick Initial Load, and Some Gotchas
Introduction
A couple of weeks ago I made this post about quickly building a CDC system against a vendor ERP database....
2011-01-01
1,261 reads
Introduction
A couple of weeks ago I made this post about quickly building a CDC system against a vendor ERP database....
2011-01-01
1,261 reads
Managing disk space is an important responsibility of the DBA, and there are many ways to perform this task. In...
2011-01-01
2,506 reads
I just received notification from the Microsoft MVP Award Program that I’ve received the MVP award for SQL Server for...
2011-01-01
743 reads
I received my notice that I was renewed as a MIcrosoft MVP for SQL Server for 2011. It's a nice...
2011-01-01
778 reads
As an experiment, I decided to import the current official TPC-E results spreadsheet into a SQL Server 2008 R2 database,...
2011-01-01
1,239 reads
In previous years I had set goals and even if I didn't fully achieve them, they were helpful in giving...
2010-12-31
2,097 reads
I started the year with 10 Goals for 2010 and now I'll end it by looking at how many of...
2010-12-31
1,587 reads
So I must confess that my blogging efforts to date have been on the impersonal side
– perhaps even a bit...
2010-12-31
1,443 reads
Well it’s Friday again and another big day.
Hopefully you all had a great Christmas and as we move to...
2010-12-31
1,490 reads
Before I went on vacation, I mentioned I was downloading some of the MCM videos from Technet.I had grabbed 4...
2010-12-31
1,617 reads
Businesses are drowning in data, but starving for insights. That's where SQL experts swoop...
By Brian Kelley
The bottom line here is this: the idea that a CSP takes care of...
In today's data-driven world, SQL (Structured Query Language) is a blazing-hot skill. It's your...
Dears, Hope this message finds you well I did not see in this foruns...
The below code works for backup files only from local drives. When replaced with...
I have been asked to fine-tune the following SQL that was written by a...
What are the initial config sizes for the tempdb primary data files, secondary data files, and log files in SQL Server 2022?
See possible answers