elsancho1972

36 Flips | 5 Magazines | 15 Likes | 12 Following | 1 Follower | @elsancho1972 | Keep up with elsancho1972 on Flipboard, a place to see the stories, photos, and updates that matter to you. Flipboard creates a personalized magazine full of everything, from world news to life’s great moments. Download Flipboard for free and search for “elsancho1972”

List of Fixes in SQL Server 2008 R2 SP3

Service Pack 3 contains all the fixes from 2 years worth of Cumulative Updates, as well as two additional fixes. Here is a complete list of the fixes …

Building Your First Cube

If you've worked in any technology-related field, you've probably heard the term cube thrown around, but most traditional DBAs and database …

Databases

The Popular Mechanics Boot Selector

How to choose the right pair, no matter what kind of man you are.<p>How to choose the right pair, no matter what kind of man you are. <b>RELATED: All the Gear You Need This Fall.</b>

SSMS Tools Pack 1.9.3 is out!

This release adds a great new feature and fixes a few bugsThe new feature called <b>Window Content History</b> saves the whole text in all all opened SQL …

Sql

The Mega Guide to Free SQL Server Tools

At <i>SQL Server Magazine</i>, we’re all about helping DBAs and developers do their jobs faster and more efficiently—especially now, when they’re being …

5 Free SQL Server Tools to Give You a Boost

Free tools that help you solve problems are always handy. Take a look at these five useful and free SQL Server tools that can make you more …

SQL Servers

Missing Indexes Correlated Against Execution Costs and Counts

Here’s a query that every DBA should have in their toolbox.<p>The short (or seriously over-simplified) version of how this query works is pretty simple. …

How record DELETEs can cause index fragmentation

<b>Question:</b> Our team has been discussing causes of index fragmentation and someone argued that DELETE operations can cause fragmentation just like …

Databases

‘Unshackling’ big data for marketers: Sitecore’s new real-time NoSQL platform is a game-changer

It’s a modern marketer’s dream to view each customer’s every experience with a brand in real time across web, mobile, social, offline channels, and email — and have the capability to communicate, present offers, and manage experiences at precisely the same rate.<p>That 1-to-1 marketing dream is …

Troubleshooting Slow Servers

Denny CherryFind the true cause of a performance bottleneckMissing indexes, an inadequate storage I/O subsystem, or a slow network are only some of …

Improving Query Performance by using correct Search Arguments

<b>(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan – you get a weekly email packed with all the essential knowledge you need</b> …

Free SQL tools

These @ApexSQL tools are some of the best free SQL Server productivity tools I have used. A must for heavy SSMS users.<p>— Rob de Mercado (@LutonReject) …

T-SQL 101, Lesson 1

Welcome to T-SQL 101. Over the course of the next 10 lessons, you’ll learn the basic principles to follow when writing queries with T-SQL. By the end …

Databases

H - Top Ten Performance Results

SQL Servers

How To Make a Grilled Cheese Sandwich

<b>Melt the butter in the skillet:</b> Place the skillet over medium heat and add the butter. Let the butter melt completely. When the butter begins to …

Grilled Mojo-Marinated Skirt Steak Recipe

Skirt steak, with its coarse texture and hearty grain is a great cut for marinating, particularly when the marinade is a garlicky mix of lime and orange juice. As it chars over a hot flame, the interior ends up buttery-rich. Serve this steak with grilled potato wedges for a complete meal.<p><b>Note:</b> An …

Log In or Sign Up to View

This Facebook post is no longer available. It may have been removed or the privacy settings of the post may have changed.

Magical, Retractable Tire Studs Only Deploy When You Need Them

Remember the scene in <i>The Living Daylights</i> where James Bond blasts across a frozen lake in his Aston Martin and presses a button to deploy metal …

Doing It Wrong: Virtualizing SQL Server

I’ve been involved in a virtualization projects for almost ten years now. In that time I’ve had the opportunity to track my own list of “best …

SQL Server Troubleshooting Useful Links

When it comes to troubleshooting performance issues with SQL Server queries, you don’t need an advanced degree in rocket surgery.<p>You just need an …

The Great Prime Rib Secret

This year, I decided to roast a prime rib for Christmas. And, since I had a large group of food-worshiping people coming over (a dozen of them), I decided to go all the way: a whole prime rib from the best butcher in town. It cost a fortune, but it enabled me to confirm my fondest secret about …

Cooking

How We Deploy 300 Times a Day

Part of my job at HubSpot is to meet and welcome new potential HubSpot engineering hires. One of the most surprising things I get to tell them is …

Engineering

Eyjafjallajokull Volcano Iceland

PayPal Updates iOS And Android Apps With The Ability To Order Ahead, Pay Restaurant Bills, Access Bill Me Later And More

PayPal is announcing a major update to its iOS and Android apps today, creating a more seamless experience when paying for items in stores and retail outlets. Check out our video above for an in-depth demo of the app being used by myself and PayPal VP of Global Product Hill Ferguson in San …

Why You Must Absolutely Paint your Walls Gray

<b>Gray</b> is the hot new “in” color. It’s recently taken front and center, upstaging it’s neutral cousins, taupe, beige and ivory. Gray is the little …

Painting Prep, Step-by-Step: How To Ready Your Room for a Fresh Coat of Color

Painting itself goes rather quickly — it's the prep that takes a while, but it's also what lays the foundation for a professional-looking job well …

Home Improvement

How to Take Amazing Flower Photos

Flowers are one of my favorite photography subjects. They can’t complain if the photo doesn’t come out right. Flowers also look very different when …

Experimental Light Painting Self-Portraits

Self-portraits aren’t exactly ground-breaking — in fact, the word “selfie” was recently added to the dictionary — but Alex DeForest‘s self-portraits …

Rosh Hashanah 2013: The Jewish New Year Explained

Rosh Hashanah, the Jewish New Year, is celebrated in 2013 from sundown on Sept. 4 to nightfall on Sept. 6. The Hebrew date for Rosh Hashanah is 1 Tishrei 5774.<p>Though Rosh Hashanah literally means "head of the year," the holiday actually takes place on the first two days of the Hebrew month of …