Which Process ID is SQL Server running on?
There was an interesting question posted on a forum recently, asking how can you tell which sqlservr.exe process (shown in...
2011-01-04
5,981 reads
Blog Posts
XQuery for the Non-Expert – Binary Values
Follow the rest of this series at the XQuery for the Non-Expert – X-Query Resources introduction post.
Talk to the Experts
In the...
2011-01-04
697 reads
24 Hours of PASS Wants You…
Calling for Presenters!There’s still a couple months until the next 24 Hours of PASS. Even though it’s a bit of...
2011-01-03
302 reads
Back to Work
It's actually nice to be back to work. It's been a great holiday season for me, lots of family time...
2011-01-03
780 reads
Beginning Powershell Companion PDF
Howdy all…as is so often the case, I’m studying something – Powershell – and I’m in need of a reference to help...
2011-01-03
2,688 reads
Happy New Year 2011
Wish you all a very happy an prosperous New Year 2011. When I see back year 2010 : >> was started my...
2011-01-03
443 reads
Looking Back at 2010
I was “inspired” to write this post after I read some comments on my last post, Reviewing My 2010 Goals,...
2011-01-03
451 reads
Looking Back at 2010
I was “inspired” to write this post after I read some comments on my last post, Reviewing My 2010 Goals, and I read Brent Ozar’s post, Goals? Where we’re...
2011-01-03
6 reads
Lots of Intel Sandy Bridge News Today
Intel has lifted the embargo today on 32nm Intel Sandy Bridge benchmarking, so there is a lot of good information...
2011-01-03
849 reads
Most Popular SQL Server Events
I recently held a poll on my blog, asking people if they had attended any SQL Server events in the...
2011-01-03
752 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