'Split, Sort & Collapse' is, happily, not a description of the intrepid Fabiano Amorim after his epic series of articles about the ShowPlan operators. With renewed stamina, Fabiano continues his mission to describe all the major operators by explaining the Trivial Plan and the power of unique indices.
After a bad experience traveling, Steve Jones stops to recognize that despite a possible computer bug, he still recognizes that the programmers building web sites aren't making mistakes on purpose and deserve a thank you for their work.
Metalogix Selective Restore Manager streamlines the process of finding and recovering individual documents and lists directly from a SharePoint content database backup file without the need for a recovery farm. When used in conjunction with Red Gate’s SQL Virtual Restore, Selective Restore Manager can recover documents and lists without physically restoring the backup file—saving time and much needed disk space. Together, Metalogix Selective Restore Manager and Red Gate SQL Virtual Restore open up new possibilities for your SharePoint backup and recovery strategy. Apr 21, 2011, 11am EST.
Whilst getting some courseware ready I was playing around writing some code and I decided to very simply show when a window starts and ends based on you asking for a TumblingWindow of n time units in StreamInsight. I thought this was going to be a two second thing but what I found was something I haven’t yet found documented anywhere until now.
Have you ever wanted a mentor? Do you think that your career would benefit from having one? Steve Jones talks about a new experiment that he is putting in place with Andy Warren that looks to build a mentoring framework.
Join Normalization nut Thomas LeBlanc for a review of a standard operating procedure used among DBAs at an employer. See the changes he made after joining the BI group at this employer. The session will go through naming conventions, check list for creating a table, formatting in stored procedures, and more. A brief preview of the SQLRally talk 3rd Normal Form: That’s Crazy Talk!!! Will be given about Lookup tables. Thur, Apr 21, 2011, 12:00pm EST.
This article demonstrates how a DBA can check for policy compliance by leveraging the Policy Based Management Feature of SQL Server.
This editorial was originally published on Sept 22, 2005. Steve Jones talks about the dangers of blogging about your job and with your company. Be sure that you are aware of what the impact of your posts will be on your image.
Windows Resource Monitor can be a very useful tool for initial diagnosis of performance issues. In this two part series we look at how to troubleshoot performance issues using Resource Monitor.
This webinar, presented by Noemi Moreno, BI Developer at Red Gate Software, will consist of a 30 minute software demonstration followed by Q&A. You will see SQL Developer tools in action, and how they can simplify and enhance your Business Intelligence applications. This takes place on Apr 19, 2011 from 4pm-5pm GMT.
By HeyMo0sh
As someone who works in DevOps, I’m always focused on creating systems that are...
By Brian Kelley
I am guilty as charged. The quote was in reference to how people argue...
By Steve Jones
Learn how to tie a bowline knot. Practice in the dark. With one hand....
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