Viewing 15 posts - 5,746 through 5,760 (of 6,034 total)
There are a lot of mistakes developers make regarding dates and data types; an entire presentation could cover this topic alone.
For example:
- Containing "date" values (ex: 3/10/09, 09/10/03, 3-10)...
January 24, 2011 at 7:23 am
If what you're wanting to do is BEGIN TRANSACTION, and then at some point have the option to ROLLBACK a unit of work while still having the option to COMMIT...
January 21, 2011 at 2:47 pm
Try letting the Database Tuning Advisor analyze a few of these batches loads and see what it reccomends.
January 20, 2011 at 12:23 pm
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
Viewing 15 posts - 5,746 through 5,760 (of 6,034 total)