Monthly Archives: October 2017

Unit Testing T-SQL Code

Abstract Unit testing has become an integrated, expected part of most software development teams. Many database developers have yet to implement unit testing as a regular habit. This session will look at two-unit testing frameworks and show how to implement … Continue reading

Posted in Presentations | Tagged , | Leave a comment

A Tour of SQL Server Security Features

Abstract Protecting data from unauthorized access becomes more important all the time. SQL Server includes a number of features that make data protection and security easier for developers and DBAs with a framework for protecting data. Come learn how Always … Continue reading

Posted in Presentations | Tagged , , , , | Leave a comment

Rebooting Ubuntu Linux from the Command Line–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. Since SQL Server 2017 is now out, and Linux is an option, I thought I’d write a bit more … Continue reading

Posted in Blog | Tagged , , | Leave a comment

Software Patents

This editorial was originally published on Jan 30, 2014. It is being re-published as Steve is out of town. I highly dislike the current patent system in the US. I think awarding patents for an idea like “1-click purchasing” is … Continue reading

Posted in Editorial | Tagged | Leave a comment

Quick SQL Prompt Updates in a Pattern

I work for Redgate and write about products. I’ve got a series of SQL Prompt posts here on little things I like. SQL Prompt might be my favorite tool.  SQL Prompt will be yours as well if you give it … Continue reading

Posted in Blog | Tagged , , , | Leave a comment

The Cloud is Better In At Least One Way

Many people don’t see the cloud platform as necessarily better run than what they do in their local data center. That might be true, and certainly the caliber of people, their experience, responsiveness, and more can make a big difference … Continue reading

Posted in Editorial | Tagged , | Leave a comment

Using Backup-DbaDatabase for a Quick Backup

I really like the dbatools project. This is a series of PowerShell cmdlets that are built by the community and incredibly useful for migrations between SQL Servers, but also for various administrative actions. I have a short series on these … Continue reading

Posted in Blog | Tagged , , , | Leave a comment

A Double Dose of Trouble

It’s Friday the 13th, during the month of October. Halloween, a strange holiday associated with horrible events, and Friday the 13th, a bad luck day, are happening this month. Both are associated with horror movies, implying that this isn’t necessarily a good month for … Continue reading

Posted in Editorial | Tagged | Leave a comment

Getting the Random Module in SQL Data Generator

This is a series on SQL Data Generator, covering some interesting scenarios I’ve run into. If you’ve never tried it, SQL Data Generator is a part of the SQL Toolbelt. Give it a try today with an evaluation today. I … Continue reading

Posted in Blog | Tagged , , | Leave a comment

The Blame Game

Make no mistake, this is going to be something that happens again. The former CEO of Equifax blames their massive data breach on a bad scanner and a person. I’m not talking about a data breach, of course those are going … Continue reading

Posted in Editorial | Tagged | 3 Comments