IamMikaBlog's profile picture. Hi, I’m Mika. For the past 17+ years I've been working as a consultant, solution architect, and project manager for business applications.

IamMika.blog

@IamMikaBlog

Hi, I’m Mika. For the past 17+ years I've been working as a consultant, solution architect, and project manager for business applications.

Make sure you check my recent blog post explaining what are Stored Procedures used For in SQL! Check it out here: iammika.blog/what-are-store… #SQL #SQLTutorial #DataAnalyticsTraining #LearnSQL #TechEducation


In my recent blog post, I’ll show you step by step how to create views in SQL Server Management Studio and share some best practices from my own experience. Check it out here: iammika.blog/how-to-create-… #SQL #SQLTutorial #dataanalyticstraining #LearnSQL #TechEducation


When I first started working with SQL Server, one of the things that confused me was performance. Why do some queries return results almost instantly, while others take forever? The answer, in many cases, comes down to indexes. Check it out here: iammika.blog/what-is-index-… #SQL


Yes, there’s more than one way to truncate a table in Fabric! Lakehouse, Warehouse, or Pipeline - I’ve explained them all in one place. ⚙️ Get the guide: 🔗 iammika.blog/how-to-truncat… #MicrosoftFabric #DataAnalytics #dataengineer #dataengineering


My last blog post will help you get your Excel/CSV data into Fabric in minutes. I am also explaining how to merge data from CSV file and existing table into a single Lakehouse table: iammika.blog/how-to-import-… #MicrosoftFabric #dataanalytics #dataengineer #dataengineering


When you try to connect PowerBI to Microsoft Fabric datawarehouse, you could get the following error: “Microsoft SQL: Integrated Security not supported”. Check out how to fix it: iammika.blog/integrated-sec… #MicrosoftFabric #dataanalytics #dataengineer #dataengineering


In this post, I’ll explain what are the data types in SQL Server, and show you how to create a table using different data types in one go. Check it out here: iammika.blog/data-types-in-… #SQL #SQLTutorial #dataanalyticstraining #LearnSQL #TechEducation


Here's something I see beginners get confused about: What’s the real difference between DELETE and TRUNCATE in SQL? I covered it in my latest post! 🔍 Dive in here: 👉 iammika.blog/what-is-delete… #SQL #sqltutorial #dataanalyticstraining #LearnSQL #TechEducation


How to Start Time Blocking and Get More Done Time blocking changed how I work. No more endless to-do lists—just focused, productive days. 📅 I wrote about how I started (and how you can too): ➡️ iammika.blog/how-to-start-t… #FocusedWork #focus #deepwork

iammika.blog

How to Start Time Blocking and Boost Productivity

Discover how to start time blocking, boost focus, and get more done each day with this simple yet powerful productivity method.


Ever wondered when to use UPDATE vs INSERT in SQL? I just published a post that breaks it down simply—with examples. 🧠 If you're working with databases, you'll want to read this: 👉 iammika.blog/sql-update-vs-… #SQL #sqltutorial #dataanalyticstraining #LearnSQL #TechEducation


United States Trends

Loading...

Something went wrong.


Something went wrong.