Do you connect to your work network with your smartphone? If so, you should be careful and ensure you are taking precautions to prevent any security issues.

Raw Materials - Og, Sumerian DBA, Part 2

by Larry Gonick

SQLServerCentral.com

Raw Materials

A disruptive innovation raises an old, old question.

SQL Server Service Broker demystified

by kautuk

SQLServerCentral.com

Service Broker (SSSB)

Simplified explanation of whats and hows of Service Brokers

Jeff Moden: DBA of the Day

by Additional Articles

SimpleTalk

Jeff Moden

Jeff Moden's election to the Exceptional DBA of the Year award for 2011 was a popular one. Although all the finalists were exceptional, Jeff has impressed everyone with his energy, stamina and wit, particularly with his work on SQL Server Central. In conversation with Richard Morris, Jeff comes up with several nuggets of advice and opinion that are valuable for any DBA or database developer.

PASS Data Architecture VC presents Row Versioned Data Warehouses with Jeremy Huppatz

by Press Release

SQLServerCentral.com

Events

On Thursday December 15th at 8PM Pacific, Jeremy will discuss the strengths and disadvantages of a row-versioned data warehouse design in the context of a real world case study, sharing lessons learnt and demonstrating some of the technologies and techniques used to build a row-versioned data warehouse

Propose this to your boss

by Steve Jones

SQLServerCentral.com

Editorial

If you would like to tackle an interesting project at work or find yourself something new to do next year, read this idea from Steve Jones.

Stairway to T-SQL DML Level 6: The Basics of Sorting Data Using the ORDER BY Clause

by Gregory Larsen

SQLServerCentral

In this Level you will see how to use the ORDER BY clause to return your data in a sorted order.

Changes to SQL Server 2012 Execution Plans

by Grant Fritchey

SQLServerCentral.com

Execution Plans

I’ve been working with execution plans quite a lot in SQL Server 2012. There are a number of changes, most of them associated with new or different functionality. I had not noticed anything really fundamental until recently. I’ve become a huge proponent of always checking the properties of the SELECT statement. There’s so much useful information in there about what’s happened with the plan generation in the optimizer (not low level stuff, but the big picture items) that you should always be checking it first as a fundamental part of your plan examinations.

Faster Restores: Best Practices to Increase Speed

by Additional Articles

SimpleTalk

Backup

Backups are an everyday part of DBA life, whereas restores tend to happen on call at 3 a.m. In this article, Grant Fritchey looks at what you should be doing to make your restores as quick and seamless as possible.