JSSUG Speaker Idol 2012 Review
Last Wednesday at Jacksonville SQL Server User Group (JSSUG) we held our annual Speaker Idol event. Read more about what...
2012-08-21
1,161 reads
Blog Posts
My upcoming speaking schedule
The summer goes by and in a few weeks the conference season starts over again. The
last weeks were a little...
2012-08-21
753 reads
My upcoming speaking schedule
The summer goes by and in a few weeks the conference season starts over again. The last weeks were a...
2012-08-21
343 reads
PASS Summit Code of Conduct – my thoughts
The big furor today is over PASS‘s new written Code of Conduct. I’m going to crib unashamedly from Nic Cain’s blog post...
2012-08-21
1,172 reads
Restore Database In SQL 2012
In the post below I mentioned a store procedure which can generate the database restore script based on the msdb...
2012-08-21
8,313 reads
Webcast: The Art and Science of Handling Recruiters
Post-webcast update: The webcast went well! We talked, we QnA’ed, we gave out a free Roadmap, and all attendees got...
2012-08-21
823 reads
8 Habits/Skills/Traits of Highly Effective DBAs
The whole “7 Habits” title is so cliché so I decided to make it eight! Plus that will probably relieve...
2012-08-20
448 reads
keyword DEFAULT
In 12 years of working with SQL it was only last year that I came across the keyword DEFAULT and...
2012-08-20
1,341 reads
Please VOTE for Me: PASS Summit 2012 Lightening Talks
http://www.flickr.com/photos/cyndydoty/2087680308/Hello Dear Reader the PASS Summit is approaching and with that the program committee sent out a request for Lightening...
2012-08-20
1,053 reads
SQL Agent Alerts - Severity Condition is NOT "greater than or equal to"
I ran into some bad training that had convinced a client sys admin that the SQL Agent Alerts had the...
2012-08-20
2,267 reads
Blogs
How to Parameterize Fabric Linked Services in Azure Data Factory for Azure Devops Deployment
Quite the title, so let me set the stage first. You have an Azure...
Deployment Pipelines in Fabric – What Are They?
By HeyMo0sh
In the realm of software development and content creation, the deployment pipeline serves as...
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