SQLServerCentral Webinar #11 Q&A - A Sandbox Development Process
The answers to questions from our webinar on Sandbox development.
2011-07-25
239 reads
SQL Virtual Restore
SQLServerCentral Webinar Series #11: A Sandbox Development Process
Steve Jones is your host introducing Grant Fritchey who'll present this webinar. This session explores the use of two Red Gate products, SQL Virtual Restore and SQL Source Control, in establishing a well-defined development process that allows for the use of known data sets and source code management of your database code. These tools work together to help you create a sandbox environment where you can test and develop your databases. Working with a development process is the best way to ensure a safe deployment process to protect your production systems.Developing software without establishing a good process can be a situation rife with the possibility of disaster.
2011-07-21
2,213 reads
SQLServerCentral Webinar Series #10: SQL Server Backup and Restore for the Accidental DBA
Thursday, May 26, 2011 5:00 PM - 6:00 PM BST. Steve Jones will be your host to introduce Grant Fritchey, SQL Server MVP and Product Evangelist at Red Gate Software.
This webinar will take you through the best practices, standards and methods that you can employ to ensure that you have solid backup processes for the databases under your charge. You’ll also learn how to restore, because your backups are only good if you can restore them. Grant will show you how using Red Gate’s SQL Backup Pro and SQL Virtual Restore can make all this easier and more efficient.
2013-09-18 (first published: 2011-05-23)
4,356 reads
Performing DBCC Checks Using SQL Virtual Restore
Ever restored a corrupted database from the backup, only to find that the backups are corrupted too - All the backups? Sure it can happen and it isn't nice when it does. To check that a database backup is internally consistent you have to use DBCC CheckDB. On a huge highly-loaded live system? Grant Fritchey has, as usual, a practical solution.
2011-05-02
3,896 reads
Supporting Large Scale Team Development
With a large-scale development of a database application, the task of supporting a large number of development and test databases, keeping them up to date with different builds can soon become ridiculously complex and costly. Grant Fritchey demonstrates a novel solution that can reduce the storage requirements enormously, and allow individual developers to work on thir own version, using a full set of data.
2011-03-29
3,364 reads
SQL Server Central Webinar Series #8: Creating smaller and comprehensively verified backups
The next webinar from SQLServerCentral will look at backups and how you can create faster, smaller, and verified backups. Join Steve Jones and Rodney Landrum for this presentation on SQL Backup Pro and SQL Virtual Restore
2011-01-27 (first published: 2011-01-18)
1,891 reads
RE: Query analyser fails when execution plan shown
>>Installed XML on both server and locally? Not exactly sure what's installed on the server(s) in terms of XML, but I get exactly the same results when I connect to the local SQL Server instance, as when I connect to a remote server. To reproduce it, I just need to run SELECT 1 example FOR […]
2003-08-20
1 reads
RE: Why does the Transaction Log keep growing?
Another reason this can happen is if you're running transactional replication and the log reader isn't running. Andy http://qa.sqlservercentral.com/columnists/awarren/
2003-08-16
1 reads
RE: Identity Function
Hi Mike, quote: I'm using the identity function to insert an identity field (as it happens) into a temporary table. I'm seeding the value based on the max from another table. ... Now although this essentially works in that it provides a unique value, the starting value (7990448) bears no relationship to @Seed1 (1). If […]
2003-08-05
RE: Conflicting server versions
http://qa.sqlservercentral.com/columnists/sjones/gettingyourserverinformation.asp Steve Jones sjones@sqlservercentral.com http://qa.sqlservercentral.com/columnists/sjones www.dkranch.net
2003-08-01
Blogs
Simple Talks Episode 7
By Steve Jones
The season 1, seventh episode of Simple Talks is out. Check it out, with...
A New Word: the McFly effect
By Steve Jones
the McFly Effect – n. the phenomenon of observing your parents interact with people...
Key mappings in Visual Studio Code
At a recent conference I was asked how I executed code during my presentation....
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers