Exploring permissions with sp_DBPermissions and sp_SrvPermissions : TSQL Tuesday 101
Our host for T-SQL Tuesday this month is Jens Vestergaard (b/t) and he has asked about our favorite SSMS tool....
2018-04-10
2,739 reads
Kenneth Fisher
SSMS’s Dark Theme
There has been talk of a dark theme for SSMS for years. Does it exist, will it exist? Well, the...
2018-04-04
466 reads
SQL Homework – April 2018 – Indexes
This month we are going to look at a topic near and dear to both database developers and database administrators...
2018-04-02
313 reads
Storing a variable with a SELECT, and why it didn't work.
Using SELECT to store values into variables is an important technique, but you need to know some of the gotchas as well.
2018-04-02
6,058 reads
What’s the difference between Files and Filegroups?
tl;dr; Filegroups are a logical construct used to separate tables and indexes from each other, files are the physical construct...
2018-03-28
775 reads
DB_NAME() vs ORIGINAL_DB_NAME()
I’d never seen ORIGINAL_DB_NAME until recently and I thought it would be interesting to highlight it out, and in particular...
2018-03-27 (first published: 2018-03-15)
2,885 reads
Introducing The Blame Game
Introducing the Blame Game! Someone has messed up the new anatomy application’s (Mr. Body) performance and no one is willing...
2018-03-26
288 reads
Moving a table using BCP and native format
You need to move a table from one instance to another with the following requirements:
The instances are on separate domains....
2018-03-21
368 reads
GDPR – After the restore
I joined in on an interesting conversation the other day on twitter. It was about some unusual ramifications of GDPR...
2018-03-19
400 reads
Simply Debugging
Debugging is a life skill. Yes, the term comes from IT (literally removing a bug from a computer believe it...
2018-03-19 (first published: 2018-03-07)
2,061 reads
Blogs
How Fabric Mirroring Transformed with SQL Server 2025
When mirroring was first released for Azure SQL Database, it used Change Data Capture...
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...
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