How Query execute
*This is my Opinion Whenever you execute any query…. Everything will be on Memory unless data is not available from...
2011-06-10
477 reads
Vinay Thakur
Isolation level and Locks
Before moving with next blog. We should be aware of some information about Isolation level. As the trasaction is depends...
2011-06-08
844 reads
Failure Cluster -General
We have discussed some basic high availability here. Yesterday we were discussing about Windows clustering (here on will say “Clustering”)...
2011-06-04
578 reads
SQL Server Migration Assistant v5.0
I bloog about mysql to sql server migration lastly here Today found very good migration tool Free Downloads: 1. SSMA...
2011-05-25
671 reads
Troubleshooting Performance -1
Whenever you get a call from user that they are facing any performance issue what would you do. As I...
2011-05-11
472 reads
Download: Powershell a Day -April 2011
I you liked my Powershell a day – april 2011, where every day I wrote a blog about powershell you can...
2011-04-30
1,540 reads
Powershell Day 30
Day 30 Best Practice Having good Security is first best practice for any language no exception with Powershell. Having that...
2011-04-30
1,451 reads
Powershell Day 29
Day 29 Advance Security As discussed in earlier blog about “Security” Day 7. Continue on that we will discuss here...
2011-04-29
1,444 reads
Powershell Day 28
Day 27 SQL Policy I highly recommand to go through the Policy –based management (BCM)’s official excellent site to learn...
2011-04-28
518 reads
Powershell Day 27
Day 27 Inventory As discussed ealier about wmi, wmi is a good for accessing inventory data from remote system as:...
2011-04-27
526 reads
Blogs
From Planning to Practice: Setting Up Your FinOps Framework
By HeyMo0sh
As someone who works in DevOps, I’m always focused on creating systems that are...
“We love to debate minutiae”
By Brian Kelley
I am guilty as charged. The quote was in reference to how people argue...
Advice I Like: Knots
By Steve Jones
Learn how to tie a bowline knot. Practice in the dark. With one hand....
Forums
Restoring On Top II
Comments posted to this topic are about the item Restoring On Top II
SQL Art 2: St Patrick’s Day in SSMS (Shamrock + Pint + Pixel Text)
Comments posted to this topic are about the item SQL Art 2: St Patrick’s...
Breaking Down Your Work
Comments posted to this topic are about the item Breaking Down Your Work
Question of the Day
Restoring On Top II
I have a database, DNRTest, that has a number of tables and other objects in it. The other day, I was trying to mock up a test and ran this code on the same server:
-- run yesterday CREATE DATABASE DNRTest2 GO USE DNRTest2 GO CREATE TABLE NewTable (id INT) GOToday, I realize that I need a copy of DNRTest for another mockup, and I run this:
-- run today USE Master BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO RESTORE DATABASE DNRTest2 FROM DISK = 'dnrtest.bak' WITH REPLACEWhat happens? See possible answers