Monthly Archives: April 2016

Specialist or Generalist

Posted on April 26, 2016 by way0utwest

What would you rather be: a expert specialist in some narrow area of SQL Server or a generalist that’s competent in many areas? The same question could apply to any area of technology, like C# or Windows, or even any … Continue reading →

Posted in Editorial | Tagged | 2 Comments

Explicitly using tempdb with ##tables

Posted on April 25, 2016 by way0utwest

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 way0utwest

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 | Comments Off on The Pen Test

Changing the sa Password with SQLCMD

Posted on April 22, 2016 by way0utwest

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I wanted to make a quick note on changing the sa password, as this is a sensitive account, and … Continue reading →

Posted in Blog | Tagged , , , | 1 Comment