How to Setup Log Shipping for Multiple Databases
This article by Brian Davey describes how to setup log shipping for a large number of databases minimizing the number of jobs needed thus significantly reducing CPU and memory usage.
Data Mining Query Task in SQL Server Integration Services
One of the primary goals of business intelligence is to transform raw data into meaningful information, by combining its sources, discovering its dependencies and patterns, and using them to predict future trends.
Custom SSMS Shortcuts for ETL Developer. Part 2: Extended Properties
With the following technique, you can quickly read information stored in the extended properties of a SQL Server table.
Know when to hold 'em
It's time for the SQLServerCentral Party at PASS and Steve Jones talks about the event.
Find Last Restart of SQL Server
How can you tell when your SQL Server instance was last started? In this tip we look at various methods of how to get the start time for a SQL Server instance.
Probabilities and Disaster Recovery
Today Steve Jones talks about the probabilities of different types of disasters occurring in your enterprise. He reminds you that the effort spent on disaster recovery ought to be related to the cost of the disaster, and the risk of it actually occurring.
Where are all the MVBs?
Whereas there are plenty of experts prepared to help with the technology, few seem to come forward when the struggle is against the bureaucracy rather than a recalcitrant server. Where are all the SQL MVBs (Masters at Vanquishing Bureaucracy) when you need them!?
Come Visit the Tacoma SQL Server Users Group
A new user group is forming at the University of Washington in Tacoma, WA. Come to their next meeting on Sept 29th, 2011.
SQL Code Reuse: Teaching a Dog New Tricks
Developers, by every natural instinct and training, strive to make their code reusable and generic. Dissuading them from doing so, in certain circumstances, is akin to trying to persuade a dog not to fetch a stick.
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