I remember seeing the telepresense robot on The Big Bang Theory and thinking it was somewhat silly, and not a great substitute for a live person. The whole episode was a bit humorous and funny, with Sheldon attempting to prevent himself from befalling any harm by using the robot to substitute for him at work.
It's amazing how your view of the world can change in a few years. The past three years have had me traveling 15+ times a year to various events to deliver presentations on a variety of topics. However I'm cancelling all future talks in 2014, at least for live travel.
The VGo telepresence robot has been offered to Red Gate on a trial basis for us to test it in a number of ways. We are looking to use this robot to allow us to reach more users and deliver more talks as well as perform consulting for some of our customers. We have worked with VGo to not only allow a broadcast presence of myself or a developer from Red Gate, but we have built a turnkey demonstration system.
With a custom shipping container holding the VGo and a Gigbyte BRIX mounted on it, anyone can easily unpack the robot in minute, unfolding it in a room, plug it into power, a microphone, and a video projector. It will automatically power up and log onto the Verizon network, where I can connect to it from home and reconfigure it for local networking. I can not only control the robot and address an audience (as well as hear them), I can also control the various VMs on the BRIX and demonstrate any SQL Server setup that suits the talk.
As you might guess, this will allow me to broadcast to SQL Saturday events every week as well as attend many other conferences. If things work well, Red Gate is looking to deploy a few of these for not only presentations, but also for consulting in helping our customers use our tools to build robust software delivery piplines. We can ship one to a customer and then work with them in a remote situation.
I've very excited about the entire pilot, mostly because it's a joke on April 1. For now. Perhaps we'll give this a try at some point.
NEW! The DBA Team in The Girl with the Backup Tattoo
Piña colada in the disk drives! How could any DBA do such a thing? And can the DBA Team undo the damage? Find out in Part 2 of their new series, 5 Worst Days in a DBA’s Life. Read the new article now.
24% of devs don’t use database source control – make sure you aren’t one of them
Version control is standard for application code, but databases haven’t caught up. So what steps can you take to put your SQL databases under version control? Why should you start doing it? Read more to find out…
Generate realistic test data, fast
“In less than the time it took me to get my coffee, I had a database with 2 million rows of data for each of 10 tables.” Stephanie Beach, QA Manager. Try SQL Data Generator now.
SQL Server Execution Plans shows you what's going on behind the scenes in SQL Server. They can provide you with a wealth of information on how your queries are being executed by SQL Server, including: Which indexes are being used, and where no indexes are being used at all. How the data is being retrieved, and joined, from the tables defined in your query. How aggregations in GROUP BY queries are put together. Grab your copy today from Amazon!
Yesterday's Question of the Day
(by Anoo S Pillai):
A new database is created for entertaintment application. The create script follows:
CREATE DATABASE wonderland
CREATE SCHEMA king_schema AUTHORIZATION dbo
CREATE USER king_user FOR LOGIN king_login WITH DEFAULT_SCHEMA = king_schema
EXEC sp_addrolemember N'db_owner', N'king_user'
After creating the database, connected to the instance with king_login. Tried to create a table using the following script:
CREATE TABLE wonders
, wonder VARCHAR(100)
In which schema the table would be created ?
Test environment : SQL 2008 R2, Collation - Latin1_General_CI_AI
Answer: Table will be created; the schema - it depends, it can be 'dbo' or 'king_schema'
The create table command is valid and hence table would be created.
By default, the table would be created in default schema. But there is a caveat - for members of sysadmin fixed server role the default schema would be dbo.
In this context it means -
If 'king_login' is a member of sysadmin fixed server role table would be created under schema dbo, other wise table would be created under schema king_schema.
- Okay, a topic that has NOTHING to do with SQL . . .
Came across [url=http://www.sqlservercentral.com/Forums/Topic447796-4-1.aspx]this link[/url] describing the SSC point scoring descriptions,...
Today's Random Word!
When you woke up today, or logged-onto Opera Forums, you may have had a dream, a thought, a scene...
DBAs happiest people at work
is it really true??
This newsletter was sent to you because you signed up at SQLServerCentral.com.
Feel free to forward this to any colleagues that you think might be interested.
If you have received this email from a colleague, you can register to receive it here.