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