First Remote Presentation
I threw it out there and they said yes. They being Meredith Ryan of the Albuquerque PASS Chapter. They were...
2014-03-03
504 reads
Jason Carter
Tell Me How I’m Doing: A Fable About the Importance of Giving Feedback
I read a lot of blogs using BlogTrottr as my inbox delivery mechanism, but it has been quite a while since I’ve...
2014-02-26
650 reads
Be Nice
Years ago when I was just out of the Marine Corps and found myself as the only IT guy in an...
2014-02-19
437 reads
Next Up 70-432
As a self-taught developer, I’ve never really given any credence to certifications. Certifications in the development arena seem like a way...
2014-02-13
567 reads
5 Things Series – APPLY Operator
In this series I’m going to detail the 5 T-SQL Commands that review in my 5 T-SQL Commands I’ve been...
2014-02-12
528 reads
5 Things Series – Output Clause
In this series I’m going to detail the 5 T-SQL Commands that review in my 5 T-SQL Commands I’ve been...
2014-02-09
667 reads
Powershell – Extract Versions for SQL Features
Over the last few months I’ve been directed to ensure that all of our SQL Servers in the Development and...
2014-02-05
1,531 reads
Upcoming Presentations
Since I took the leap last year and submitted to talk at SQL Saturday, I’ve come to enjoy the challenge that...
2014-02-04
618 reads
Blogtrottr – RSS to Email
Anyone who is a fan of RSS Feeds will likely know that the discontinuing of service by Google Reader caused...
2014-01-24
973 reads
Its the little things – Service Master Keys
In advance of the yearly licensing reconciliation with Microsoft at work, I have led the charge to ensure all of...
2014-01-23
620 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