Monthly Archives: April 2016

Stress Testing

Many of the DBAs that manage production systems will at some point determine what level of hardware is needed to support a workload. Whether this is a physical server purchase or a cloud “rental”, someone has to decide what hardware … Continue reading

Posted in Editorial | Tagged ,

Am I a sysadmin?–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I was doing some security testing and wondered if I was a sysadmin. There are a few ways to … Continue reading

Posted in Blog | Tagged , ,

Losing All Traces of Data

I was reading a thriller recently, in which a businessperson had their child threatened if they didn’t get some data for the criminals. Once the person had retrieved the data, they were told to delete it from the system and … Continue reading

Posted in Editorial | Tagged

Cloud First

SQL Server 2016 is the first “cloud first” release of SQL Server, as told to us by Remus Rusanu, former Microsoft SQL Server development team member. The features and enhancements in SQL Server 2016 have been running in the Azure … Continue reading

Posted in Editorial | Tagged ,

Specialist or Generalist

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

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

Changing the sa Password with SQLCMD

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

Backups Over Time

I’ve written about backups at various times, including responsibility, problems with systems, and home protection. This is a subject that is important to me, as I consider the responsibility for protecting data to be first and foremost. Security, performance and … Continue reading

Posted in Editorial | Tagged

Promotions and Conflicts of Interest

I noticed my co-worker, friend, and PASS board member, Grant Fritchey, posted a note on members of the PASS Board of Directors (BoD) presenting pre-cons at SQL Saturday events. It’s potentially a legal issue, and conflict of interest. I’m glad … Continue reading

Posted in Blog | Tagged , | 4 Comments