Back To Basics: Using Common Table Expressions
CTEs (Common Table Expressions) are one of the very cool features introduced in SQL Server 2005. In there simplest most common form, think of them as a temporary single use view who’s context is only within the command which follows them directly.
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