Bad Idea Cowboy Hat: Using a foreign key to prevent updates
When I decided to rip off of Brent Ozar’s (b/t) Bad Idea Jeans series (yes I asked) I decided that ... Continue reading
2019-06-06 (first published: 2019-05-20)
983 reads
Kenneth Fisher
SQL Homework – June 2019 – Property functions
Yep. It’s time for your monthly homework session. You’ve finished last months right? Please turn it in over there. This ... Continue reading
2019-06-03
24 reads
I’m moving my permissions scripts to GitHub
I’ve written very few things that I’m more proud of than my permissions scripts, sp_SrvPermissions and sp_DBPermissions. These scripts are ... Continue reading
2019-05-30
56 reads
How was it done back in the day? T-SQL Tuesday #114
It’s TSQL Tuesday and Matthew McGiffen (b/t) is our host with a subject near and dear to my heart. Puzzles! ... Continue reading
2019-05-27 (first published: 2019-05-14)
474 reads
db_owner in msdb == sysadmin
This doesn’t require much in the way discussion. This isn’t exactly a huge issue since I don’t think granting db_owner ... Continue reading
2019-05-22 (first published: 2019-05-06)
527 reads
Security Learning Pathway at PASS Summit.
This year PASS is trying something new at PASS Summit. There are going to be Learning Pathways. A learning pathway ... Continue reading
2019-05-17
10 reads
What do you get with a Free account in #Azure?
The first thing I want to do is say thank you to Michael Crump (b/t). He tweeted out this: What ... Continue reading
2019-05-08 (first published: 2019-04-29)
1,233 reads
Why am I getting an NT AUTHORITYANONYMOUS error when creating or altering a stored procedure?
If you have to deal with linked servers then you probably have or will run into the following error: Login ... Continue reading
2019-05-08
87 reads
Shrinking a large database with limited outage windows
Yes, I realize you shouldn’t shrink your database (data files or log files), but I recently had a case where ... Continue reading
2019-05-06 (first published: 2019-04-22)
1,589 reads
SQL Homework – May 2019 – SQLCMD and the DAC
Yes, it’s that time again. Time to do your homework. This month your homework is to set up the DAC ... Continue reading
2019-05-01
17 reads
Blogs
Monday Monitor Tips: ServiceNow Integration
By Steve Jones
Earlier this year I visited a customer that was using the Redgate Monitor webhook...
Inspecting TSQL Abstract Syntax Trees
By Zikato
TSQL ScriptDOM is a useful library for parsing scripts into an abstract syntax tree....
Becoming a creator, my website experience
By DataOnWheels
Over the past few months, I have debated starting a new blog to discuss...
Forums
Cannot get KB959420
Hi, we lost our sever sql2000 To restore database to a new one we...
Cannot get KB959420
Hi, since we lost our sql server 2000 server we are trying to restore...
Do You Really Need HA?
Comments posted to this topic are about the item Do You Really Need HA?
Question of the Day
The New Database CheckDB
I run this code:
create database experiment
go
use Experiment
go
select DATABASEPROPERTYEX('Experiment', 'LastGoodCheckDbTime')
What is returned? See possible answers