2018-02-07
288 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
301 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
509 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
603 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,973 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
306 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,215 reads
2018-01-10
243 reads
Blogs
Using CAT for Testing of Data Agents
In last months one of the scenarios where you can use AI has been...
Are you getting value from your reporting?
By ChrisJenkins
Do you spend so long manipulating your data into something vaguely useful that you...
The Book of Redgate: SQL Server Central
By Steve Jones
It was neat to stumble on this in the book, a piece by me,...
Forums
Microsoft Security Changes and SQL Server
Comments posted to this topic are about the item Microsoft Security Changes and SQL...
Expanding into Print
Comments posted to this topic are about the item Expanding into Print
Downtime Caused by the Postgres Transaction ID Wraparound Problem
Comments posted to this topic are about the item Downtime Caused by the Postgres...
Question of the Day
The String Distance I
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('Steve', 'Stan')
Assume preview features are enabled. See possible answers