fbpx

SQL Server in Microsoft Fabric? Use CETaS to move data!

People have been asking "What about SQL Server?" with regards to Microsoft Fabric. Bob Ward joins us to show a way you can get your SQL data into Fabric with CETaS and the power of shortcuts in OneLake. And, then use that data in Power BI! CREATE EXTERNAL TABLE AS SELECT (CETAS) (Transact-SQL) https://learn.microsoft.com/sql/t-sql/statements/create-external-table-as-select-transact-sql?view=sql-server-ver16&tabs=powershell Microsoft [...]

SQL Server in Microsoft Fabric? Use CETaS to move data!2023-06-27T04:52:55-05:00

Are you using your licenses correct? See where Azure Hybrid Benefits can help!

If you are moving your on-premises SQL Servers to the cloud, and/or if you have a mix of Azure SQL, Managed Instance and on-prem, make sure you are licensing correctly with Azure Hybrid Benefits. Shashank shows us how! Azure Hybrid Benefit https://azure.microsoft.com/pricing/hybrid-benefit/ Azure Hybrid Benefit - Azure SQL Database & SQL Managed Instance https://learn.microsoft.com/azure/azure-sql/azure-hybrid-benefit?view=azuresql&tabs=azure-portal Azure [...]

Are you using your licenses correct? See where Azure Hybrid Benefits can help!2023-05-14T14:20:54-05:00

Power BI DirectQuery and SQL Databases: A Conversation with Bob Ward

Power BI DirectQuery can have performance implications. Bob Ward shares his knowledge to help make SQL Databases perform better! Automatic tuning: https://docs.microsoft.com/azure/sql-database/sql-database-automatic-tuning ColumnStore Indexes: https://docs.microsoft.com/azure/sql-database/sql-database-in-memory Forced parameterization: https://docs.microsoft.com/sql/relational-databases/performance/specify-query-parameterization-behavior-by-using-plan-guides?view=sql-server-ver15 Intelligent Query Processing: https://docs.microsoft.com/sql/relational-databases/performance/intelligent-query-processing?view=sql-server-ver15 PolyBase: https://docs.microsoft.com/sql/relational-databases/polybase/polybase-guide?view=sql-server-ver15

Power BI DirectQuery and SQL Databases: A Conversation with Bob Ward2020-04-30T08:57:53-05:00

Announcements for SQL Server along with some tips for Power BI

Not Folding; the Black Hole of Power Query Performance (@Rad_Reza) Calling Microsoft Flow From Power Query And Power BI (@technitrain) Analysis Services Tabular Is (Finally) NUMA-Aware! (@SQLbyoBI) What’s new in SQL Server 2016 SP1 for Reporting Services What's New in SQL Server vNext BONUS: Excel Workbook Connection to Local Power BI Desktop (@ExceleratorBI) Grouping and [...]

Announcements for SQL Server along with some tips for Power BI2016-11-17T14:26:32-05:00

4 Troubleshooting connectivity tips with the gateway

I have four tips for troubleshooting connectivity with the On-Premises Data Gateway on Power BI. These tips apply to any client application. Troubleshooting connectivity For this post, we will use an example of getting an error when trying to connect to a SQL Server named instance. In this case, we get an error when [...]

4 Troubleshooting connectivity tips with the gateway2016-09-21T06:59:50-05:00

Paginated vs. Mobile reports in Reporting Services

I look at the difference between paginated and mobile reports within Reporting Services 2016. Mobile reports are new with SQL Server Reporting Services 2016 and you may be confused as to what they are as compared to paginated reports. Paginated Reports Paginated reports are operational reports that allow for a more traditional report experience. Mobile [...]

Paginated vs. Mobile reports in Reporting Services2016-06-07T20:14:24-05:00

SQL Server and Power BI Updates – Roundup #47

SQL Server has GA'd!!! We also had a lot of updates for Power BI! Creating Current Day, Week, Month And Year Reports In Power BI Using Bidirectional Cross-Filtering And M (@technitrain) Power BI Desktop May Update Feature Summary Smarter Auto-Generated Insights with Complex Filters Power BI gateways – May Update SQL Server 2016 is generally [...]

SQL Server and Power BI Updates – Roundup #472016-06-07T20:12:31-05:00

PASS BA recap, predictions and R – Roundup #46

Donate: https://donate.rednoseday.org/ Red Nose Day: http://rednoseday.org/ Paul Turley gives a recap of the PASS BA conference from his perspective mentioning Power BI and Excel. Jen Underwood talks about moving to Predictive Analytics. We have some tips for Dashboard makeovers. Ginger Grant talks about using R within SQL Server 2016. Power BI and Excel–the Dynamic Duo [...]

PASS BA recap, predictions and R – Roundup #462016-06-07T20:08:28-05:00

Walkthrough: SQL Server DirectQuery with Power BI

I walk through using a DirectQuery connection with SQL Server and the Power BI service. I start with Power BI Desktop, show how to configure the enterprise gateway, and then show how it looks in the Power BI service.  

Walkthrough: SQL Server DirectQuery with Power BI2016-06-07T20:06:12-05:00
Go to Top