Hard choices

I was recently accepted to speak at a SQL Server-related event in Europe. As I relish the opportunity to speak I was very happy and started preparing in earnest for booking the trip and polishing my session. However, when I took a look at the schedule, I found the name of another speaker that I […]

What’s in my bag – 2018 edition

All the cool people are doing it (Brent Ozar, Daniel Hutmacher) so I felt compelled to do the same – a quick run-down of the bag (and the contents) that has been travelling with me to 11 countries so far this year. When going speaking in Europe, I never check a bag. There are several […]

Speaking at TechDays and MCT Summit

I’m on a train heading to Stockholm and Microsoft TechDays, where I’ll be delivering “Azure SQL Server for the on-prem DBA”. This session outlines what’s available in Azure, what is automatic, what is not quite automatic and what is idiosyncratic, as well as explores some of the hard questions one should ask whenever the topic […]

A most unexpected Monday

On Monday this week I was downtown for some business as the new MVP awards started hitting Twitter. As several of my good friends were awarded this round, I was very happy and excited for them. They’ve all worked long and hard for our wonderful community, and it felt absolutely amazing to see them get […]

Pre-Ignite episode 5

The fifth Pre-Ignite episode is a quick last-minute rundown of what we’re going to do and where we’ll be at! Come see us and come listen to us at the podcast studio! If you have any additions, questions or comments, tweet Alexander (@arcticdba) or Simon (@Bindertech)! Knee-deep in Tech on iTunes Kneep-deep in Tech on […]

Episode 48

The fortyeighth episode, a.k.a “the improved fork” is up! We talk about the VSTS outage, Power BI news, the new SQL AG latency tool, new Windows builds and of course – Ignite! We’ll be doing webinars in the not-so-distant future, and we’d love for you to tell us what you want the webcast to be […]

Talk tech to me

I was invited by the PASS Professional Development Virtual Chapter to deliver “Talk tech to me – improving your technical presentation skills” on the 13th of September. The recording just went live and can be seen here: https://www.youtube.com/watch?v=srBe5Q-2xPE&feature=youtu.be but I have to warn sensitive viewers that there are some very disturbingly graphical dancing in there. I […]

Pre-Ignite episode 4

The fourth pre-Ignite episode deals with what to do in Orlando – Universal Studios, Disney and more! If you have any additions, questions or comments, tweet Alexander (@arcticdba) or Simon (@Bindertech)! Knee-deep in Tech on iTunes Kneep-deep in Tech on Spotify Pre-Ignite episode 4

Pre-Ignite episode 3

The third pre-Ignite session deals with what to expect at the conference – communications, behaving, the expo floor and what to do at night! If you have any additions, questions or comments, tweet Alexander (@arcticdba) or Simon (@Bindertech)! Knee-deep in Tech on iTunes Kneep-deep in Tech on Spotify Pre-Ignite episode 3

Episode 47

The fortyseventh episode is up! We talk about the Azure outage, SQL Server Management Studio 17.9, the recent changes to the Windows servicing model and Alexander’s data discovery trip to a municipality! We’ll be doing webinars in the not-so-distant future, and we’d love for you to tell us what you want the webcast to be […]

Pre-Ignite episode 2

The second pre-ignite session deals with the schedule – how to build it, where to find the best information about sessions and tips on how to think about choosing sessions. If you have any additions, questions or comments, tweet Alexander (@arcticdba) or Simon (@Bindertech)! Knee-deep in Tech on iTunes Kneep-deep in Tech on Spotify Pre-Ignite […]

Episode 46

The fortysixth episode, a.k.a “Intune in time” is up! We talk Power BI dates, Swedish open data, extended support for SQL Server 2008R2 and Windows Server 2008R2, Simon’s UK tour and new goodies from Office 365! We’ll be doing webinars in the not-so-distant future, and we’d love for you to tell us what you want […]

Custom date formats in Power BI

