(Melissa Coates) I’m a big fan of reusing Power BI datasets whenever possible to minimize redundant datasets floating around the organization. It’s less maintenance, less chance of calculation differences, and less data refreshes to schedule.
Tag: sql server
What’s new in SQL Server 2017 CTP 2.1 for Analysis Services
(Christian Wade) The public CTP 2.1 of SQL Server 2017 is available here! This public preview includes the following enhancements for Analysis Services tabular models.
How to import data for SSAS Tabular vNext
(Siddharth Mehta) The experience of importing data into SSAS Tabular has been quite similar to importing data into Excel. Apart from providing the details of the data source and credentials, the ability to model the data (especially graphically) has been very limited.
SQL SERVER – Service Pack Error – Index (Zero Based) Must be Greater Than or Equal to Zero and Less Than the Size of the Argument List
(Pinal Dave) Recently I came across an issue where I was not able to fix directly. My client reported below error in Skype, which is related to a service pack.
Installing SQL Server vNext on Ubuntu
(Manvendra Singh) Microsoft announced support for SQL Server on Linux. In a previous tip I explained the step by step method to install SQL Server vNext on Red Hat Linux 7.2. In this tip I will explain how to install SQL Server on an Ubuntu server 16.04 version.
Query Hash Values, Plan Guides and the Query Store
(Grant Fritchey) I was eating dinner with Hugo Kornelis and we started talking about query hash values. You know, like everyone does at dinner. As we talked about it, I suddenly thought about both Plan Guides and the Query Store. I wondered what happened to the query hash values in that case? Thus a
Simple Security Report
(Kenneth Fisher) Quite a while ago I created a couple of little security scripts to help me out with permissions research. Over time they grew into the procedures sp_dbpermissions and sp_srvpermissions.
Azure Load Balancers and SQL Server
(Joshua Feierman) Load balancing in Azure has more importance for the DBA, because it is essential for Windows Server Failover Clustering in Azure, whether it is for AlwaysOn Availaiblity Groups, Failover Clustered Instances, or any other highly-available solution. Azure load balancing works out the
SQL Server offline after applying service pack
(Luciano Moreira) In this post I´ll review two cases that you may bump into when applying service packs in SQL Server.
SQL Server 2017 makes Python a first-class citizen for analytics
(Jack Vaughan) Python is no longer a database outsider at Microsoft. The programming language is riding alongside R for analytics uses as SQL Server 2017 moves to its second preview release.