DBA relationships – The data custodian
G’day,
As DBA’s, we all know how to manage security, some are more advanced that others but ensuring that the right...
2011-04-28
2,275 reads
measure twice, cut once.
Connection strings and application name
G’day,
There are many things that developers and DBA’s can do to help their relationships run smoothly, most of them are relatively simply...
2011-04-27
14,848 reads
The developer / DBA relationship.
G’day,
A large part of my job involves liaising with developers. I spent the first 8 years of my IT career working as...
2011-04-27
2,661 reads
A small facet of information
G’day,
I’ve blogged about facets before, but I just thought that I’d mention them again, as they came in quite handy...
2011-04-24
523 reads
PowerShell Tip – Custom windows for different tasks.
G’day
There seems to be a lot of articles around at the moment concerning the use of PowerShell.
I think this is...
2011-04-22
738 reads
DBCC TraceOn – some processes are global.
Hi,
I was recently doing some testing as I thought that I’d experiment with the ghost clean up process.
I found that...
2011-04-13
2,653 reads
So, what’s this heap thing?
G’day,
I’ve been asked a few times lately to explain what a heap is.
I’m quite happy to do this, but I...
2011-04-10
2,402 reads
This appears to be a system procedure..but it isn’t!
G’day,
Recently, I was browsing through my database server when suddenly under the “System Stored Procedures” folder of the master database...
2011-04-05
2,040 reads
View system object definitions
G’day,
You’ve probably all noticed that when you right click on a user database object in SSMS object explorer that you...
2011-04-03
629 reads
If you fire that trigger, make sure you have the correct ID
G’day,
I think it would be a fair bet to say that we’ve all used the @@IDENTITY function. It returns the...
2011-04-02
571 reads
Blogs
Building the Team: Roles and Responsibilities in FinOps
By HeyMo0sh
In my experience, FinOps success has never been just about tools or dashboards. It...
Tooling for Success: The Best FinOps Tools and Technologies
By HeyMo0sh
As a DevOps person, I know that to make FinOps successful, you need more...
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...
Forums
Shelf Life Testing Laboratory | FARE LABS Pvt. Ltd.
Fare Labs' shelf life testing facility has been accredited by the NABL. The best...
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...
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