Until the Power BI team gives us the ability to specify a custom date format on a column, one has to jump through a few hoops to get a custom date format to be recognized as a an actual date format. I finally decided to blog about it as it seems a common enough issue […]

Pre-Ignite episode 1

This is the first of several pre-Ignite episodes, and on this one we talk travel and packing. If you have any additions, questions or comments, tweet Alexander (@arcticdba) or Simon (@Bindertech)! Knee-deep in Tech on iTunes Kneep-deep in Tech on Spotify Pre-Ignite episode 1 Show notes: ESTA: https://esta.cbp.dhs.gov/esta/Noise cancelling headphones: https://thewirecutter.com/reviews/best-noise-cancelling-headphones/Uber: https://www.uber.com/airports/mco/Lyft: https://www.lyft.com/rider/cities/orlando-flNote that both […]

Episode 45

The fortyfifth episode is up, a.k.a “wheels on your biceps” where we touch on news from the summer, Power BI updates, failing to clean a Surface laptop and upcoming changes to Microsoft Learning. We also cover what’s happening this fall, and the things we’ll be doing up to and at Ignite! Oh, and one more […]

Tech rundown

I’ve been asked about the technical setup I’ve just recently put together to be able to do remote sessions, podcasts, videocasts and similar. Now, this is kind of a dangerous thing to ask me about, as I’m VERY much a techno freak, so you asked, you shall receive. In excruciating detail… This is a picture […]

SQLGrillen

I’m sitting at Schiphol airport in Amsterdam contemplating my midsummer weekend. I was accepted to speak at SQL Grillen, a free one-day (plus one day of paid pre-cons) event in the metropolis of Lingen, Germany. Never heard of Lingen? Well, neither had I, before this event. When William Durkin, the main organizer of the event, […]

Episode 44

The fortyfourth episode is up, a.k.a the “retrospective special” where we take a look back at the first half of 2018, what we’ve done, where we’ve been and what’s been happening in the world of tech. We managed to sneak in a quick discussion of Azure backups as well! We’ll be doing webinars in the […]

Episode 43

The fortythird episode is up! We’re talking Intelligent Cloud Copenhagen, ConfigMgr updates, Intune updates, Microsoft aquiring GitHub and using Power BI with Brent Ozar’s first responder kit. We’ll be doing webinars in the not-so-distant future, and we’d love for you to tell us what you want the webcast to be about! As always we gladly […]

Episode 42

The fortysecond episode is up! We’re talking huge improvements for Sharepoint and Onedrive, Azure Saturday in Munich and GDPR! We’ll be doing webinars in the not-so-distant future, and we’d love for you to tell us what you want the webcast to be about! As always we gladly accept tips and criticism, as well as ideas […]

Episode 41

The fortyfirst episode is up! We’re talking the first SQL Saturday Finland, Surface Hub 2 and the new ConfigMgr preview! We’ll be doing webinars in the not-so-distant future, and we’d love for you to tell us what you want the webcast to be about! As always we gladly accept tips and criticism, as well as […]

Episode 40

The fortieth episode, “a.k.a the Powerful episode” is up! This time we talk about Excel getting Power BI visuals, CosomosDB updates, the first day’s keynote from MS BUILD, Power BI May update, the reborn Kinect, DJI, intelligent edge and much more! We’ll be doing webinars in the not-so-distant future, and we’d love for you to […]

Going to unexpected places

A week ago I woke up in Tel Aviv, Israel, the day after I gave my presentation “Speak your hands – using body language for effective communication” at SQL Saturday in Israel. Despite feeling the onset of a sore throat, I contemplated how I had gotten here. I did not expect to find myself in […]

Episode 39

The thirtyninth episode, “a.k.a lost in Karlstad” is up! This time we talk about SQL Saturday Israel, the new Windows 1803 release, Global Azure Bootcamp in Linköping, Azure Data Warehouse gen 2 and ConfigMgr 1804! We’ll be doing webinars in the not-so-distant future, and we’d love for you to tell us what you want the […]

