Viewing 15 posts - 4,756 through 4,770 (of 9,722 total)
MysteryJimbo (2/1/2012)
Koen Verbeeck (1/31/2012)
Brandie Tarvin (1/31/2012)
Of all the skills a DBA should have, I'm beginning to think a healthy dose of paranoia should be on the required list. Agree? Disagree?
Agree.
Just...
February 1, 2012 at 5:15 am
Near the beginning of the month, my boss says "why aren't these files being removed from the Inbound folder? Add a task to this SSIS package that deletes them as...
January 31, 2012 at 3:49 pm
Daniel Bowlin (1/31/2012)
crookj (1/31/2012)
SQLRNNR (1/31/2012)
rockPet
Commodore
Band
January 31, 2012 at 12:15 pm
Greg Edwards-268690 (1/31/2012)
Brandie Tarvin (1/31/2012)
SQLRNNR (1/31/2012)
Greg Edwards-268690 (1/31/2012)
Koen Verbeeck (1/31/2012)
Greg Edwards-268690 (1/31/2012)
Must have been the 3rd table that caused the confusion.Book only showed 2 in an example.
😀
Shows what happens when...
January 31, 2012 at 9:29 am
DR and HA are NOT the same thing, nor should they be confused as such. Replication is an acceptable solution for High Availability, but it will not completely recover your...
January 31, 2012 at 9:16 am
I did assume that SQL Express itself was installed. Whoops. Bad Brandie.
January 31, 2012 at 9:06 am
SQLRNNR (1/31/2012)
Greg Edwards-268690 (1/31/2012)
Koen Verbeeck (1/31/2012)
Greg Edwards-268690 (1/31/2012)
Must have been the 3rd table that caused the confusion.Book only showed 2 in an example.
😀
Shows what happens when I think - other...
January 31, 2012 at 8:40 am
I'm not sure what you mean by empty. Could you clarify?
January 30, 2012 at 7:54 am
Ouch. Sounds like you have SDLC issues.
Is there a reason you can't use the Information_Schema and sys.objects tables / catalog views to do the checking with each addition / change...
January 30, 2012 at 7:51 am
Find the installation logs and verify that SQL Express installed correctly. Also, check your services to make sure that SQL Server service and SQL Agent Service are both running. You...
January 30, 2012 at 7:44 am
Use the Information_Schema catalog views to spit out a table / column list. Adjust the below code as necessary:
SELECT Table_Catalog, Table_Schema, Table_Name, Column_Name, Is_Nullable,
Column_Default, Data_Type, Character_Maximum_Length as ChLen,
numeric_Precision,...
January 30, 2012 at 7:39 am
SQLKnowItAll (1/27/2012)
Brandie Tarvin (1/27/2012)
SQLKnowItAll (1/27/2012)
January 30, 2012 at 7:26 am
SQLKnowItAll (1/27/2012)
January 27, 2012 at 12:46 pm
Jared,
Actually, I'm approaching this from the POV of someone who did DR & BC design at a previous employer far far before I ever became a DBA.
It's obvious to...
January 27, 2012 at 12:15 pm
Viewing 15 posts - 4,756 through 4,770 (of 9,722 total)