Top 5 Oracle Nuances I learned Today
I don’t do much with Oracle – at all. Once in a blue moon, I find a little project to do...
2011-08-16
2,114 reads
Jason Brimhall
Send DBMail
With SQL Server 2005, Microsoft improved the methods available for DBAs to send email from SQL Server. The new method...
2011-08-15
1,320 reads
Send DBMail
With SQL Server 2005, Microsoft improved the methods available for DBAs to send email from SQL Server. The new method is called Database Mail. If you want to send...
2011-08-15
12 reads
Summit 2011
Call me a slacker. I have been postponing registering for Summit 2011. I wanted to be sure that I had the week available in order to attend. I finally...
2011-08-11
2 reads
Summit 2011
Call me a slacker. I have been postponing registering for Summit 2011. I wanted to be sure that I had...
2011-08-11
505 reads
TSQL Tuesday 21 – FAIL FAIL FAIL
It is TSQL Tuesda… err Wedn… err Tuesday for August 2011. This month the party is a day later and...
2011-08-10
730 reads
TSQL Tuesday 21 – FAIL FAIL FAIL
It is TSQL Tuesda… err Wedn… err Tuesday for August 2011. This month the party is a day later and bringing us oodles of failure. Adam Machanic is hosting...
2011-08-10
3 reads
FK Hierarchy v 2.1
Last month I published an update to my Foreign Key Hierarchy script. Today, I am providing a new update for that script. A friend (Rémi Grégoire) helped out with...
2011-08-09
6 reads
FK Hierarchy v 2.1
Last month I published an update to my Foreign Key Hierarchy script. Today, I am providing a new update for...
2011-08-09
671 reads
S3OLV August Meeting II
I recently published a post about the upcoming meeting for S3OLV. This post is to serve as an update to...
2011-08-08
576 reads
Blogs
Deployment Pipelines in Fabric – What Are They?
By HeyMo0sh
In the realm of software development and content creation, the deployment pipeline serves as...
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...
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