Monthly Archives: January 2017

Number Security

There’s a scary item recently in a Database Weekly newsletter. Apparently your credit card number code can be guessed in seconds. Using techniques that spread guesses around to a number of sites, criminals can avoid triggering alarms, which makes some … Continue reading

Posted in Editorial | 2 Comments

Be Careful of Your Create Stored Procedure Batch

I was rehearsing a demo with someone recently and we had some stored procedure code that looked like this: CREATE PROCEDURE UpdateEmpID @empid INT AS BEGIN UPDATE  dbo.Employees SET empid = 3 WHERE  empid = @empid ; END However, this … Continue reading

Posted in Blog | Tagged , | Comments Off on Be Careful of Your Create Stored Procedure Batch

The Salary Range

We published the results of our 2016 Salary Survey today, which has some interesting numbers in it. I haven’t done a lot of analysis of the data, but it seems as though the averages are higher than I expected for … Continue reading

Posted in Editorial | Tagged | Comments Off on The Salary Range

Starting with Chocolatey

I ran across Chocolatey years ago when Scott Hanselman wrote about it in his power tool list. At the time, I wasn’t in need of the tool, but I thought it was cool and tried it. I was hooked. In … Continue reading

Posted in Blog | Tagged , | 4 Comments