• Data Platforms
    • Databricks
    • Microsoft Azure
    • Microsoft Fabric
    • Power BI
    • SQL Server
  • Data Engineering
    • Azure Databricks
    • Azure Data Factory
    • Azure Data Lake
    • Azure SQL DB
    • Azure Synapse Analytics
    • SQL Server Analysis Services
    • SQL Server Integration Services
    • SQL Server Reporting Services
  • Company
    • Microsoft Fabric Workshop
    • About
    • Blog
    • Careers
    • Industries
      • Finance
      • Healthcare
      • Manufacturing
      • Pharmaceutical
      • Retail
      • Public Sector
    • Our Team
    • Resources
      • Azure Resources
      • Case Studies
      • Power BI Demo
      • Power BI Resources
      • SSIS eBook
  • Contact Us
Comparing Azure SQL Database to SQL Data Warehouse

Comparing Azure SQL Database to SQL Data Warehouse

Jan 10, 2017 | Azure, Cloud Technology, Data Warehousing, SQL Server

By: Ken Adams   Have you wondered what the difference is between Azure SQL Database and Azure SQL Data Warehouse? In this post we’re going to highlight the key differences between the two Microsoft product offerings and point out what you need to know....
One of the Biggest Takeaways From PASS SQL Summit 2016

One of the Biggest Takeaways From PASS SQL Summit 2016

Dec 21, 2016 | Business Intelligence, Conferences, Microsoft, SQL Server

At the end of October, our team joined thousands of other data professionals to attend the 2016 PASS (Professional Association for SQL Server) Summit, the world’s largest conference for Business Intelligence and SQL Server professionals. Held at the Washington State...
Incorrect Indexing Can Slow Down Memory Optimized Tables

Incorrect Indexing Can Slow Down Memory Optimized Tables

Dec 21, 2016 | SQL Server, Technical Information

Buzz on the street lately is that a Memory Optimized Table (MOT) in SQL Server greatly enhances OLTP SELECT performance. People in the industry are saying this because an entire table can be loaded completely into SQL Server memory without the unfortunate occurrence...
3 Advantages a Great Data Warehouse/BI Solution Should Bring to Your Business

3 Advantages a Great Data Warehouse/BI Solution Should Bring to Your Business

Dec 21, 2016 | Business Intelligence, Data Warehousing, Featured

Are we getting the most out of our data warehouse? If you’ve ever asked yourself that question as an executive, IT manager, or business owner, you’re not alone. We know there are many Data Warehouse/Business Intelligence (DW/BI) solutions that have fallen...
Next Entries »

Recent Posts

  • Key2 Consulting Partners With Databricks To Help Companies Maximize Data and AI
  • How to Build Metadata-Driven Pipelines in Microsoft Fabric
  • Getting Started With Copilot in Microsoft Fabric

Categories

  • .NET
  • Amazon
  • Amazon MWS
  • Amazon QuickSight
  • App design
  • Application Development
  • Artificial Intelligence
  • Azure
  • Azure Cosmos DB
  • Azure Data Factory
  • Azure Databricks
  • Azure Synapse
  • Big Data
  • BIML
  • Business Intelligence
  • Careers
  • CCPA
  • Cloud Technology
  • Conferences
  • Consulting
  • COVID-19
  • Custom Development
  • Data Encryption
  • Data Governance
  • Data Management
  • Data Regulations
  • Data Security
  • Data Visualization
  • Data Warehousing
  • Databricks
  • Entrepreneurship
  • Fantasy Football
  • Featured
  • Featured
  • GDPR
  • GitHub
  • healthcare
  • Key2 Stories
  • Machine Learning
  • Microsoft
  • Microsoft Copilot
  • Microsoft Excel
  • Microsoft Fabric
  • Microsoft Power Automate
  • Microsoft Power BI
  • Microsoft PowerApps
  • Open Source
  • PowerShell
  • RevoScaleR
  • Salesforce
  • Self-Service BI
  • SharePoint
  • Snowflake
  • Software Development
  • SQL Server
  • SSIS
  • Tableau
  • Tales from Consulting
  • Tech Tips
  • Technical Information
  • Uncategorized
  • Web 3.0
  • Web Applications
  • Web design
  • Web Development
  • What's Happening at Key2
We use cookies to ensure that we give you the best experience on our website. If you continue to use this site, you consent to our use of cookies and the terms of our Privacy Policy.Got It!