SQL 2008 prevents schema changes if the table must be dropped
When editing the table schema in the SQL Server 2008 UI and the required change requires that the table needs to be dropped and recreated by default the UI will not let you make the change. The kinds of changes that would require that the table be dropped and recreated would be inserting a column in […]
Identity Theft: A BIG issue for IT Auditors and DBAs
Arian Eigen Heald has posted a good blog about identity theft titled “Identity Theft: A BIG issue for IT Auditors and DBAs” over on the Sister CISA CISSP blog. It’s a good read, so I wanted to make sure to pass the information along. Denny
Back To Basics: The SELECT Statement
There are four basic commands in databases. They are SELECT, INSERT, UPDATE and DELETE. Probably the most important of these is the SELECT command. The SELECT command is how the data in the database is retrieved and displayed. (All these code samples can be run on all versions of Microsoft SQL Server from 7.0 up.) […]
I’ll be speaking at the San Diego SQL Server Users Group
The good folks of the San Diego SQL Server User Group has invited me to come speak to them on March 20, 2008. The meeting starts at 6PM. If you are in the area I urge you to come and check it out. The topic of my talk will be Query Tuning as well as […]