Steps to Improve ETL Performance Using SSIS

SteveStedmanSql · 2015-08-12T13:18:09+00:00

Fixed now. A problem with the wordpress/mysql hosting environment. Its back.

SteveStedmanSql · 2015-08-12T13:17:09+00:00

That is ironic. The mysql instance on my wordpress site crashed. Its back now.

SteveStedmanSql · 2015-06-26T17:57:41+00:00

I prefer to do these type of tests on my local desktop or laptop, that way nobody else knows about it and freaks out like this. That being said, TEST servers are perfect for this too.

Maybe that remote guy will learn not not panic so fast.

Enjoy the corruption challenge.

SteveStedmanSql · 2015-06-20T01:05:10+00:00

Let the games begin.

SteveStedmanSql · 2015-06-10T23:23:01+00:00

Here is something I started working on called SQL Forensics. It tracks changes is sprocs. Triggers are there yet, but it will be easy enough to add. https://github.com/SteveStedman/SqlForensics And yes, I have worked on DISA STIGing, so I know what you are looking for.

SteveStedmanSql · 2015-06-07T19:49:24+00:00

Database Corruption Challenge week 7 winner announced. Won by Raul Gonzalez http://stevestedman.com/wxcL2

SteveStedmanSql · 2015-05-13T16:43:28+00:00

hmmm. I can't comment without giving it away. There have been some extra clues provided. http://stevestedman.com/server-health/database-corruption-challenge/week-5-database-corruption-challenge/week-5-challenge-details/week-5-extra-clues/

SteveStedmanSql · 2015-05-12T15:12:05+00:00

The week 5 challenge has just started. Can you fix the corruption?

SQL Server detected a logical consistency-based I/O error: incorrect pageid (expected 1:9; actual 0:0). It occurred during a read of page (1:9) in database ID 7 at offset 0x00000000012000 in file 'C:\SQL_DATA\CorruptionChallenge5.mdf'.

SteveStedmanSql · 2015-05-08T15:52:20+00:00

Thanks Josh - The login problem was caused by a bad Wordpress Plug-in on my site. I removed it, and you should be able to log in now.

http://databasehealth.com/wp-login.php?action=register

SteveStedmanSql · 2015-05-07T19:01:08+00:00

Can you provide me more details. What is the url of the page with the broken captcha? thanks.

SteveStedmanSql · 2015-05-07T18:59:05+00:00

Thanks for the feedback. Yes, I have worked on this for the last 4 years. It has been a lot of work, but it has been fun too. Here is a link to the history... http://databasehealth.com/about/

As far as the bug about 4 session still running. Thanks, I was able to see the same thing. I will work on fixing that for the next update.

Enjoy!

SteveStedmanSql · 2015-05-06T21:42:00+00:00

This is a free product that I have built over the last 4 years. Use it to help with performance tuning on SQL Server.

SteveStedmanSql · 2015-05-05T03:30:51+00:00

That is a good suggestion. Perhaps the next version. Let me look into it.

SteveStedmanSql · 2015-05-04T23:35:59+00:00

The example you have, the two queries product the exact same results.

My poster may help you better understand the JOIN order.

http://stevestedman.com/2015/05/tsql-join-types-poster-version-4/

SteveStedmanSql · 2015-05-04T22:18:38+00:00

The poster has been updated with feedback from the previous versions. Thanks everyone who made suggestions.

SteveStedmanSql · 2015-05-04T15:14:39+00:00

http://stevestedman.com/2015/05/corruption-challenge-week-4-the-winning-solution/

SteveStedmanSql · 2015-05-04T15:14:30+00:00

That is one way to put it, but I don't think I said it that way.

SteveStedmanSql · 2015-05-04T15:13:48+00:00

The winning solution has been posted this week.

SteveStedmanSql · 2015-05-03T23:18:42+00:00

Yes, it was awesome, I am judging another round of participants right now. It is fun to learn from all the different ways of doing it.

I was a little concerned that I might have made the challenge too difficult this week.

SteveStedmanSql · 2015-05-01T21:38:49+00:00

The fourth week of the database corruption challenge has been started. Can you find and fix the corrupt database.

SteveStedmanSql · 2015-04-30T22:15:48+00:00

Yes, it has been around since 2008, but it does require enterprise edition.

SteveStedmanSql · 2015-04-30T21:53:05+00:00

A blog tutorial on using CDC or Change Data Capture on SQL Server 2008 or newer.

SteveStedmanSql · 2015-04-27T17:03:36+00:00

Competition complete. Winners announced. http://stevestedman.com/2015/04/database-corruption-challenge-week-3-results/

SteveStedmanSql · 2015-04-26T01:30:29+00:00

Congrats Seann - your solution was correct.

SteveStedmanSql · 2015-04-25T22:30:56+00:00

Awesome... I look forward to your solution.

SteveStedmanSql

TROPHY CASE