Monthly Archives: September 2010

Big Data and SQL

Posted on September 20, 2010 by way0utwest

Today Steve Jones talks about how some companies find efficiencies by training employees to use SQL. Perhaps that’s a good idea for all developers. Continue reading →

Posted in Editorial | Tagged , | Comments Off on Big Data and SQL

Large Chunks of Data

Posted on September 17, 2010 by way0utwest

This Friday Steve Jones talks reporting. Specifically he wonders how long can a report be before it’s just wasting space. Continue reading →

Posted in Editorial | Tagged , | Comments Off on Large Chunks of Data

ACID

Posted on September 17, 2010 by way0utwest

What’s ACID in databases? I was asked this in an interview a long time ago and I couldn’t remember the exact meaning. For a (supposedly) senior DBA, that’s bad. I could, however, tell what it means and what it enforces … Continue reading →

Posted in Blog | Tagged , | Comments Off on ACID

Rights for one table

Posted on September 16, 2010 by way0utwest

I ran across a thread that was asking how to grant rights to a person for one table only, and not other tables. My response is simple: CREATE ROLE MySingleTableRoleGOGRANT SELECT ON dbo.MyCustomers TO MySingleTableRoleGOEXEC sp_addrolemember ‘MySingleTableRole’, ‘Steve’ That’s it. … Continue reading →

Posted in Blog | Tagged , , , | Comments Off on Rights for one table