
OK
About Sven Aelterman
Since 2015, he's served as Cloud Software Architect for Sorrell Solutions, L.L.C., a non-profit business services firm offering Sorrell GEEKS the opportunity to participate in real-world projects.
In addition, he is the founder and principal consultant at Adduxis, where he assists customers in areas of SQL Server, high availability/disaster recovery and .NET software development. Sven focuses on application design and architecture and secure coding practices.
In 2012, he co-authored "The Art of SQL Server FILESTREAM," published by Red Gate Books. In 2018, a second book, "SQL Server 2017 Administration Inside OUT," was published by Microsoft Press. A third book, "SQL Server 2019 Administration Inside OUT," is in development for publication in late 2019 by Microsoft Press.
He received his MBA from Troy University and his bachelor's degree from the Hogeschool Gent (University College Ghent) in Belgium, his native country.
Sven is married to Ebony and they have a son, Edward, and a daughter, Sofia. They live in Troy, Alabama.
Customers Also Bought Items By
Are you an author?
Author Updates
-
Blog postI’ve recently been engaged on several customer projects where file uploads to an Azure Storage account have to be scanned for malicious content. Usually, this functionality is needed to ingest data safely into an Azure-hosted research environment. In this post, I am describing a solution I designed to scan the uploads for malware using the … Continue reading On-Demand Malware Scanning for Azure Storage Blobs with VirusTotal6 days ago Read more
-
Blog postUpdate 2021-01-13 9:15 AM CST: Added additional resources at the end of the article
Azure Sentinel is Microsoft’s cloud-native SIEM/SOAR. While being cloud-native means that there is little to no configuration required to ingest a variety of log sources, such as Azure AD, Azure Activity Logs, and AWS logs, customers also have a need to ingest logs from more traditional sources, such as firewalls and Linux virtual machines. For this purpose, Sentinel supports ingesting syslog and Commo2 months ago Read more -
Blog postI thought about making the title of this blog post “Creating a uni-directional Azure Virtual Network Peering,” but it would have been a bit too click-baity. Still, conceptually, what I am describing in this post is along those lines.
Virtual Network Peering and the VirtualNetwork Service Tag When two Virtual Networks (VNets) are peered, the definition of the VirtualNetwork service tag changes to include the IP addresses of the peered network. When subnets have a default Network Securi2 months ago Read more -
Blog postTL;DR: No. I’ve been working with numerous customers on Windows Virtual Desktop (WVD) deployments since I started my position at Microsoft. During the process of manually* creating an image, it’s common to take snapshots. I especially recommend taking snapshots before sysprepping the image. Once you sysprep an Azure VM, the VM itself is unusable; it … Continue reading Does Deleting an Azure Managed Disk Also Delete Snapshots?2 months ago Read more
-
Blog postNote: About seven months ago, I left public higher education and took a role at Microsoft. In my new role as Cloud Solution Architect, I work with educational institutions and related entities to ensure successful Azure deployments. In this context, successful doesn’t just mean from a technical perspective, but also from a value perspective.
My peers and I work with customers one-on-one, but we also provide “shared” resources. I thought it’d be helpful to share what these resources ar4 months ago Read more -
Blog postEnd-to-end (E2E) encrypted communication is valuable and necessary. Many tools provide this. Recently, I’ve started using Keybase, not only because of its ability to provide E2E encrypted messaging but also because of its additional feature set. One key feature is the ability to link your identity on Keybase to your identity on other sites, including … Continue reading Importing a key or key pair in Keybase on Windows1 year ago Read more
-
Blog postIn two days, October 31, 2019 at noon US Central time / 17:00 UTC, I will be presenting my talk “What’s New in Azure SQL Database” for the PASS Cloud Virtual Group. If you’d like to attend, you can register at https://cloud.pass.org/MeetingDetails.aspx?EventID=14249. You’ll need your PASS username and password.
If you’re not currently using Azure SQL Database, but you want to stay up-to-date, this is the session for you. You will learn about and see the changes to Azure SQL Database t1 year ago Read more -
Blog postToday, seemingly out of the blue, I was unable to connect to my MSSQLLocalDB instance of SQL Server Local DB. The error message I received indicated something went wrong during the login, purportedly with a trigger. Here’s how I did some troubleshooting, research, and finally figured out a non-destructive way to get back in my … Continue reading Unable to Log In to SQL Server Local DB Due to Missing MDF File1 year ago Read more
-
Blog postI am writing this quick blog post because of a neat feature in Azure Data Studio that is currently undocumented in the official documentation: split terminal.
Azure Data Studio, like VS Code which it’s based on, supports an integrated terminal. You have a choice between PowerShell, cmd, or git bash. You can have multiple terminal windows active at the same time, even different types of terminals. A newer addition is that a single terminal pane can be split, enabling two or more termin2 years ago Read more -
Blog postThis Saturday, the Atlanta SQL user group is organizing its annual SQL Saturday. After a hiatus last year, I will be presenting a brand new talk, titled The New Tool in Your Kit: Azure Data Studio. Below is the abstract for the talk.
Azure Data Studio is a newer tool in the database developer and DBA’s toolkit. It’s a cross-platform and extensible application for connecting to on-premises and cloud data. Does it replace SSMS? How is it different? Can it really check if my Diet Coke ne2 years ago Read more
There's a problem loading this menu right now.
Conquer SQL Server 2017 administration—from the inside out
Dive into SQL Server 2017 administration—and really put your SQL Server DBA expertise to work. This supremely organized reference packs hundreds of timesaving solutions, tips, and workarounds—all you need to plan, implement, manage, and secure SQL Server 2017 in any production environment: on-premises, cloud, or hybrid. Four SQL Server experts offer a complete tour of DBA capabilities available in SQL Server 2017 Database Engine, SQL Server Data Tools, SQL Server Management Studio, and via PowerShell. Discover how experts tackle today’s essential tasks—and challenge yourself to new levels of mastery.
• Install, customize, and use SQL Server 2017’s key administration and development tools
• Manage memory, storage, clustering, virtualization, and other components
• Architect and implement database infrastructure, including IaaS, Azure SQL, and hybrid cloud configurations
• Provision SQL Server and Azure SQL databases
• Secure SQL Server via encryption, row-level security, and data masking
• Safeguard Azure SQL databases using platform threat protection, firewalling, and auditing
• Establish SQL Server IaaS network security groups and user-defined routes
• Administer SQL Server user security and permissions
• Efficiently design tables using keys, data types, columns, partitioning, and views
• Utilize BLOBs and external, temporal, and memory-optimized tables
• Master powerful optimization techniques involving concurrency, indexing, parallelism, and execution plans
• Plan, deploy, and perform disaster recovery in traditional, cloud, and hybrid environments
For Experienced SQL Server Administrators and Other Database Professionals
• Your role: Intermediate-to-advanced level SQL Server database administrator, architect, developer, or performance tuning expert
• Prerequisites: Basic understanding of database administration procedures
Conquer SQL Server 2019 administration–from the inside out
Dive into SQL Server 2019 administration–and really put your SQL Server DBA expertise to work. This supremely organized reference packs hundreds of timesaving solutions, tips, and workarounds–all you need to plan, implement, manage, and secure SQL Server 2019 in any production environment: on-premises, cloud, or hybrid. Six experts thoroughly tour DBA capabilities available in SQL Server 2019 Database Engine, SQL Server Data Tools, SQL Server Management Studio, PowerShell, and Azure Portal. You’ll find extensive new coverage
of Azure SQL, big data clusters, PolyBase, data protection, automation, and more. Discover how experts tackle today’s essential tasks–and challenge yourself to new levels of mastery.
- Explore SQL Server 2019’s toolset, including the improved SQL Server Management Studio, Azure Data Studio, and Configuration Manager
- Design, implement, manage, and govern on-premises, hybrid, or Azure database infrastructures
- Install and configure SQL Server on Windows and Linux
- Master modern maintenance and monitoring with extended events, Resource Governor, and the SQL Assessment API
- Automate tasks with maintenance plans, PowerShell, Policy-Based Management, and more
- Plan and manage data recovery, including hybrid backup/restore, Azure SQL Database recovery, and geo-replication
- Use availability groups for high availability and disaster recovery
- Protect data with Transparent Data Encryption, Always Encrypted, new Certificate Management capabilities, and other advances
- Optimize databases with SQL Server 2019’s advanced performance and indexing features
- Provision and operate Azure SQL Database and its managed instances
- Move SQL Server workloads to Azure: planning, testing, migration, and post-migration
This book will help you get started with FILESTREAM quickly, and then help you master all essential aspects of programming and administering FILESTREAM-enabled databases.