Tuesday notes! Today I’m in Execution Plans in Depth by Hugo Kornelis. Notes: Today the presenter is using the Cadmium/EventScribe platform instead of GotoWebinar Started off with a lot...
2020-11-11
18 reads
Writing most of this Monday afternoon while on lunch break. I’m attending the Advanced T-SQL Querying and Query Tuning pre-con by Itzik Ben-Gan. You access pre-cons via the Virtual...
2020-11-10
19 reads
I’m in learning mode this week, scheduled for two full day pre-cons plus the Summit. I’ve been to a couple of virtual events already this year, but they were...
2020-11-09
83 reads
It’s just over 30 days to the 2020 PASS Summit and that is plenty of time to get the boss to say yes, but you have to ask! I...
2020-10-14 (first published: 2020-10-05)
179 reads
I know that we don’t yet know how the 2020 Summit will turn out, but I’ll make some guesses: A lot of people like it for the lower cost,...
2020-08-18 (first published: 2020-08-05)
741 reads
I’m sure it’s no surprise, but we’ve decided to cancel SQLSaturday Orlando 2020. We decided a couple weeks ago but it’s been tough to summon the energy to write...
2020-07-17
89 reads
Some thoughts on the PASS Virtual Summit this year: Clearly the in-person option wasn’t doable. Just too hard to know infection rate, local rules, employer travel guidelines, attendee and...
2020-07-31 (first published: 2020-07-17)
219 reads
I’ve gathered a bunch of notes from conversations and time reflecting, thought I’d write them down to at least be able to look back at them once the storm...
2020-04-04
148 reads
We’ve cancelled our upcoming Meetups in April and May due the loss of our venue (due to corona virus worries) though we would have probably cancelled them anyway. Our...
2020-03-16
7 reads
The notes! Attendance was the speaker dinner was great! Always nice to have a lot of people there. During the day logistics all went well, though it’s still a...
2020-03-08
26 reads
By Vinay Thakur
I wrote about TempDB Internals and understand that Tempdb plays very important role on...
By Vinay Thakur
continuing from Day 1 where we covered the history of AI and GPT family,...
By Steve Jones
It’s a day off for Redgate today. This is our annual wellbeing day, where...
Comments posted to this topic are about the item A Quick Restore
Comments posted to this topic are about the item Guarding Against SQL Injection at...
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
While doing some testing of an application, I wanted to reset my environment after doing some testing with this code:
USE DNRTest BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO /* Bunch of stuff tested here */RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACEWhat happens if this runs, assuming the "bunch of stuff" isn't anything affecting the instance. See possible answers