SQLServerCentral Webinar #11 Q&A - A Sandbox Development Process
The answers to questions from our webinar on Sandbox development.
2011-07-25
295 reads
Site Owners
Database Size Survey
Help us collect some data on the sizes and counts of databases in your environment. Take a few minutes and answer this survey.
2011-07-18 (first published: 2011-07-01)
3,219 reads
2011-06-25
3,331 reads
2011-05-30
1,203 reads
Cartoonists Wanted
An open call to the amatuers that might want to pen some database related cartoons for Simple Talk Publishing.
2011-05-27
1,796 reads
Stairway to SQL Server Reporting Services
A series from MVP Jessica Moss designed to help you understand Reporting Services and begin building reports.
2011-02-09
3,942 reads
Stairway to Database Design
A series by Joe Celko that examines the craft of designing a database to meet your needs.
2010-12-06
12,944 reads
Decoding the SQL Server Index Structure
A deep dive into the implementation of indexes in SQL Server 2008 R2. This is information that you must know in order to tune your queries for optimum performance. Partial scans of indexes are now possible!
2010-04-01
8,197 reads
2009-11-04 (first published: 2009-10-16)
169 reads
The 2009 SQLServerCentral party at the PASS Summit
Get some details about the 2009 SQLServerCentral party at the PASS Summit in November.
2009-10-29 (first published: 2009-07-20)
2,193 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
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