sp_refreshsqlmodule_internal – The user does not have permission to perform this action.
Honestly, I’m only posting this because I had a hard time finding anything posted on this error and I found...
2016-12-28
1,521 reads
Kenneth Fisher
A semester’s worth of Backup and Recovery blogs – The TSQL Tuesday 85 Rollup
I was thrilled to host TSQL Tuesday #85, the last TSQL Tuesday of 2016. My subject was backup and recovery...
2016-12-26
474 reads
sp_helptext vs object_definition()
I’ve been using sp_helptext for years. Honestly I probably end up using it at least once a day. But I...
2016-12-21
1,940 reads
:OUT :OUT darn results!
Years ago I worked for a company that had a rather cool way of handling requests. When we ran the...
2016-12-19
459 reads
An interview with me
The other day I received an email asking for some help with a school project. Would I please answer some...
2016-12-15
465 reads
DBA Myths: You can only restore one differential backup
Ok, I know I’m hosting T-SQL Tuesday this month but I still had post I wanted to share.
The basic steps...
2016-12-13
474 reads
Fixing Data Migration Assistant timeouts
I’ve been really excited about the new Data Migration Assistant (DMA) since I first heard about it. One of the...
2016-12-08
770 reads
TSQL Tuesday #85 Invite – Backup and Recovery
Come on down! You’re the next contestant on T-SQL Tuesday! I’m your host Kenneth Fisher and this month I’d thought...
2016-12-06
554 reads
Easy to read CHECKDB
If you ask a senior DBA what are the top 5 most important commands in T-SQL you’ll probably see DBCC...
2016-12-05 (first published: 2016-11-28)
2,490 reads
Using OUTPUT with a field list.
I recently wrote an article for SQL Server Central about using OUTPUT. In case you aren’t aware OUTPUT is a...
2016-11-30
718 reads
Blogs
A New Word: Dorgone
By Steve Jones
dorgone– adj. wondering if you could slip away from an event or group conversation...
Tell It Once: Setting Up Claude With Skills and MCP Servers
By ReviewMyDB
Many of us use AI the same way every single day. Open a tab....
SQL Server Transaction Log Forensics: Preserving Evidence During an Incident
By SQLPals
SQL Server Transaction Log Forensics: Preserving Evidence During an Incident SQL...
Forums
Make It Routine
Comments posted to this topic are about the item Make It Routine
Finding Gaps in Sequential Data Using SQL Server
Comments posted to this topic are about the item Finding Gaps in Sequential Data...
Negative and Positive Numbers
Comments posted to this topic are about the item Negative and Positive Numbers
Question of the Day
Negative and Positive Numbers
If I want to know whether a number of negative, positive, or zero, what is the easiest way to get this in T-SQL?
See possible answers