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
296 reads
Kenneth Fisher
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
507 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
582 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,960 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,683 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
432 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
302 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
674 reads
2018-01-10
224 reads
SQL Homework – January 2017 – Inspect an Execution Plan
It’s a new year and yet education never ends. So this month let’s take a look at an important part...
2018-01-10 (first published: 2018-01-03)
2,484 reads
Blogs
Rebuilding a SQL Server Database Transaction Log
“Could you help me, we deleted the database’s transaction log file and now that...
Copying Content from One Databricks Unity Catalog Catalog to Another
I had a couple of clients who were moving content from development catalogs to...
Dumping and Restoring Azure PostgreSQL Databases
I wanted to test a migration of Azure PostgreSQL from simple to flexible. I...
Forums
What Foods Should You Eat to Reduce Erectile Dysfunction Symptoms?
Diet plays a crucial role in managing erectile dysfunction (ED) symptoms, and incorporating certain...
Enable a Disabled Index
Comments posted to this topic are about the item Enable a Disabled Index
Diving Deeper into the Import Extension in Azure Data Studio
Comments posted to this topic are about the item Diving Deeper into the Import...
Question of the Day
Enable a Disabled Index
I have disabled the LoggerCI index on the dbo.Logger table. How do I enable it?
See possible answers