Webcast Recover the data, the whole data and nothing but the data you need available for viewing
The webcast which I did with Quest Software a couple of weeks ago “Recover the data, the whole data and nothing but the data you need” has had the recording posted for viewing on the Quest website. If you missed the webcast live now is your chance to view it. Denny
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.) […]