SQL Server 2025: The AI-ready enterprise database platform | Data Exposed
SQL Server 2025 is now in public preview, and it’s time to explore the exciting new features and enhancements that this latest release brings to the table. With SQL Server 2025, Microsoft aims to redefine the future of data management by incorporating ground-breaking features such as artificial intelligence (AI) capabilities, advanced developer tools, and seamless […]
Read More
Should You Still Learn SSIS in 2025?
-
Frank
- December 27, 2024
- Azure
- Azure Data Factory
- Business Intelligence
- Cloud Computing
- Cloud-Native Tools
- Data Analytics
- Data Engineering
- Data Integration
- data migration
- Data Orchestration
- data pipeline
- Data Transformation
- Data Workflows
- ETL
- Hybrid Cloud
- Legacy Technology
- Microsoft Ecosystem
- microsoft fabric
- on-premises infrastructure
- SQL Server
- SQL Server Integration Services
- SSIS
- T-SQL
- Technology Longevity
As the holiday season brings a mix of nostalgia and anticipation for the future, it’s a fitting time to talk about SQL Server Integration Services (SSIS) — a technology as classic as Christmas carols but often met with mixed reactions, much like fruitcake. Despite being around for nearly two decades, SSIS remains a cornerstone in […]
Read More
‘Tis the Season for SSIS: Why Data Integration Classics Are Far from Outdated
-
Frank
- December 20, 2024
- AI projects
- AWS
- Azure
- cloud adoption
- cloud vs on-premises ROI
- data acquisition
- Data Engineering
- data engineering fundamentals
- data platforms
- data residency
- data sovereignty
- Data Warehousing
- economic influences
- Google Cloud
- government contracts
- hybrid cloud models
- infrastructure as a service
- Legacy Systems
- legal considerations
- Microsoft Access
- old technology vs new technology
- on-premises infrastructure
- organizational networking analysis
- political considerations
- Red Hat data platform
- SCADA systems
- software maintenance
- SQL Server
- SQL Server Integration Services
- SSIS usage increase
- training costs
As the year draws to a close, it’s time to reflect not just on festive cheer but on something equally perennial—SQL Server Integration Services (SSIS). For two decades, SSIS has been the go-to tool for data integration and transformation. Yet, it continues to be a lightning rod in the tech community. Some hail its capabilities, […]
Read More
Introduction to the source control built-in with SQL database in Fabric | Data Exposed
In software engineering, source control has long been a cornerstone. It allows developers to track changes, collaborate efficiently, and manage multiple tasks simultaneously. However, when it comes to databases, the process can become a bit more complicated. This is where the integration of source control with SQL database and Fabric comes into play, providing a […]
Read More
Announcing SQL database in Microsoft Fabric public preview | Data Exposed
The recent announcement at Microsoft Ignite about SQL database now being available in Microsoft Fabric marks a significant leap in this evolutionary journey. This move is not merely an upgrade or a shift; it’s a transformation that speaks volumes about where the future of application development and AI integration is headed. This video is from […]
Read More
The Elastic Stretch of Hyperscale: A Dive into Azure’s Latest Offering
The recent general availability of Hyperscale Elastic Pools in Azure SQL Database marks a significant milestone in this journey, promising a new level of flexibility for developers and businesses alike. But what exactly is this new offering, and why should you consider it for your cloud-native database development? Let’s unpack the essence of Hyperscale and […]
Read More
How to monitor the performance of your on-prem & multi-cloud SQL Servers w/ Azure Arc | Data Exposed
Learn how to use Azure Arc to monitor key performance metrics for your SQL Servers located in your data center, at the edge, or even in other public clouds.
Read More
Uncovering the Fundamentals of SQL Server and Azure SQL DB Security | Data Exposed
In this video is from Microsoft Developer, learn about SQL Server and Azure SQL Database security fundamentals you won’t want to miss.
Read More
Overview of GitHub Actions deployments for Azure SQL | Data Exposed
GitHub Actions are a developer’s delight for deploying application code and database objects. GitHub sql-action provides a simpler way to execute scripts or publish SQL projects but we don’t need to sacrifice security for our deployments. In this episode we’ll review how your deployments can navigate SQL firewall rules and private networks so you can […]
Read More
Azure SQL August 2023 AMA
Get the latest August news and updates in the world of data and join us for an “Ask Me Anything” with Anna Hoffman and guest speakers.
Read More