Hint Word Search

This is a word search for most (but not all) of the hints available in T-SQL.

SQL Homework – February 2018 – Work with security

This month let’s create some security!
Create logins: GUI 5 pts/Script 5 pts

Create a SQL login and a Windows authenticated login....

The difference between blogging about something you know, and something you are learning (Love blogging! Live!)

Close but you need to blog about learning while blogging about the difference of blogging when you are learning something...

How To: Install SQL Server on an Azure VM

Last month I demonstrated creating an Azure VM with SQL installed using one of the default templates. While this is...

What’s dbo?

Don’t you hate it how certain words (well, acronyms in this case) get reused to mean multiple things? dbo seems...

Who should own the database?

TL;DR; SA, or if you are really paranoid then you can create a disabled SQL login with minimal permissions and...

Help it takes forever to open the SQL Server Log!

Just to be very clear, I’m talking about the SQL Server Log, not database logs. Sometimes this is called the...

How to read a technical blog

There are thousands, tens of thousands, probably hundreds of thousands of blogs out there on all sorts of topics. If...

Fun with sp_rename

Currently the only way to rename objects in SQL Server is to use sp_rename. Although that may be changing in...

SQL Crossword - Best Practices

This crossword tests your knowledge of SQL Server best practices.