Viewing 15 posts - 2,446 through 2,460 (of 6,041 total)
GilaMonster (7/27/2016)
Eric M Russell (7/26/2016)
Rod at work (7/26/2016)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
July 27, 2016 at 9:04 am
Auto formatted code can look a bit dry. If you think it's worth spending a little money on genuine hand crafted SQL formatting (with all the little ticks and imperfections...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
July 26, 2016 at 1:38 pm
Rod at work (7/26/2016)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
July 26, 2016 at 11:31 am
A CXPACKET (packet exchange) wait state means that one or more operations in your execution plan is running parallel and execution has paused to wait for one of the threads...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
July 26, 2016 at 9:04 am
David.Poole (7/26/2016)
Stress testing is incredibly important. The reason for separating out unit, integration,...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
July 26, 2016 at 8:50 am
I wouldn't blame a botched deployment at a national financial services corporation on one single person. When it comes to enterprise scope deployments, you definately want more than just one...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
July 26, 2016 at 6:46 am
.. The situation changed slowly. So slowly, I didn’t totally notice at first. I found my co-workers and boss took me for granted. More and more I was only doing...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
July 25, 2016 at 3:33 pm
Steve Jones - SSC Editor (7/25/2016)
Eric M Russell (7/25/2016)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
July 25, 2016 at 3:12 pm
When I'm writing a new SQL query, I'll mockup 10x the amount of data currently in production for the subset of tables that are relevent to query, so I can...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
July 25, 2016 at 9:15 am
It depends on the organization and the project, but one barrier to unit testing is that many database development teams simply develope or deploy in discrete units. SQL coding has...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
July 25, 2016 at 8:47 am
Sean Lange (7/20/2016)
Eric M Russell (7/20/2016)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
July 21, 2016 at 12:40 pm
Within the stored proceure, you could contain most of your T-SQL, or at least the most sensive parts, encrypted in a varbinary(max) variable. The symmetric key could then be supplied...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
July 20, 2016 at 3:32 pm
It seems to me that most database breaches are the result of hackers exploiting web based applications with public facing surface area. For example, unencrypted wifi on point of sales...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
July 20, 2016 at 3:17 pm
No more tears.
ALTER SERVER ROLE [sysadmin] DROP MEMBER [<USER_NAME>];
USE <DB_NAME>;
ALTER ROLE [db_owner] DROP MEMBER [<USER_NAME>];
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
July 20, 2016 at 2:11 pm
When it comes to protecting your data from big brother, encryption and good lawyer will buy you some time to ponder your next legal move. Meanwhile, however, you will still...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
July 20, 2016 at 12:59 pm
Viewing 15 posts - 2,446 through 2,460 (of 6,041 total)