I am honored to be speaking at Data in Devon today presenting my “Where Should My Data Live (and Why)?” session here at the conference in Exeter, England. I’ve created this quick post just to give attendees the opportunity to download the steps for the demos I typically do during a longer session slot. I’ve also included a link to the presentation itself as well. If you’ve arrived at this page, welcome and thanks for attending my session!
I’m really excited to be publishing a real live technical blog post! I have fun blogging about speaking, travel for speaking, and racing, but I’m looking forward to my new professional opportunities lending themselves to more technical blogs on a variety of data platform topics. I’m really looking forward to blogging on some more cutting-edge data platform topics as well, but for today I have a bit of a blog about a SQL Server feature that doesn’t get a lot of love. We can debate all the reasons for why stretch database hasn’t seen a lot of use, but it’s still there and still an interesting feature to play with.
Recently I had the pleasure of putting together a proof-of-concept for a customer who was looking into using Stretch Database to offload a large amount of archive data into Azure rather than their own datacenter(s). This particular application had some tables that were created nearly 15 years ago (a fact that will become relevant shortly). Enabling Stretch Database is covered well in the Microsoft document here so I’ll skip straight to the error I was getting.
I noticed when I enabled Stretch Database (via the wizard) some tables were starting to migrate completely normally and some were not. I began querying sys.dm_db_rda_migration_status (a DMV used for monitoring Stretch Database operations) and saw that all of the tables that were not moving were registering error 7320 in the error_number column of that DMV. A quick search on the error revealed the following text of the generic error: Cannot execute the query “%ls” against OLE DB provider “%ls” for linked server “%ls”. %ls. Not very helpful, is it? It was at this point we contacted Microsoft support because we thought we’d found a bug – some tables were migrating correctly and some weren’t, even though they’d all been configured for stretch the same way via the wizard. Our support ticket went between Azure SQL Database support and SQL Server support before we were connected with a solid engineer who assisted in troubleshooting but was unable to find anything incorrect in the tables or the way Stretch Database was configured.
We were at a loss but he recommended another review of the SQL Server error log to see if there was anything untoward there at all that we had missed in our previous reviews. What I noticed in that final review was that we were occasionally seeing errors relating to ANSI_NULLS settings in the error log. Cross-referencing that with the times the Stretch Database migration process was attempting to kick off on the erroring tables revealed that something to do with ANSI_NULLS was breaking Stretch Database migration. But what?
I relayed this information to the support engineer and he contacted the development team to ask what ANSI_NULLS had to do with Stretch Database migration throwing an error related to linked servers – an odd chain of errors. They replied and said that if a table was created with the ANSI_NULLS setting set to OFF then the Stretch Database migration process will throw that linked server error. These tables, due to their age I mentioned earlier, were created with that setting set to OFF. Problem solved! (Although changing the ANSI_NULLS setting for hundreds of related tables is its own set of challenges that should be its very own blog post). In better news, the support engineer submitted a request to the docs team to clearly document this previously undocumented issue.
I realize, given the minimal adoption of Stretch Database, this blog post may be targeted towards a limited audience. That said, if it helps just one person avoid the issues that I ran into and save hours or days of work to figure this out, it is a huge help to somebody! If that somebody is you, cheers!
As always, thanks for reading and come back soon – there will be much more content here as 2019 rolls on.
For the folks that follow my blog and have noticed it’s been a bit quiet around here – apologies. Personally and professionally, the last 3 months or so have been quite a whirlwind but I’m still here and the blog is too. Tomorrow there will be a real live technical post here on the site, but for today I wanted to get a post up noting my next three speaking engagements.
Saturday, March 30 I will be speaking at SQL Saturday Cincinnati. I will be presenting my fairly new session “Azure-d Availability: Scaling SQL Server to the Cloud” and I’m excited to be speaking at one of my local-ish SQL Saturdays. The link to my session is here and the registration button for the event is in upper right corner of that page.
Following that, I’ll be presenting to Midlands PASS in Columbia, SC at 5:30 PM on Tuesday night. I went to college at Clemson so, in some ways, Columbia is a bit like home. If you’re familiar with the Clemson/South Carolina rivalry, however, in some ways it’s not. 🙂 Either way I’m looking forward to speaking to the group about Azure Logic Apps, Azure SQL DB, and sentiment analysis using Azure Cognitive Services as long as they don’t boo me out of there! The session link is here for those interested and in the area.
Finally, I’ll be crossing the Atlantic once again to speak at Data in Devon in the southwest of England. This is the event formerly known as SQL Saturday Exeter and I’m thrilled to be presenting my “Where Should My Data Live (and Why)?” session to an international audience. If you are at all close to the area or fancy a weekend in southwest England with some excellent training (and my session), the registration link is here.
Thanks for reading and I hope I see you at one of these events. Thanks to IDERA Software for making some of this travel possible. I hope you’ll come back tomorrow (March 29th) for my first technical blog in a while.
For this 108th edition of T-SQL Tuesday, Malathi Mahadevan (b|t) has come up with a wonderful topic – non SQL Server technologies. As the Microsoft data platform continues to expand, our jobs as data professionals are requiring us to learn and embrace technologies outside of the traditional relational database platform. After spending last week at PASS Summit 2018 and being reminded again about the amazing diversity of the SQL Server/Microsoft Data Platform ecosystem, this topic seems especially well-timed. Nicely done, Mala!
The non SQL Server technologies that I’ve selected for this post are the pair of technologies that have been oddly involved in my life for the last year or so: Azure Logic Apps and the Cognitive Services API. I was fortunate enough to be selected to speak about these topics at PASS Summit this year and it’s been a strange journey from, in a little over a year, never having heard of Logic Apps and Cognitive Services to creating training for them and speaking in the community about them. Long story short, I heard a Men in Blazers podcast last October where they jokingly mused about ranking English Premier League teams by the supporters’ feelings rather than actual results on the pitch. I had recently read some logic apps blogs from Brad Ball (b|t) and thought I could take what I learned from those and turn it into the “mood table” that was discussed on the pod. If you’re interested in the technical details of what I did, click here and read my blog from last year about how I did it. That post also links to a deep dive post with even more detail.
That post, and the mood table’s weekly appearance on the podcast for months, set the table for me to begin presenting a logic app and Cognitive Services session at PASS community event and non-PASS technical meetups as well. That drove me to better understand the power of logic apps and what else I can do with them with or without wiring in Cognitive Services as well. I submitted that session for this year’s PASS Summit and it was selected so I dove into these topics even further in order to build a robust 75-minute session.
The story behind my initial effort for the podcast and how that turned into a session brings us to today. What are my plans for learning more about this? I’ve partnered with a company on some logic apps training and will release that information when the course is released. There is a possibility of building onto that course with a subsequent advance course. Creating that training content forced me to really dig into some concepts within logic apps and cognitive services that I was not very familiar with from just my “playing” with these technologies for the mood table. It’s also really opened my eyes to just how powerful logic apps are for coordinating workflows for real companies with real data flows (not silly soccer-related podcasts :-)). I’m looking forward to integrating Azure Logic Apps and Cognitive Services with customer work in 2019 so customers can see how useful Logic Apps can be when moving and transforming their data. Cognitive Services can offer huge value to customer-facing departments such as customer support and marketing. I can’t wait to begin talking more about these technologies with my customers and learning more about them as we work together.
This morning (October 18th, 2018) I had the opportunity to present my “New Features and New Speed in SQL 2016 (+) Always On Availability Groups” session remotely to the community of people registered at DataPlatformGeeks.com. DPG is the group behind the Data Platform Summit, which will be at the Radisson Blu in Bangalore from August 22-24, 2019 (pre-conference sessions offered August 19-21). While I certainly hope to submit to DPS in 2019, today was a lot of fun and good chance to speak to their community.
My session began at 5:30 AM Eastern (I’m based in Lexington, Kentucky, USA). That is 3 PM IST. My kids wake up around 6:30 AM to get ready for school. I presented the webinar from my home office and my kids were a bit confused as to why I had my headset on so early in the morning and appeared to be talking directly to my wall. I’ll never cease to be amazed at technology that allows us to share technical content to people halfway around the world – it’s awesome and I’m so fortunate to get opportunities to do this now and then.
I’m actually presenting another session to them on November 15th – I’ll be doing my “Where Should My Data Live (and Why)?” presentation that I gave at PASS Summit 2017. If you’d like to register for that, the link is here. If my session doesn’t interest you, though, go check out their events page to see all the good, free content that they make available throughout the year. For example, Bob Ward and Jonathan Kehayias are the last two sessions before I present on November 15th. Even if you think I’m a bit of a dodgy speaker, you can’t get any better than Bob and Jonathan! Til next time…
Greetings and thanks for dropping by! I have a couple speaking gigs to mention and a real racing gig to discuss and then I’ll leave you to your actual work instead of reading silly blogs.
I was supposed to head to North Carolina next week to present my “New Features and New Speed in SQL Server 2016 (and 2017) Always On Availability Groups” session to TriPASS in Raleigh. I was also going to use the trip to see some Triangle-area friends and some family in the Asheville area as well, but Hurricane Florence has other ideas and so I’ll be delivering the session remotely provided that the meeting still goes on. At this point, while I’m happy to present the session, I’m focused on the health and well being of all my friends and family in the Carolinas. While Florence’s winds have weakened, the forecasted rain looks quite significant and I’m definitely hoping for the best possible outcome there.
Mother Nature willing, I’ll be presenting my “Where Should My Data Live (and Why)?” session to the Atlanta Microsoft Database Forum on October 8th. I’m excited to speak to that group and looking forward to heading to another area where I have family and friends in the vicinity. If you’re Atlanta-based I encourage you to register here. As an aside, my mom lives north of Atlanta and has expressed an interest in seeing an Atlanta United soccer/football match so I’ll probably take her to the match on 10/6 at 3:30. If you’re an Atlanta United supporter I’d be happy to grab a pint with you pre-match. Feel free to comment below or tweet at me (@sqlatspeed) if you’d like.
Finally, I’m excited to talk about the opportunity I have to run a GTA-class Mustang (picture above) at the 2018 OVR Autumn Classic XXXVII at Mid-Ohio Sports Car Course October 13-14. If you’re around Central Ohio, let me know if you’d like to come out. I’d be happy to talk you around the circuit and walk you through the car as well. It’s been a while, but I’m happy to be able to live up to my @sqlatspeed Twitter handle. This is an introductory effort to a potential full-season opportunity next year. My sincere thanks to Win Smith Racing for the opportunity and to FGE Professional Sports Analytics for the support to make this happen.
That’s all the traveling news for now, but I’m proud to say I’ll be doing this traveling as a Microsoft Data Platform MVP. I’m honored to be awarded that designation and I’ll do my level best to maintain it and earn it in the coming year. Stay tuned to my blog for updates on the racing efforts (with in-car video) and an update on my recently announced PASS Summit session as well. Bye for now!
I wanted to post a short update to my readers to let you know about my upcoming speaking schedule to wrap up the summer and a couple other interesting things happening in late summer/early fall.
First of all, I’ll be speaking at SQL Saturday Indy on Saturday, August 11. I’ve really enjoyed giving this session (“Where Should My Data Live (and Why)”?) at several different events in both the USA and the EU this year. This session began life as my PASS Summit 2017 session but has evolved thanks to excellent attendee feedback (and continuing consulting engagements) into an interesting look at various clients’ and customers’ moves to and from cloud providers. I really enjoy giving this session and look forward to an interactive crowd at #SQLSatIndy. If you haven’t registered, there are just a few seats left and you can register here.
Following that, I’m really excited that I was selected to present at Azure DataFest Atlanta on Thursday, August 16th. I’ll be giving my “Democratizing Data Analysis: How and Why of Social Media Sentiment Scoring” presentation. I really love this one, and regular readers of the blog will recognize this as my “Men in Blazers Premier League Mood Table talk”. It’s evolved from a POC for a soccer podcast into a really interesting technical talk and platform for discussion and I’m thrilled to be speaking at this event in Alpharetta on 8/16. While I’m still a bit limited with what I can speak about regarding my work with FGE Professional Sports Analytics, this talk will delve into some of those details. If you haven’t yet grabbed a ticket to see me and many other speakers better than I, tickets are available here.
Lastly, plans are really coming into focus regarding my 2018 racing plans. Yes, I realize it’s a bit late, but we still have a third of the year left! I have a few options on the table and sincerely hope to be able to announce something soon. I may even put up a Twitter poll to help me decide which opportunity to select. As always, thanks for reading, and I hope to see you at a speaking event or a racing event soon!
Greetings from Cork, Ireland! I wanted to get a quick post out about my next 3-4 speaking opportunities before I take a little late summer/early fall break from speaking (for a very good reason). We’ll get to that at the end.
First of all, I’m here in Cork, Ireland to speak at SQL Saturday Ireland in a couple of days (June 9th, to be exact). I’m really excited about this opportunity, as it’s the second international SQL Saturday I’ve been able to do this year. I am incredibly grateful for these opportunities to speak to new audiences and will do my very best to not let down the attendees and organizers. Cork has been wonderful in the few hours I’ve been here already and I look forward to a few more hours of exploring Cork tomorrow before the speaker get-together ramps up in the evening. If you haven’t registered for #SQLSATCORK yet, you can do so here.
Following Saturday’s event here in Ireland, I’m thrilled to announce that I’ve been selected to two SQL Saturday events in July which are much closer to home than the roughly 4000 miles it is to my house from where I sit here in Cork. I’ll be speaking at SQL Saturday Louisville on July 21st and SQL Saturday Columbus on July 28th.
Louisville was the first SQL Saturday to ever select me and remain grateful to Chris, John, Mala and the team for that initial selection and the community path it’s put me from that point forward. Beyond my personal feelings for this event and the group behind it, rest assured that Louisville is always a fantastic event with a great speaker list top to bottom despite my repeated selections! If you haven’t registered for the event, click here. I’d also like to plug the pre-conference session from two ex-colleagues of mine (and current Microsoft employees), Brad Ball and Josh Luedeman. These guys are doing very cool, cutting-edge stuff in Azure to really make your data warehouse data come alive to data consumers. Their dovetailing of data visualizations, sentiment analysis, and modern DW techniques is worth a day of your time – register for it here.
This will be my first trip to Columbus for SQL Saturday and I’m excited about that because A) I lived in Westerville for a few years when I was a kid and B) I’m a frequent visitor to Columbus Crew matches with my son so it will be fun to present up there. I’ll also be getting together with my fellow FGE Professional Sports Analytics founder (George Bryant) to watch some football after the event at a Crew pub, so the whole day should be a blast from start to finish. I haven’t been able to speak too much about what George and I are doing with FGE, but if you’re interested in what we’re doing, click here. We’re a bit light on the details there for now, but rest assured there are many blog posts coming from the work he and I are doing. Good bit of our work is under layers of legally enforced silence – for now. That will soon change and I’m eager to share it with you when I can!
Next, I’ve submitted individual sessions to SQL Saturday Indianapolis and I’m eagerly awaiting that schedule to see if I’ve been selected. Even if I miss out on an individual session, I do know that I will be doing a pre-con on Friday, August 10 with my friend and co-worker Sean Werick. It’s titled “Modernize your Data Warehouse” and tickets are available here. It’s always fun to be in Indy even when I’m not at the Speedway so I hope I’ll see you there.
Finally, I’ve submitted to the Atlanta Azure DataFest, held August 16th and 17th at the Microsoft Technology Center in Alpharetta. I’m hoping I am selected for that event because I’ve submitted my Cognitive Services, Azure Logic Apps, sentiment analysis, and soccer/football talk (i.e. the Premier League Mood Table session). That’s received wonderful response where I’ve given it across the USA and the world but it doesn’t always fit neatly into some PASS events so I’m hoping it finds a home at Azure DataFest.
Following that, I won’t be at any SQL Saturdays for a couple months so I can be home on the weekends to see my son play with his U10 club soccer (to some readers)/football (to other readers) team representing Lexington FC. I’m incredibly proud of the level he is able to play the sport that he loves, and despite my woeful lack of talent in that area, I can’t wait to watch him take to the field this fall. Thanks for reading – hopefully more to come soon!
Greetings! I’m excited for some of the technical posts that I’m working on, but before I’m able to publish those I wanted to share the details of my speaking schedule for May. I’m incredibly fortunate to have these speaking opportunities, and I’m incredibly excited to share them with you and to share my presentations with the attendees at these events!
My epic May begins this weekend with SQL Saturday Jacksonville on May 5th. I’m looking forward to catching up with some friends in the area, but I’m also looking forward to my first presentation in Florida! I’ll be presenting my “How to Keep Your Database Servers Out of the News” session. I really enjoy this session because it lends itself to a lot of interactivity with the group as we talk through various challenges people have had and the questions those challenges bring to their mind. If you’re attending, I look forward to seeing you and hearing your questions. If you’re not attending, click here to register and I’ll see you there!
The following weekend, on May 12th, I’ll be presenting at SQL Saturday Finland in Helsinki. It is an understatement to say that I’m excited for this one. My wife has requested that I bring Kimi Raikkonen home with me, and while I’m pretty sure she’s going to be disappointed in my failure to do that, I’m thrilled that I’m meeting my goal by speaking there! I set a personal goal to do at least one international presentation in 2018 and I’m incredibly grateful to the organizers of SQL Saturday Finland for selecting my session on “New Features and New Speed in SQL Server 2016 (and 2017) Always On Availability Groups”. I last presented this session at SQL Saturday Cleveland in February and it went really well and seemed to help some folks with challenges they were having, so I’m excited to bring this one to an international audience. If you’d like to register, click here to do that.
Following my presentation in Finland, I’m hopping a quick 3-hour flight to England to present “Feelings Quantified – Ranking Football Clubs By Supporter Sentiment” to Tech Nottingham. I’m thrilled that I was able to work this out with the organizers and they’ve been absolutely wonderful to me as we’ve worked to get this setup. This will be the second time I present on the Azure Logic Apps and Azure SQL DB guts of the Men in Blazers Mood Table I blogged about here in December and the first time it will be to a crowd who calls it football instead of soccer. 🙂 When I arrive in London on 5/13 I’m taking a few hours out, before hopping the train to Nottingham, to catch Tottenham’s (my favorite English football club) final match of the season and final match at Wembley Stadium before moving to their new stadium in the fall, so it’s going to be a soccer-ful/football-ful couple of days! Come On You Spurs! If you’re interested in learning more about this event, information can be found here.
After that journey, I head back stateside for a couple days off in New York City before presenting my “Data To Impress Those That Sign The Checks – Azure Logic Apps, Social Media, and Sentiment Analysis” session at SQL Saturday New York City. This session is the American-ized version of my mood table presentation (less soccer emphasis and slightly more technical focus) so it will be interesting for me to present both versions of this talk a few days apart. Also, it is no exaggeration to say that attending SQL Saturday NYC in 2015 changed the course of my career, so I definitely encourage you to register. Click here to do that. The organizers do a great job with this event, it’s in a great city, and I’m very appreciative of being invited to speak at an event that’s been so significant in my professional growth. I hope to see you there!
Lastly, I wrap up my journey right where I’m sitting as I finish this blog: my home office. IDERA Software has been kind enough to invite me to present a Geek Sync on 5/23 with my “Where Should My Data Live (and Why)?”. This session is great for data professionals in an environment where they’re being encouraged to expand the organization’s data estate to the cloud. It offers several real-world examples of how cloud and on-premises deployments can work together and complement each other. We also go over some pros and cons of the cloud vs. on-premises and dispel some myths as well. I hope to “see” you there. Click here to register and hear my run my mouth for an hour on May 23rd!
I know I keep saying it, but I am grateful to the organizers of all of these events for allowing me to speak to their groups. I can’t wait to meet #sqlfamily from other parts of the world, see places I’ve never been, and hopefully share a little knowledge along the way. Thanks for reading and hope to see you at one of these events!
It’s been a busy month since I last blogged for T-SQL Tuesday #99, but I’m hopeful that my blogging will get a bit more regular once I get through this weekend – and an exciting weekend it will be!
I’ve been fortunate enough to be selected to give both a full-day pre-conference session and a regular session at this weekend’s SQL Saturday Cincinnati. The full-day pre-conference session is on Friday, 3/16/18, and it’s titled “Modernize Your Data Warehouse with Big Data” and I’m presenting it with my colleague Warren Sifre (t). I’m really looking forward to my initial effort at a full-day pre-con!
My regular session is a veteran of a few SQL Saturdays now and it always generates good discussion in the room so I’m hoping for a good turnout and good questions! It’s titled “How to Keep Your Database Servers Out of the News” and I’m looking forward to presenting it at this first edition of SQL Saturday Cincinnati on Saturday, 3/17/18.
I believe the event has reached capacity, but just in case some folks have cancelled, go ahead and register for it here. I hope to see you there!
I’m also hoping to be able to announce soon several speaking engagements in the May/June timeframe. I can’t do so yet, but I’m looking forward to sharing those with my readers, so watch this space if you’re interested in where in the world I’ll be later this spring!