Error in SSMS: Attempted to read or write protected memory.
There are a lot of reasons to write a blog post. One of my favorites is when I’ve been asked...
2019-02-18
168 reads
Kenneth Fisher
What is your why?: T-SQL Tuesday #111
This month Andy Leonard (b/t) wants to know why we do what we do. Funnily enough, this is something I...
2019-02-12
685 reads
What’s a differential backup?
Of the different basic types of backups (full, differential and log) I find the differential the most interesting, and frequently...
2019-02-12 (first published: 2019-01-23)
2,156 reads
Using Cloud Academy
The other day I talked about using Microsoft Learn. Well, honestly, Cloud Academy is the learning tool I’ve been using...
2019-02-06
213 reads
Read-only tables
Sometimes you need a table that is read only. You don’t want anyone to be able to write to it...
2019-02-05 (first published: 2019-01-21)
2,658 reads
SQL Homework – February 2019 – Instance configurations
This homework series really has two purposes. It’s a primer for beginners. These are tasks I think most if not...
2019-02-04
198 reads
2019-01-30
240 reads
Controlling the firewall for an Azure SQL DB via T-SQL
The other day I took a Microsoft Learn course about securing Azure SQL DB. It was really enjoyable and I...
2019-01-29 (first published: 2019-01-16)
2,196 reads
SQL Bits 2019: The Great Data Heist
SQL Bits is almost here! It’s February 27th to March 2nd. SQL Bits is one of the most popular SQL...
2019-01-14
727 reads
#SQLCareer 4/4 January 2nd 2019
Last July (yes, it’s taken me 5+ months to finally finish this) Steve Jones (b/t) suggested that it might be...
2019-01-10
172 reads
Blogs
The DIY Cost of Masking Test Data For Smaller Organizations
By Steve Jones
One of the things I’ve tried hard to do in database development situations if...
T-SQL Tuesday #196 – Two risky career decisions I made
By DataOnWheels
The T-SQL Tuesday topic this month comes James Serra. What career risks have you...
T-SQL Tuesday #192: What career risks have you taken?
This T-SQL Tuesday is hosted by the one and only James Serra – literally...
Forums
XACT_ABORT being set to ON by web services
We have two "identical" instances of an ASP.NET web service (or so I have...
OPENQUERY Flexibility
Comments posted to this topic are about the item OPENQUERY Flexibility
A Full Shutdown
Comments posted to this topic are about the item A Full Shutdown
Question of the Day
OPENQUERY Flexibility
Which of these are valid OPENQUERY() uses?
See possible answers