Month: July 2016

SQL SERVER – Fix Error Msg 13602 working with JSON documents — Journey to SQL Authority with Pinal Dave


My saga of working with JSON documents and finding out the various errors continues. With JSON being one of the new data structures introduced inside SQL Server 2016, I have been exploring to how these are fundamentally different from using the FORXML constructs. The more I have been working and testing with this capability, the…

via SQL SERVER – Fix Error Msg 13602 working with JSON documents — Journey to SQL Authority with Pinal Dave

Advertisements

SQL SERVER – Detected a DTC/KTM in-doubt Transaction with UOW — Journey to SQL Authority with Pinal Dave


Recently, one of my clients contacted me to assist in fixing and issue which was causing their production database to be in SUSPECT state. The learnings I am getting from various consulting engagements is awesome and the after effect of this is a number of blogs I have published in the recent past. They were…

via SQL SERVER – Detected a DTC/KTM in-doubt Transaction with UOW — Journey to SQL Authority with Pinal Dave

Why most startup CMOs will fail — VentureBeat


GUEST: Venture capital investors, to a person, claim that they invest in teams, not product. Strong teams, they argue, can respond to changing market dynamics and pivot, if necessary, to the right product. For that reason they’re actively involved in the interviewing and hiring of all executive team members. Historically, in assembling this team, the…

via Why most startup CMOs will fail — VentureBeat

Marketers: Email prompts are trendy but dangerous — VentureBeat


GUEST: It’s trendy for marketers to BAM-KAPOW their visitors with pop-up pleas to “JOIN OUR MAILING LIST!” These animated boxes, powered by hot startups like SumoMe and OptinMonster, promise a firm ROI handshake. In exchange for a smidgen of JavaScript, you’ll receive a lifetime of customer correspondence. But hold onto that handshake a little longer…

via Marketers: Email prompts are trendy but dangerous — VentureBeat

How to Send Execution Plan in Email? – Interview Question of the Week #079 — Journey to SQL Authority with Pinal Dave


A few days ago, I sent emails to everyone who subscribed to my newsletter (if you have not subscribed, you are missing out some real fun) that they can send me one performance problem of theirs like and I will help them solve it in 24 hours. I received over 1082 responses in the first…

via How to Send Execution Plan in Email? – Interview Question of the Week #079 — Journey to SQL Authority with Pinal Dave

Xcode Key Bindings — Tong Tian


Command + 0(zero) = Show/Hide Navigator Command + 1/2/3/4/5/6/7/8 = Show Project/Symbol/Find/Issue/Test/Debug/Breakpoint/Report Navigator Shift + Command + Y = Show/Hide Debug Area Option + Command + 0 = Show/Hide Utilities Area Option + Command + 1/2/3/4/5/6 = Show Utilities File/Help/Identity/Attributes/Size/Connections Inspector Option + Command + Return = Show Assistant Editor Command + Return = Hide Assistant Editor Command + T = Create […]

via Xcode Key Bindings — Tong Tian

5 Stages that Improve Sales Forecasting — Global Business the Mo Casas Way


It can be difficult to forecast B2B sales, resulting in large variations between the closing expectations and actual sales. Each salesperson has a certain style, optimism, drive and risk aversion. Sales managers and executives are expected to judge these personal variations to project sales to Corporate with acceptable accuracy. Forecasting can be subjective, resulting in […]

via 5 Stages that Improve Sales Forecasting — Global Business the Mo Casas Way