Prevent sp_ Procedures with SQLCop

Learn how you can use SQLCop to prevent your developers from writing stored procedures that are named sp_ something.

Execute the Current Statement–SQL Prompt

This is a great little feature in SQL Prompt that I wrote about at SQLServerCentral. It’s Current statement Execution, which...

Hadoop and SQL Server

Hadoop is a technology that's getting quite a bit of attention in the last few years, including integration with SQL Server. Steve Jones talks about the technology and how it might fit in your career.

Counting values

Testing

We know that software testing is important, but we often don't do a great job of executing. Steve Jones talk database testing today.

T-SQL Tuesday #62 – Healthy SQL

The invitation for T-SQL Tuesday this month comes from Robert Pearl. It’s called HealthySQL and it’s a topic I like....

Identity Data Types

Data Lakes

An interesting new paradigm popped up in the news this week: the data lake. It examines data as a model for organizational architectures.

Multiple Backup Files

This Friday Steve Jones looks at your backup system and wonders how many people use striped backups.

Filestream files