Episode 38

The thirtyeighth episode, a.k.a “christmas buck” is up! This time we talk the Power BI April update, Microsoft TechSummit in Stockholm, the Global Azure Bootcamp we’re hosting in Linköping, what’s new in Intune and finally ConfigMgr! We’ll be doing webinars in the not-so-distant future, and we’d love for you to tell us what you want […]

Episode 37

The thirtyseventh episode, a.k.a “we have your racoon” is up! This time we talk Microsoft Ignite, sharing Power BI content via Azure B2B, Azure Saturday Munich, Windows Server 2019 and what Simon thinks of his Android phone! We’ll be doing webinars in the not-so-distant future, and we’d love for you to tell us what you […]

Episode 36

The thirtysixth episode is up! This time we talk Alexander’s Spring Tour of ’18, Power BI March update, Simon’s Redmond Tour of ’18 and updates to ConfigMgr! We’ll be doing webinars in the not-so-distant future, and we’d love for you to tell us what you want the webcast to be about! As always we gladly […]

Spring tour ’18

I just came back from my latest trip last night and I’ve been thinking about how to summarize the latest events I’ve been to. It all began with the NIC conference in Oslo in February. There I presented two sessions (Azure SQL Server – the cloud awakens and boring is stable, stable is good – […]

Episode 35

The thirtyfifth episode is up! This time we talk Azure ATP, our upcoming trips, the new 70-703 exam, Microsoft Teams, Power BI Embedded and webinars! We’ll be doing webinars in the not-so-distant future, and we’d love for you to tell us what you want the webcast to be about! As always we gladly accept tips […]

Episode 34

The thirtyfourth episode is up! This time we talk the upcoming conferences, the new SQL Server Management / SQL Operations Studio releases, the new ConfigMgr preview, Surface Pro turns 5 and the possibility of renting Hololens. As always we gladly accept tips and criticism, as well as ideas for content for us to cover. Just […]

Episode 33

The thirtythird episode is up, a.k.a the “Bad SQL jokes” episode! We talk about features that are missing from Power BI, heap accolades on Alexander’s new Surface Laptop, talk about ATP being available for Windows 7/8.1 and mention T-SQL Tuesday #99. As always we gladly accept tips and criticism, as well as ideas for content […]

T-SQL Tuesday #99 – Dealer’s Choice

This T-SQL Tuesday is an interesting one, as the challenge is to talk about something you’re passionate about outside of the usual work grind. Well, it turns out I’m very passionate about Star Wars, and I’m very passionate charity. Funny thing is, there is a way to combine them. But first, let’s rewind a few […]

I’ve become a mentor

I stumbled across SpeakingMentors after seeing a Tweet from Alex Yates. It’s a completely free opportunity for new and budding speakers to get one-on-one mentoring with more experienced people in the industry, all with the goal that sharing is indeed caring. I can’t count the number of times I’ve met absolutely brilliant people that had […]

Epsiode 32

The thirtysecond episode is up, a.k.a the “stumped Alex” episode! We talk about the new Windows Insider build, the new service extension post from Microsoft (and what that means), the Power BI February update and a story of corruption, #SQLFamily and asking for help. Knee-deep in Tech on iTunes Episode 32

Episode 31

The thirtyfirst episode is up! This time we’re recording from the Nordic Infrastructure Conference in Oslo, Norway. We talk some security, Intune vs ConfigMgr and SQL Server! As always we gladly accept tips and criticism, as well as ideas for content for us to cover. Just tweet Alexander (@arcticdba) or Simon (@bindertech)! Knee-deep in Tech […]

Episode 30

The thirtieth episode is up, a.k.a the “presentation remoote” episode! We talk about what’s behind the scenes of Power BI desktop, SQL Saturday Vienna (which still was held on a Friday, by the way), new builds of InTune, Windows and Windows Server, the Nordic Infrastructure conference and some presentation technique tips thrown in for good […]

Basic settings for SQL Server 2012/2014/2016, part 5

Part 5: updating the basic settings for SQL Server 2016/2017 It’s been quite a while since I penned my best practices posts for SQL Server 2012/2014 and I’ve been saying for ages that I should update them for SQL Server 2016. Well, it would seem that hell finally froze over as here we are! Let’s […]

Episode 29

The twentyninth (and first episode of 2018!) episode is up, a.k.a the “on the ball” episode! This time we talk shenanigans with PowerBI and ODBC connections, WANem for WAN emulation, Meltdown and Spectre, yet another insider build and what’s in store for 2018. We’ve switched over to Pippa.io for file hosting. Expect some small technical […]

Episode 28

The twentyeight (and last episode for 2017) episode is up, a.k.a the “deepdive in the fish tank” epsiode! This time we talk some Power BI, setting learning goals (and the T-SQL Tuesday is on the SECOND Tuesday of the month, not the first as I incorrectly said) and AI in Office 365! We’ll be back […]

Special episode #4

In the fourth special episode I’m talking about the database offerings in Azure, and Simon is asking intelligent questions. We are now on iTunes! Much easier to subscribe! As always we gladly accept tips and criticism, as well as ideas for content for us to cover. Just tweet me (@arcticdba) or Simon (@bindertech)

T-SQL Tuesday #97 – Setting learning goals for 2018

This month’s T-SQL Tuesday is hosted by Mala Mahadevan, and she poses a very interesting question with learning goals for 2018. The T-SQL Tuesday founder Adam Machanic posted on Twitter that a learning plan is the way to go, to which I responded that such a list (I misread “plan” to “list”) will probably be […]

Episode 27

The twentyseventh episode is up, a.k.a the “New discoveries” epsiode! This time we talk Power BI security changes, Always Connected Windows on ARM, even more speaking engagements and (yet) another InTune preview! We are now on iTunes! Much easier to subscribe As always we gladly accept tips and criticism, as well as ideas for content […]

Episode 26

The twentysixth episode is up! This time we talk Power BI guest access, the changing landscape of training, running vmWare on Azure(!), Windows Server servicing and SQL Operations Studio. We are now on iTunes! Much easier to subscribe 🙂 As always we gladly accept tips and criticism, as well as ideas for content for us to […]

Special episode #3

The third special episode was recorded at PASS Summit in Seattle and is comprised of two interviews. The first is Adam Saxton and Patrick LeBlanc of Guy in a Cube, and the second is with Cloud and Datacenter MVP Rob Sewell! We are now on iTunes! Much easier to subscribe 🙂 As always we gladly accept […]

T-SQL Tuesday #96: Folks Who Have Made A Difference

  This T-SQL Tuesday was an interesting one, and I’ve been spending quite a few hours thinking about how to formulate my thoughts. Unfortunately the end of said Tuesday is nearing with unreasonable speed, so I’ll have to be brief. This month’s challenge comes from Ewald Cress and is to recognize those who have made a meaningful contribution […]

Episode 25

The twentyfifth episode is up! This one will have to be called the “PASS recap” as we for once didn’t come up with a quirky name! We talk PASS Summit, ATP for Windows Defender, new stuff in Intune and a new Windows insider build! We are now on iTunes! Much easier to subscribe 🙂 As always […]

Special episode #2

This is the second special episode, and here Simon talks intelligently about Windows as a Service, and I ask not quite as intelligent questions. We are now on iTunes! Much easier to subscribe 🙂 As always we gladly accept tips and criticism, as well as ideas for content for us to cover. Just tweet me (@arcticdba) […]

Episode 24

The twentyfourth episode is up, a.k.a the “Jimmy’s undies”-episode, recorded on the 26th of October at TechDays Sweden in Stockholm. We sit down with the amazing MVPs Jessica and Jimmy Engström of Coding After Work fame and talk about development, UI/UX, home automation and the importance of fighting for the user! We are now on iTunes! […]

Episode 23

The twentythird episode is up, a.k.a the “who stole my GUI”-episode! We talk about Ignite, my recent trip to Japan, new hardware and Azure Stack! We are now on iTunes! Much easier to subscribe 🙂 As always we gladly accept tips and criticism, as well as ideas for content for us to cover. Just tweet me […]

Episode 22.5

Episode 22.5 is up, this one surprisingly without a nickname! With Simon at Ignite and a ton of new toys coming out of said conference, I felt I had to do a short episode just to talk about a few of them.   As always we gladly accept tips and criticism, as well as ideas […]

Episode 22

The twentysecond episode is up, a.k.a “the Residential Finn”-episode! We talk about Ignite expectations with our good friend Toni (@MrBlackSwe), the hidden costs of self-service BI and the need for good maintenance on Oracle systems, regardless of their age. We are now on iTunes! Much easier to subscribe 🙂 As always we gladly accept tips and […]

Episode 21

The twenty-first episode is up, a.k.a the “wireless rain” episode! We talk about the Apple launch event, Microsoft Future Decoded, myAnalytics, lots of Power BI updates, conditions in ARM templates, Windows 10 Fall Creator’s Update and what we are expecting from Ignite this year. We are now on iTunes! Much easier to subscribe 🙂 As […]

Episode 20

The twentieth episode is up, a.k.a the “hammer and sauce” episode! We talk about he death of the SCCM model, a new Data Management Gateway release, a new Data Migration Assistant release, that Airwatch now can do Chromebook management, expectations of Windows Server 1709 at Ignite, the new SSMS 17.2 release and data masking shenanigans. […]

Episode 19

The nineteenth episode is up, a.k.a the “inside ourselves” episode! We talk about YET another configmgr release, the Surface range reliability, security in Azure, the future of this podcast and our upcoming engagements. As always we gladly accept tips and criticism, as well as ideas for content for us to cover. Just tweet me (@arcticdba) […]

Another kind of contention in TEMPDB

I’ve been helping troubleshoot a SQL Server 2014 that kind of tips over every hour when a job is run on one of the application servers. All eight cores of the server go through the roof together with the counter for batch requests/sec – and then everything grinds to a halt. This behavior continues for […]

Episode 18

The eighteenth episode is up, a.k.a “the team song” episode! We talk about YET another configmgr preview, do a recap of the first six months of this podcast, the upcoming conferences in the fall and our hopes for future releases. As always we gladly accept tips and criticism, as well as ideas for content for […]

Episode 17

The seventeenth episode is up, a.k.a the “iphone body” episode. We talk Windows Server as a service, new Power BI APIs and some hardware. As always we gladly accept tips and criticism, as well as ideas for content for us to cover. Just tweet me (@arcticdba) or Simon (@bindertech)!

Episode 16

The sixteenth episode is up, a.k.a “sustainability of clouds” episode is up! We talk about yet another configmgr preview, the upcoming Data Insights Summit in Seattle, Power BI, Report Server and licensing costs, the modern way of work and sustainability. As always we gladly accept tips and criticism, as well as ideas for content for […]

Episode 15

The fifteenth episode is up, a.k.a “the super-great” episode is up! We talk about the upcoming Power BI changes, new Microsoft hardware, licensing considerations with SSIS in Azure and testing patches or not. As always we gladly accept tips and criticism, as well as ideas for content for us to cover. Just tweet me (@arcticdba) […]

Episode 14

The fourteenth episode is up, a.k.a “Knee-deep in trains” episode is up! We talk about developers and DBAs, vmWare, public speaking and conference abstracts. As always we gladly accept tips and criticism, as well as ideas for content for us to cover. Just tweet me (@arcticdba) or Simon (@bindertech)!

Epsiode 13.5

Episode thirteen and a half is up, a.k.a the “failed creator” episode. This episode is a 30 minute discussion between me and Simon covering the ///Build day 2 keynote. As always we gladly accept tips and criticism, as well as ideas for content for us to cover. Just tweet me (@arcticdba) or Simon (@bindertech)!

Episode 13

The thirtheenth episode is up, a.k.a “Schrödinger’s Data Scientist” episode. This episode covers a rant about trains in Sweden, a gazillion interesting stuff from ///Build so far and expectations for today’s keynote. As always we gladly accept tips and criticism, as well as ideas for content for us to cover. Just tweet me (@arcticdba) or […]

Episode 12

The twelth episode us up, a.k.a the “Stormtrooper outfot” episode. This episode covers the Surface laptop, Windows 10S, the new PowerBI Premium offerings and the new Microsoft education offerings. As always we gladly accept tips and criticism, as well as ideas for content for us to cover. Just tweet me (@arcticdba) or Simon (@bindertech)!

Episode 11

The eleventh episode is up, a.k.a the “department of numbers” episode. This episode covers news in Power BI, crappy drivers, the end(?) of Windows Phone, a discussion about the upcoming Microsoft Build conference, the manageability of Apple devices in an enterprise environment and the Microsoft fiscal report. As always we gladly accept tips and criticism, […]

Episode 10

The tenth episode is up, a.k.a the “We is. Are.” episode. We spend a half-hour talking about Windows 10 Creator’s update (again), using Power BI to visualize the vast amounts of data that each of our clients’ posess, the new Config Manager technical preview, Windows telemetry, Windows Insider for Business as well as manage to […]

Azure database maintenance using Azure automation

One of the things often overlooked with Azure SQL databases is the fact that they need love in exactly the same way as their on-premises brethren. Sure, Azure will keep an eye out for the most blatant issues, but the old adage “a penny of prevention is worth a pound of cure” still holds water. […]

Episode 9

The ninth episode up, a.k.a the “cloudbreaker” episode. We talk about Windows 10 creator’s update, gothchas with teaching Azure courses, DTUs, XenApp Essentials, Surface Studio, hurtful database experiences and us presenting at the Code Meetup conference in Stockholm. As always we gladly accept tips and criticism, as well as ideas for content for us to […]

Episode 8

The eigth episode is up, a.k.a the “public speaking special” episode. We talk about our journey to speaking and presenting, cover some excellent training tips and of course say a few things about our ambivalent relationship to the Logitech Spotlight. As always we gladly accept tips and criticism, as well as ideas for content for […]

Episode 7

The seventh episode is up, a.k.a the “part of the piece” episode. We talk about Citrix, Data Lake, the duality of BI skills, Teams going GA, Windows 10 creator’s update and new releases for PowerBI. As always we gladly accept tips and criticism, as well as ideas for content for us to cover. Just tweet […]

Episode 6

The sixth episode is up, a.k.a the “cloudclub” episode. We decided to drop in on our colleagues in Jönköping and discuss Azure Stack TP3, surprises with Azure Classic to Azure RM conversions, the relative sexappeal of Windows Phone users and Office 365 licensing per group improvements. As always we gladly accept tips and criticism, as […]

Logitech Spotlight – initial thoughts

As you know by now, I do a fair bit of presenting and teaching. One of my primary tools is Powerpoint, and that necessitates a presentation clicker. I’ve been using a Logitech R400 for quite some time, and it does its job admirably. A few weeks ago, a colleague of mine showed me the new […]

Episode 5

The fifth episode is up, a.k.a the “kidlagged” episode. Simon is back, and we discuss Windows as a service, soft skills, SQL Server on Linux, Always On Availibility Groups and our incoming Logitech Spotlights. Last week we were both busy – Simon having a kid and me teaching a course in Stockholm. As always we […]

“File is read only” when trying to change TCP settings in SQL Server Configuration Manager

Today I hit upon this bug that’s apparently been around for ages. In short, sometimes SQL Server Configuration Manager works as expected when it comes to enabling and disabling specific IP addresses for the instance to listen on, and sometimes you are greeted with a very irritating message telling you that “the specified file is […]

Episode 4

The fourth episode is up, a.k.a the “malicious cleaning lady” episode! Simon’s busy having a kid, but I managed to corner Toni Holopainen (@MrBlackSwe) instead! Toni’s spent the last decade or so working wonders with the Windows platform, and has amassed more knowledge about infrastructure in general than you can easily shake a stick at. […]

Episode 3

The third episode is up! It’s informally known as the “kick off right from the bat” episode, due to my brain doing a bit of a sommersault. 30 minutes of discussions of Azure, SQL Server, Windows 10, Citrix and MCTs. As always we gladly accept tips and criticism, as well as ideas for content for […]

Episode 2

We’ve actually managed to produce yet another episode of our podcast, and while we were at it, we came up with a name. The podcast is now aptly named “knee-deep in tech” and will (for the forseeable future) be a work in progress. As always we gladly accept tips and criticism, as well as ideas […]

Podcast – what could possibly go wrong?

Me and my colleague Simon (@bindertech) has decided to start a podcast. It’s brand spanking new and while we don’t have a clue about how to do a podcast we do have a lot of ideas for content. Our first episode focuses on database backup compression and application testing (a bit of an unholy combo, […]

Combining tables in Power BI and finding two(?) bugs

A student of mine had a question about combining data from multiple Excel sheets and doing calculations on the data. I realized I didn’t have a clear-cut answer so I decided to do some digging. The scenario looked like this: I created three excel files, each with a column for name and one for value. […]

The last post of the year

On January the 7th I celebrate my 10th anniversary at Atea. I came to be a consultant after 6 years working internal IT at the local university, and let’s just say consulting was a bit of a… change in pace. At the university I was responsible for everything that was spelled Oracle or SQL Server […]

T-SQL Tuesday – body language

This is my contribution to this month’s T-SQL Tuesday, this time hosted by Andy Yun. I was sitting calmly in a session at PASS Summit 2016 listening with only one ear. I was using only one ear as I was busy contemplating the many ways the speaker’s presentation skills could be improved. Teaching and presentation skills […]

PASS Summit and the #SQLFamily

PASS Summit 2016 was a week ago, and I’ve tried (unsuccessfully) to put my thoughts into words. I’ve read many excellent blog posts about the conference and I wholly agree with them all, but I wanted to articulate my feelings in a blog post of my own. PASS Summit 2016 was my third Summit on […]

SQLHangout #38

We just concluded SQLHangouts #38 where Cathrine and I talked about career transitions from hardcore DBA stuff to slightly fluffier PowerBI / cloud stuff. I want to thank Cathrine for having me. It’s on youtube (and there it will stay, probably for all eternity) so head on over to take a look. I might have […]

SQLHangout #38 and Microsoft TechDays

My life is … hectic, to say the least. I just finished a talk at Atea IT-arena in Karlstad last week, as well as a 60-minute recap of Micrsoft Ignite in Atlanta that I held yesterday for 40 people at AddSkills in Linköping. The crowd was very attentive and lots of good questions were raised. […]

Reducing SSIS anxiety

Story time again. This tuesday I was to create a set of import packages in SQL Server Integration Services (SSIS) to automate data loading from a couple of my customers’ storage systems. Said data comes in the shape of several text files – some delimited, some fixed length, all of varying size and shape. Anyone […]

Thoughts on communities

I’ve just stepped on the train from Gothenburg and SQL Saturday #536, where I had the honor of giving a talk about consolidation with SQL Server 2016. This SQL Saturday was organized by Mikael Wedham, a very friendly and exceedingly knowledgeable Swede. He had managed quite an amazing lineup with speakers this year: John Q. […]

SQL Saturday #536

I had a fairly short vacation this year in anticipation for a trip to Japan next year, but the time running up to said vacation was … hectic to say the least. Some time during this hectic workload I had the brilliant idea to send in a few abstracts for SQL Saturdays around the world. […]

Presentation skills – do you have them?

A large part of my work as a consultant is giving presentations and teaching stuff. I’ve been doing presenting and teaching since 2000 and I feel fairly good at it. When I started out I was young and inexperienced, something I compensated for with a huge ego instead. Needless to say, I had … mixed […]

Manhandling GoldenGate, part 3

Here are the different configuration files and such I used for the setup described in parts 1 and 2. Please note that I’ve removed the several hundred schemas for clarity, and I have exchanged the customer-specific schema names for the nonexistent SCOTT and TIGER schema names. mgr parameter file on primary PORT 7809 AUTOSTART EXTRACT […]

Manhandling GoldenGate, part 2

Let’s take a look at something that is not quite as well documented for anything else than a tiny, safe lab environment – instantiation of the secondary database. There is a document from Oracle covering this (1276058.1) but it has not bee updated since 2013 and is not very detailed. Instantiating an Oracle secondary can […]

Manhandling GoldenGate, part 1

I’ve been hard at work setting up a GoldenGate replication system between two sites to serve as a HA solution for a customer that is … unwilling to pay the rather high licensing fees to use Oracle Enterprise Edition and Data Guard. Instead, we’ve opted to go with Standard Edition One 11g on two nodes […]

Blog developments

Things are slowly getting back to normal after the sudden passing a few weeks ago. Sure, it was “only” a cat, but as me and my wife don’t have any kids (and have no intention of getting any either), the cats are our kids. Anyhow, I’ve updated the blog a bit to make it more […]

A eulogy in a technical blog

I’ve been absent from the blog for a while. This has several reasons, ranging from work, to lots of things to do outside work and what I’d like to take a moment to talk about today – the death of one of my cats. I got Salsa, as she was called, back in May of […]

Three amigos screw up a cluster

Three amigos joined me for a cluster installation the other day. Neither of them was very friendly, so I decided to call them all out in one place in order for others to steer clear. The opinionated folder Using mount point folders is a great idea for neatness and to avoid having a gazillion drive letters […]

GoldenGate surprises

I’ve been way busier than I exepected, and I’ve got somewhat of a bad conscience for not having been able to update the blog. But here goes. I’ve been tasked with setting up an Oracle GoldenGate solution for a customer. The environment is fairly straight forward with two servers running Windows 2012R2 and Oracle Standard […]

Finding the culprit

I had a case the other day where the customer called and told me that he had a bit of a performance problem. Well, I’ve heard that a few times over the years, and asked him to elaborate. He sent me a screenshot of SolarWinds Database Performance Analyzer and, well, it kind of points the […]

PASS Summit 2015 – a quick reflection

PASS Summit 2015 is winding down and I am strolling through increasingly deserted hallways. This was my second PASS Summit, and I already know it will not be my last. I’ve been to Oracle OpenWorld in San Francisco six times and compared to that conference this one is downright tiny. But the thing with the […]

Azure Automation and index maintenance gotchas

I decided to write up a blog post about index maintenance in SQL Azure databases (yes, I’m gravitating towards Azure just like everyone else these days). I had everything planned, what research to do, the case I was going to use, the whole nine yards. It would have been epic, had it not been for […]

Back in the saddle – index time

Well, I’m back in the saddle. Four weeks of vacation, of which three resembled some kind of monsoon. The last was great, and ofcourse the weather became great as soon as I returned to work. I decided to get me a new script to show me unused indexes, and started looking at Stack Overflow to […]

Vacation! And a few gotchas…

The blog has been slow lately due to the impending vacation. I’ll toss in a few things I stumbled on the last week though: When dealing with a cluster, chances are that some of the disks just won’t be returned to the fold when deleted from available storage. For some reason, the cluster sometimes keeps […]

Differences between Oracle and SQL Server transaction log files

When moving between Oracle and SQL Server, one of the first gotchas is how the transaction log is handled differently between the two engines. In Oracle, the transaction log is a pure transaction log in that it contains only the data and not the rollback information. SQL Server combines the transaction log and the rollback […]