Viewing 15 posts - 5,581 through 5,595 (of 6,041 total)
Question Guy (6/2/2011)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
June 2, 2011 at 7:54 am
All this talk about code books and elaborate schemes for generating one-off passwords sounds like overkill. If a tornado should strike your company headquarters, I hope you have a backup...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
June 2, 2011 at 7:31 am
If you're an employee or sub-contractor, then you can (and should) acknowledge the need for external expertise, but that decision is ultimately out of your hands.
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
June 2, 2011 at 7:25 am
Steve Jones - SSC Editor (5/31/2011)
Assertions are a great extra check, Eric. Thanks for the note.
I'd much rather have the production control team notify me that a script failed to...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
May 31, 2011 at 10:20 am
One other thing I'd like to add about deploying ad-hoc change scripts; I also wrap the DML or procedure calls in a transaction and add assertions on the expected number...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
May 31, 2011 at 8:33 am
In the past, whenver a "data fix" was required in production; a change order was created, and I'd write a T-SQL script which would go though the normal version control,...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
May 31, 2011 at 8:17 am
Ukon (5/28/2011)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
May 31, 2011 at 7:47 am
You can bind LINQ to stored procedures, but it would involve more coding. As a compromise you could offer to create a collection of views for use by their application....
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
May 27, 2011 at 3:44 pm
sqldba_icon (5/23/2011)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
May 27, 2011 at 6:55 am
Managing backups has never been my role, so I'm not too familiar with the technicals of how the various 3rd party solutions manage the keys. My question is: Does the...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
May 27, 2011 at 6:35 am
As already suggested, look at the query execution plan to know what happending. To help things, I'd suggest inner joining that table SaveSets instead of using a sub-select in the...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
May 23, 2011 at 2:57 pm
Lawrence Moore (5/23/2011)
Many thanks for your post.
It is true that DMVs offer lots of useful information, some of which could be applied for requirements discussed in my article.
However, DMVs...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
May 23, 2011 at 2:49 pm
virtualjosh (5/23/2011)
SELECT @expiration_dt = [modify_date]
FROM [mydb].[sys].[tables]
WHERE [name] = 'mytable'
If I detect @expiration_dt to be newer than my stored...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
May 23, 2011 at 11:07 am
SQL Server maintains statistics, which includes counts and timestamps, whenever table indexes are updated. This meta data can be queried from an interesting data management view called sys.dm_db_index_usage_stats. For some...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
May 23, 2011 at 7:45 am
Just show up for their next monthly meeting.
http://www.sqlpass.org/PASSChapters.aspx
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
May 23, 2011 at 6:29 am
Viewing 15 posts - 5,581 through 5,595 (of 6,041 total)