Viewing 15 posts - 406 through 420 (of 593 total)
tkleinhans 1851 (1/22/2016)
And now, a story.
Many years ago, I became a database administrator via the accidental dba path having started as a...
January 23, 2016 at 9:09 am
Thank you, Orlando.
January 23, 2016 at 8:37 am
Happy New Year's Everyone!
There are two languages I would like to learn this year. First, I'd like to learn R. My Bachelor's is in Mathematics. I've always enjoyed data analysis,...
January 1, 2016 at 7:46 am
I really want to say thank you for this wonderful website and especially these forums! I've gained more than I ever could give back here. Thank you to all the...
November 29, 2015 at 6:41 pm
dallas-1069889 (10/16/2015)
I'd like to mention the book Expert Business Objects by Rockford Lhokta. One of the principles of the application architecture used in the book is that business logic...
October 17, 2015 at 6:43 am
I started in my current job 6 months ago. I work for a large state department. They have a lot of old MS Access databases and applications. (Over 100 at...
October 3, 2015 at 9:01 am
OK I now see what I did wrong. I guess the default backup mechanism is to append to the backup set. What I really wanted, at least when moving the...
August 15, 2015 at 7:27 am
Perry Whittle (8/10/2015)
please also run a RESTORE HEADERONLY and provide this info so that we may confirm the actual database name the backup references
This one is more interesting. Here's the...
August 15, 2015 at 7:05 am
Perry Whittle (8/10/2015)
As suggested run restore filelistonly against the backup file and post back the results
Here are the results of my doing a RESTORE FILELISTONLY against the backup file:
LogicalNamePhysicalNameTypeFileGroupNameSizeMaxSizeFileIdCreateLSNDropLSNUniqueIdReadOnlyLSNReadWriteLSNBackupSizeInBytesSourceBlockSizeFileGroupIdLogGroupGUIDDifferentialBaseLSNDifferentialBaseGUIDIsReadOnlyIsPresentTDEThumbprint
VideoLibrary_DataC:\Program Files\Microsoft...
August 15, 2015 at 7:01 am
Earlier I said I don't rename things like tables. And that for the most part I oppose it. Well, I've been handled a new project at work, having to take...
June 13, 2015 at 10:37 pm
Steve Jones - SSC Editor (5/24/2015)
Doctor Who 2 (5/24/2015)
How do you do unit tests in T-SQL?
Go to tsqlt.org to get a framework. There are others, like dbunit, tsqlunit, etc., but...
May 24, 2015 at 6:38 pm
David.Poole (5/24/2015)
Doctor Who 2 (5/24/2015)
How do you do unit tests in T-SQL?
Try http://www.red-gate.com/products/sql-development/sql-test/
It is possible to devise your own method of initialising a starting set of data, executing your...
May 24, 2015 at 6:38 pm
I agree with you in principal but sometimes, due to things out of your control, you can't do anything about it. I'm in a situation now where I have identified...
May 24, 2015 at 5:17 pm
I've used SSMS mostly and prefer it. I've not really used SSDT all that much. Can you do things like create SQL Jobs in SSDT?
April 5, 2015 at 1:42 pm
Viewing 15 posts - 406 through 420 (of 593 total)