Archives: December 2016
Honestly, I’m only posting this because I had a hard time finding anything posted on this error and I found it somewhat unclear. Here is a quick walk through to produce the error:
-- Create server principal. CREATE LOGIN SQLTest WITH PASSWORD = 'SQLTest'; GO -- Create a database principal…
I was thrilled to host TSQL Tuesday #85, the last TSQL Tuesday of 2016. My subject was backup and recovery and I was pleased to see this line of my invitation quoted several times.
Backups are one of the most common things DBAs discuss, and they are at once one…
I’ve been using sp_helptext for years. Honestly I probably end up using it at least once a day. But I was recently exposed to object_definition() which has a similar output. There are, however, a few differences.
This system function returns the text of any (T-SQL) code based object. I.e.… Read more
Years ago I worked for a company that had a rather cool way of handling requests. When we ran the request the query we used and the output were saved to a directory on the network. This way if there were any questions about what had been done we had… Read more
The other day I received an email asking for some help with a school project. Would I please answer some questions about my career and industry. Well after some due diligence I answered the questions. But the questions were rather interesting and the answers turned out pretty well (IMHO) so… Read more
The basic steps when restoring backups are
- The most recent full backup.
- The most recent differential backup.
- All log backups after the most recent differential.
I’ve been really excited about the new Data Migration Assistant (DMA) since I first heard about it. One of the things I like best about it is that unlike the old Upgrade Advisor it doesn’t have to be run on the server being upgraded. You can run it against… Read more
No. Wait. Sorry, that was last time. This time I want to hear about backup and recovery.
Backups are one of the most common… Read more