Viewing 15 posts - 3,961 through 3,975 (of 6,035 total)
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...
April 21, 2015 at 2:54 pm
John Hanrahan (4/21/2015)
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...
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,...
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...
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...
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.
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...
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...
April 20, 2015 at 9:13 am
I believe the vast majority of SQL Server DBAs and developers understand the virtues of leveraging stored procedures for practically all database access. It's the application developers you have to...
April 20, 2015 at 9:03 am
Peter Schott (4/17/2015)
April 17, 2015 at 12:04 pm
Wayne West (4/17/2015)
Eric M Russell (4/17/2015)
April 17, 2015 at 11:09 am
Given the scenario, I'd leave power cord, mouse, umbrella, coffee, and egg bagel at the table, but not my laptop. It's too easy to just unplug and pack it with...
April 17, 2015 at 9:09 am
Gary Varga (4/17/2015)
Eric M Russell (4/17/2015)
Gary Varga (4/17/2015)
So we need to consider the failing of aspects of SLAs which might be too risky to ignore.
Just as the IT department has...
April 17, 2015 at 9:00 am
Some ALTER DATABASE operations can clear the buffer and procedure cache, so that can also explain a brief period of higher physical reads and CPU immediately following a deployment.
April 17, 2015 at 8:23 am
Viewing 15 posts - 3,961 through 3,975 (of 6,035 total)