But We Have Always Done It That Way
I recently ran across the following scenario. A SQL Server instance had been upgraded from SQL Server 2005 to SQL...
2010-02-02
2,081 reads
I recently ran across the following scenario. A SQL Server instance had been upgraded from SQL Server 2005 to SQL...
2010-02-02
2,081 reads
Not all DBAs have the opportunity to attend formal classroom training or attend conferences. While there are many SQL Server...
2009-11-23
841 reads
SQL Server MVP Deep Dives, a new book written by 53 SQL Server MVPs, is now available as an eBook,...
2009-10-12
785 reads
I am in the process of creating a new blog, but I am having difficulty coming up with a good name. I would like to go with a Hawaii-based theme on the blog, so a Hawaii-based name would be great.
2009-07-20
541 reads
In the last year or so, there have been a lot of articles, blog entries,and forum posts on the kinds of technical questions hiring managers can ask a prospective DBA candidate in order to determine their technical proficiency. While technical skills are...
2009-07-06
2,966 reads
Brad McGehee provides a "career guide" for DBAs. It is intended both to help prospective DBAs find a "way in" to the profession, and to advise existing DBAs on how they can excel at their jobs, and so become Exceptional DBAs.
2009-06-03
6,623 reads
The sixth and last module of the training course "Becoming a Profiler Master", describes how to create custom Profiler traces, tailored to the specific performance problem you wish to investigate.
2009-05-21
9,163 reads
The fifth module of the training course "Becoming a Profiler Master", looks in details at the data columns that are associated with the Profiler events discussed in module 4.
2009-05-19
9,783 reads
The fourth module of the training course "Becoming a Profiler Master", takes a detailed look at the many events and event categories that can be collected with Profiler.
2009-05-14
8,454 reads
This, the third installment of the "Becoming a Profiler Master" online training course, shows how to start, stop and control Profiler and how to save the traces.
2009-05-12
8,970 reads
By HeyMo0sh
In my experience, FinOps success has never been just about tools or dashboards. It...
By HeyMo0sh
As a DevOps person, I know that to make FinOps successful, you need more...
By HeyMo0sh
As someone who works in DevOps, I’m always focused on creating systems that are...
Comments posted to this topic are about the item Restoring On Top II
Comments posted to this topic are about the item SQL Art 2: St Patrick’s...
Comments posted to this topic are about the item Breaking Down Your Work
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