In D & A Projects, building efficient SQL Queries is critical to achieving the Extraction and Load Batch cycles to complete faster and to meet the desired SLAs. The below observations are towards following the approaches to ensure writing SQL queries that meet the Best Practices to facilitate performance improvements. Tuning Approach Pre-Requisite Checks Before […]
Posts Tagged ‘SQL Server’
Generate Scripts for Data in the Tables of SQL SERVER
This wizard is helpful for generating scripts and publishing them. In order to run the wizard, right click on the database and navigate to Tasks -> Generate Scripts. The wizard will pop up and you can generate scripts either for all database objects or for a selected number of database objects. This could be used […]
“Database Platform Service” Error with MSDeploy and dbDACFx
MSDeploy (a.k.a. Web Deploy) is mainly known as a technology to deploy web applications, but it is much more than that. It is a platform that can be used to deploy many different application and application components. It accomplishes this by allowing custom providers to be written. MSDeploy ships with providers that cover a wide-range […]
Developing custom SSIS component – 9 lessons learned
One of the compelling features of Microsoft SQL Server Integration Services (SSIS) is its extensibility. Although SQL Server comes with a wide array of SSIS components (including different data sources, transformation tasks and logical flow control operations), sometimes there is a need to do something unique in your SSIS package, something that is not supported […]
Azure Site Recovery Integration with SQL Server AlwaysOn
Azure Site Recovery now provides native support for SQL Server AlwaysOn. SQL Server Availability Groups can be added to a recovery plan along with VMs. All the capabilities of your recovery plan—including sequencing, scripting, and manual actions—can be leveraged to orchestrate the failover of a multitier application using an SQL database configured with AlwaysOn replication. […]
Azure SQL – Row Level Security Now Available
Row-Level Security (RLS) for Azure SQL Database is now generally available. RLS simplifies the design and coding of security in your application. RLS enables you to implement restrictions on data row access. For example ensuring that workers can access only those data rows that are pertinent to their department, or restricting a customer’s data access […]
Northwestern Medicine Uses Epic to Deliver Value-Based Care
Recently, Kate Tuttle, my colleague and healthcare marketing guru, wrote a post over on Perficient’s Healthcare Industry Trends blog, describing the shift from a fee-for-service based model to a value-based care model and the subsequent need for a 360-degree patient view. Many healthcare organizations are facing challenges around transforming data into meaningful information – information […]
On-Premises BI Gets a Boost in SQL Server 2016
At their recent Ignite conference in Chicago, Microsoft unleashed a flood of new information about their products and services across a wide variety of functions. Business Intelligence was not left out, by any means, with announcements of exciting new cloud-based offerings such as Azure Data Warehouse and Azure Data Lake. But given all the focus […]
BUILD & IGNITE Know It. Prove It. Tech Challenge Tour
I recently blogged about my personal experiences with the first “Know it. Prove it.” challenge that ran through the month of February 2015. The “Know it. Prove it.” challenge is back! This time it’s bigger and better than ever. The new challenge is a companion to both the Build and Ignite Conferences with 11 amazing […]
Webinar: Big Data & Microsoft, Key to Your Digital Transformation
Companies undergoing digital transformation are creating organizational change through technologies and systems that enable them to work in ways that are in sync with the evolution of consumer demands and the state of today’s marketplace. In addition, more companies are relying on more and more data to help make business decisions. And when it comes […]
Hybrid Analytics in Healthcare with O365 & Power BI Webinar Recap
Last week, we had our Microsoft last business intelligence focused webinar of the year, “Hybrid Analytics in Healthcare: Leveraging Power BI and Office 365 to Make Smarter Business Decisions.” Heidi Rozmiarek, Assistant Director of IT Development for UnityPoint Health, spoke, along with our Microsoft BI team, on implementing an analytics platform in a hybrid environment. […]
Power BI Basics Inside Office 365 – A Video Series
Yesterday, we were fortunate to have a customer, Heidi Rozmiarek, Assistant Director of IT Development for UnityPoint Health, speak alongside our Microsoft BI team for the webinar, “Hybrid Analytics in Healthcare: Leveraging Power BI and Office 365 to Make Smarter Business Decisions.” It was an informative session that began by covering architectural components and functions, […]