Daily Archives: April 25, 2016

Explicitly using tempdb with ##tables

Posted on April 25, 2016 by

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

Posted on April 25, 2016 by

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