Speaker of the Month: November 2014
I have been very remiss in my blogging of late. Apologies.
One thing I haven’t blogged about is Speaker of...
2014-12-05
504 reads
The Scary DBA
PASS Summit 2014 Speaker Idol
For the first time ever at the PASS Summit, a competition was held to select a speaker for the 2015...
2014-11-13
779 reads
I’m Still Not on the Board
I’m just back from the PASS Summit 2014. What a great event. But this year, it was a little different....
2014-11-11
692 reads
PASS Summit 2014: WIT Luncheon
Since I’m starting on the board in January, I’ve stopped taking part in the bloggers table during keynotes. First time...
2014-11-06
621 reads
Database Lifecycle Management
There are lots of people who talk about Application Lifecycle Management. But, the database is a major part of every...
2014-10-31 (first published: 2014-10-20)
6,978 reads
Why Haven’t You Changed Everything?
The first in what I hope will be many regular reports on what I’m doing on the PASS board.
To answer...
2014-10-17
601 reads
Query Performance Tuning in SQL Server
I have a pre-con coming up at the PASS Summit. You can read about it here. I named it “Query...
2014-10-16
677 reads
Thank You: #passvotes
The results are in and it seems that I’ve been elected to a place on the PASS Board.
Thank you.
I will...
2014-10-15
490 reads
Navel Gazing
I love negative feedback. Well, not really. I love constructive feedback. I love the feedback that gives me things to...
2014-10-17 (first published: 2014-10-12)
6,595 reads
Speaker of the Month: October 2014
I saw a whole bunch of great sessions last month. I was all over the place from Las Vegas to...
2014-10-09
547 reads
Blogs
TempDB Internals – What’s New (SQL Server 2016 to 2022)
By Vinay Thakur
I wrote about TempDB Internals and understand that Tempdb plays very important role on...
AI: Blog a Day – Day 2: Generative AI, Multimodal Systems, and Agent AI
By Vinay Thakur
continuing from Day 1 where we covered the history of AI and GPT family,...
Forums
A Quick Restore
Comments posted to this topic are about the item A Quick Restore
Guarding Against SQL Injection at the Database Layer (SQL Server)
Comments posted to this topic are about the item Guarding Against SQL Injection at...
Ola Hallengren Index Optimize Maintenance can we have data compression = page
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
Question of the Day
A Quick Restore
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