Viewing 15 posts - 3,961 through 3,975 (of 6,041 total)
jay-h (4/22/2015)
Eric M Russell (4/22/2015)
...However, the actual error message is a shill. If the perp tabs over to Google and searches on "Error: 8514294078", now their IP address (and maybe...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
April 22, 2015 at 10:20 am
Wayne West (4/22/2015)
Eric M Russell (4/22/2015)
Conceptually, it's like when the police leave an "abandoned" car on the side of the road and wait for theives. ...
Law enforcement has a honeypot...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
April 22, 2015 at 9:30 am
There is no need for sp_executesql.
This should work as is.
SET @AlterSQL = 'ALTER TABLE ' + @DestinationTableName
+ ' ADD ' + @TempColumn + ' int;'
EXEC (@AlterSQL)...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
April 22, 2015 at 8:52 am
Without a firewall, anti-virus software, or enforced security policy; this company can't really say with any degree of confidence what they're infected with or what their employees are doing with...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
April 22, 2015 at 8:02 am
SQLRNNR (4/21/2015)
Give them an account and password...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
April 22, 2015 at 7:53 am
Wayne West (4/21/2015)
Eric M Russell (4/21/2015)
What do you guys think about the honeypot database server to attract...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
April 21, 2015 at 3:20 pm
So did we learn anything today, or was this mostly an offbeat topic?
What do you guys think about the honeypot database server to attract hackers or for duress login...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
April 21, 2015 at 2:54 pm
John Hanrahan (4/21/2015)
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
April 21, 2015 at 12:46 pm
Iwas Bornready (4/21/2015)
I love it. Make a movie.
We need an action movie where the hero is a fed up IT guy. It seems like we always get marginalized as supporting...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
April 21, 2015 at 11:07 am
On the Microsoft platform:
HDInsight for raw bulk storage, SSIS for connecting most anything to most anything else, SQL Server / SSAS for building the single version of truth database,...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
April 21, 2015 at 11:02 am
mayurkb (4/17/2015)
Does everything that apply to data warehouse also apply to datamart? We are not really IT and not making a datamart for my company. We...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
April 21, 2015 at 10:37 am
The user id + duress password combination should redirect to a "honeypot" server that mimics a production envrionment in such a way that it would take some time for the...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
April 21, 2015 at 8:29 am
My experience has been that, for both data warehouses and transactional databases, disk I/O is the biggest bottleneck. If you're maxing out CPU, then look for recompiles or cursors.
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
April 20, 2015 at 11:57 am
Encapsulating the database through stored procedures does require a degree of constant communication and collaboration between the application and database team. For example, I've seen cases where app or BI...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
April 20, 2015 at 10:07 am
Here is a good article written by Adam Machanic back in 2006 that advocates the use of stored procedures using the concepts of decoupling, cohesion, and encapsulation. Funny how, after...
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
April 20, 2015 at 9:13 am
Viewing 15 posts - 3,961 through 3,975 (of 6,041 total)