Opinions, tips, and news orbiting Microsoft
Use SSIS to load data in chunks to Excel
This sample SSIS package has below steps:
1. Read row count of the data to load from SQL Server and save the row count in variable
2. Split the rows to n chunks in a For Loop Container, create an Excel sheet f… Continue reading Use SSIS to load data in chunks from SQLServer to Excel
As an Azure Advocate, one of the things I spend my time doing is learning the easiest ways for beginners to use Microsoft Azure. Today I want to share with you a few ways to utilize some tools that are built right into Azure.
In my last blog po… Continue reading Azure Cloud Shell Tips for SysAdmins: Part III – Using Azure CLI
Today, we are announcing the most comprehensive and compelling migration offer available in the industry to help customers simplify their cloud analytics journey. This collaboration between Microsoft and Informatica provides customers an accelerated path for their digital transformation.
The post Azure and Informatica team up to remove barriers for cloud analytics migration appeared first on Cloud Perspectives Blog.
Continue reading Azure and Informatica team up to remove barriers for cloud analytics migration
Take our survey to help us continue to improve copy vs. export related scenarios in Power BI.
The post Help improve Power BI – Copy vs. Export Survey appeared first on Cloud Perspectives Blog.
Continue reading Help improve Power BI – Copy vs. Export Survey
As we head into August, weve released two feature updates for Paginated Reports in Power BI, with several more on the way.
The post Paginated Reports August 2019 Feature Update – Report Builder Update, SaaS embedding support and what’s coming soon appeared first on Cloud Perspectives Blog.
We have now enabled early access to new capabilities included in the 2019 release wave 2, October update including end-user impacting features that will be enabled by default. Early access allows customers and partners to try and validate these new features in a non-production environment. To prepare for these changes with confidence, were making additional
The post Early access to 2019 release wave 2 capabilities is now available appeared first on Dynamics 365 Blog.
The post Early access to 2019 release wave 2 capabilities is now available appeared first on Cloud Perspectives Blog.
Continue reading Early access to 2019 release wave 2 capabilities is now available
Version 7.4 of the Microsoft JDBC Driver for SQL Server has been released. Version 7.4.0 brings several added features, changes, and fixed issues over the previous production release. AddedSupport in SQLServerBulkCopy to allow Pooled/XA Connection… Continue reading JDBC Driver 7.4 for SQL Server Released
An issue was reported in the recent 7.4.0 release which required a quick fix. So we’ve released 7.4.1 to correct the issue. 7.4.1 reverts a change in the driver that potentially breaks applications implementing the ISQLServerDataRecord. Fixed Issu… Continue reading Hotfix: JDBC Driver 7.4.1 for SQL Server Released