Daily Archives: April 25, 2016

Explicitly using tempdb with ##tables

I had someone ask me last night if this statement would create a permanent table in tempdb with a strange name or a global temp table: CREATE TABLE tempdb..##mytable ( id int ); My suspicion was that this would always … Continue reading

Posted in Blog | Tagged , | 5 Comments

The Pen Test

We need something like the Air Force project seeking network vulnerabilities¬†for our database systems. While there are tools that can help from the outside, but we need SQL Server specific tools. Why don’t we have a Best Practices Analyzer for … Continue reading

Posted in Editorial | Tagged