2018-02-07
285 reads
Kenneth Fisher
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....
2018-02-05
300 reads
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...
2018-01-31
508 reads
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...
2018-01-29
602 reads
What’s dbo?
Don’t you hate it how certain words (well, acronyms in this case) get reused to mean multiple things? dbo seems...
2018-01-29 (first published: 2018-01-22)
1,971 reads
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...
2018-01-25 (first published: 2018-01-15)
2,700 reads
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...
2018-01-24
435 reads
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...
2018-01-17
305 reads
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...
2018-01-11
1,156 reads
2018-01-10
241 reads
Blogs
Resetting on the AI hype train
By Brian Kelley
There's a great article from MIT Technology Review about resetting on the hype of...
A New Word: Etherness
By Steve Jones
etherness – n. the wistful feeling of looking around a gathering of loved ones,...
Vibe Coding a Login Tracking System
By Steve Jones
A customer was asking about tracking logins and logouts in Redgate Monitor. We don’t...
Forums
The Microsoft SQL Year in Review
Comments posted to this topic are about the item The Microsoft SQL Year in...
T-SQL in SQL Server 2025: The || Operator
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Your Value from a Conference
Comments posted to this topic are about the item Your Value from a Conference
Question of the Day
UNISTR Basics
What does this code return in SQL Server 2025+? (assume the database has an appropriate collation)
SELECT UNISTR('Hello 4E16754C') AS 'A Classic';
A: 
B: 
See possible answers