SQL WTF for T-SQL Tuesday #88

The topic for this month’s T-SQL Tuesday is: “Be inspired by the IT horror stories from http://thedailywtf.com, and tell your own daily WTF story. The truly original way developers generated SQL in project X. Or what the grumpy "DBA" imposed on people in project Y. Or how the architect did truly weird "database design" on … Continue reading SQL WTF for T-SQL Tuesday #88

This month’s T-SQL Tuesday post

…is not here. It’s over at https://sqlperformance.com/2017/01/sql-performance/estimated-number-of-rows-to-be-read I write about the new EstimatedRowsRead property, and in particular, about how Microsoft responded so well to the Connect Item I created, requesting the feature. @rob_farley

Backups – are you missing the point?

It’s a common question “Do you have a backup?” But it’s the wrong question. Very relevant for this month’s T-SQL Tuesday, hosted by Ken Fisher (@sqlstudent144), on the topic of backups. I think the question should be “Can you recover if needed?” We all know that a backup is only as good as your ability … Continue reading Backups – are you missing the point?

How I prepare for a presentation

Some people say I talk a lot – but I guess it depends on the context. Certainly, for many years, I’ve been fairly comfortable about standing up in front of people and explaining things. Whether it’s teaching a course, leading a workshop, presenting at a conference, or preaching at a church, it all has that … Continue reading How I prepare for a presentation

PASS Summit 2016 – Keynote 2

Thursday! Kilt day. We start with Grant Fritchey (PASS’ VP of Finance, in a kilt), talking about the various metrics of PASS, which show that the community is growing both numerically and graphically, reaching 87% of countries now. It’s good to know that things are going well. This is all public information, and I’m not … Continue reading PASS Summit 2016 – Keynote 2

PASS Summit 2016 – Blogging again – Keynote 1

.So I’m back at the PASS Summit, and the keynote’s on! We’re all getting ready for a bunch of announcements about what’s coming in the world of the Microsoft Data Platform. First up – Adam Jorgensen. Some useful stats about PASS, and this year’s PASSion Award winner, Mala Mahadevan (@sqlmal) There are tweets going on … Continue reading PASS Summit 2016 – Blogging again – Keynote 1

Passwords – a secret you have no right to share

I feel like this topic just keeps going around and around. Every time I’m in a room where someone needs to log into a computer that’s not theirs, there seems to be a thing of “Oh, I know their password…”, which makes me cringe. I’ve written about this before, and even for a previous T-SQL … Continue reading Passwords – a secret you have no right to share

You’ve been doing cloud for years…

This month’s T-SQL Tuesday is hosted by Jeffrey Verheul (@devjef) and is on the topic of Cloud. I seem to spend quite a bit of my time these days helping people realise the benefit of the Azure platform, whether it be Machine Learning for doing some predictions around various things (best course of action, or … Continue reading You’ve been doing cloud for years…

The Impact of Compression Delay in Real-time Operational Analytics

I have a session coming up at both the PASS Summit in October and the 24HOP Summit Preview event in September, on Operational Analytics. Actually, my session is covering the benefits of combining both In-Memory and R into the Operational Analytics story, to be able to see even greater benefits… …but I thought I’d do … Continue reading The Impact of Compression Delay in Real-time Operational Analytics

Finally, SSMS will talk to Azure SQL DW

Don’t get me started on how I keep seeing people jump into Azure SQL DW without thinking about the parallel paradigm. SQL DW is to PDW, the way that Azure SQL DB is to SQL Server. If you were happy using SQL Server for your data warehouse, then SQL DB may be just fine. Certainly … Continue reading Finally, SSMS will talk to Azure SQL DW