Viewing 15 posts - 5,746 through 5,760 (of 6,031 total)
Taking a minimalist approach, SQL Server's Import and Export Wizard, which is accessible by right clicking on a database in SSMS, provides the option to save the process to a...
January 19, 2011 at 1:35 pm
Even if you build what you believe to be the perfect BI application that presents every posible key preformance indicator, you can't actually expose it to end users without upper...
January 19, 2011 at 8:27 am
Steve Jones - SSC Editor (1/18/2011)
I don't see these as holes in SSIS, but more potential holes in process using SSIS.
Right, a SSIS package is just an XML document, so...
January 19, 2011 at 6:01 am
Craig Farrell (1/18/2011)
Your department head and data integrity are miles above the average company I've worked in. That includes financial firms and healthcare providers. No I won't mention...
January 19, 2011 at 5:48 am
Craig Farrell (1/18/2011)
Without anyone usually having the holistic view of everything occuring with any piece of data, we're spiraling out of intelligent data access control. We need to find...
January 18, 2011 at 4:01 pm
Any project where there is a need to analyze the data scientifically will typically have real scientists on staff on contract. I've worked on projects side by side with statisticians...
January 18, 2011 at 2:00 pm
SanDroid (1/17/2011)
...
Eric, I agree with you but this does not agree with any BI project that accessed sensitive data that I have seen.
short story: All Company Security starts...
January 17, 2011 at 3:50 pm
marco-870908 (1/17/2011)
January 17, 2011 at 3:13 pm
Regarding the scurity of the ETL (or reporting) tools themselves, the biggest concern is not embedding login credentials into the package. The package should login using Windows Authentication and a...
January 17, 2011 at 11:44 am
Steve Jones - SSC Editor (1/17/2011)
We ought to have this discussion, and the best thing that can happen is better disclosure and...
January 17, 2011 at 10:57 am
TravisDBA (1/17/2011)
... I actually interviewed at a position once where the manager stated right out front that ALL of his developer staff had sysadmin rights to ALL of the production...
January 17, 2011 at 7:55 am
TravisDBA (1/15/2011)
January 16, 2011 at 6:03 pm
When performing emergency or long running maintenance operations on a database, one method to kick out all active user sessions (and insure they stay out until the database is ready...
January 14, 2011 at 3:09 pm
A decade ago, the first large SQL Server project that I had ownership of was 300 GB with SQL Server 7.0 running on a 2 CPU server with 4 GB...
January 14, 2011 at 1:39 pm
PaulB-TheOneAndOnly (1/13/2011)
...
Do not missunderstand me, I use some GUI tools like DBArtisan - which comes handy to have SQL Server, Sybase and Oracle on a fairly standard similar format -...
January 13, 2011 at 4:17 pm
Viewing 15 posts - 5,746 through 5,760 (of 6,031 total)