(Jason Thomas) Recently, I got asked by one of my readers if there is an easier way to make similar sized KPI boxes or charts in Power BI, other than manually resizing each individual visualization. As you know, making similar sized KPI boxes and / or charts are a design technique to make your repor
Tag: sql server
Reading Text Files With PowerShell For Configurations Part I
(Tim Smith) Using text files for configurations can be especially useful in some environments, especially to avoid re-use or long arrays with many elements in them. Can we use PowerShell with a configuration text file, where we could extract the contents of the file and then use the contents line by
Creating Dashboards for Mobile Devices with Datazen – Part 3
(Arshad Ali) With the recent acquisition of Datazen by Microsoft, if you have SQL Server 2008 Enterprise Edition or later with Software Assurance, you can leverage (download and use) Datazen to create visually appealing dashboards for mobile devices across all the major platforms at no additional co
Power BI Tip: Making similar sized KPI Boxes / Charts
(Jason Thomas) Recently, I got asked by one of my readers if there is an easier way to make similar sized KPI boxes or charts in Power BI, other than manually resizing each individual visualization. As you know, making similar sized KPI boxes and / or charts are a design technique to make your repor
Reading Text Files With PowerShell For Configurations Part I
(Tim Smith) Using text files for configurations can be especially useful in some environments, especially to avoid re-use or long arrays with many elements in them. Can we use PowerShell with a configuration text file, where we could extract the contents of the file and then use the contents line by
Creating Dashboards for Mobile Devices with Datazen – Part 3
(Arshad Ali) With the recent acquisition of Datazen by Microsoft, if you have SQL Server 2008 Enterprise Edition or later with Software Assurance, you can leverage (download and use) Datazen to create visually appealing dashboards for mobile devices across all the major platforms at no additional co
SQL SERVER – Error: Msg 245 – Conversion failed when converting the varchar value ‘Inactive’ to data type int
(Pinal Dave) Using CASE statements is something I see a lot of developers use. They use it in complex environments and I have been fortunate to troubleshoot and look at code blocks that run for pages using the standard CASE statements.
SQL SERVER – Error: Msg 245 – Conversion failed when converting the varchar value ‘Inactive’ to data type int
(Pinal Dave) Using CASE statements is something I see a lot of developers use. They use it in complex environments and I have been fortunate to troubleshoot and look at code blocks that run for pages using the standard CASE statements.
Using the Transaction History in SQL Server Master Data Services
(Koen Verbeeck) We are using SQL Server 2012 Master Data Services to manage our master data. There are frequent changes to some fields of an important entity and there are a lot of people who are allowed to make those changes. I would like to know if it is possible to find out who changed something
Using the Transaction History in SQL Server Master Data Services
(Koen Verbeeck) We are using SQL Server 2012 Master Data Services to manage our master data. There are frequent changes to some fields of an important entity and there are a lot of people who are allowed to make those changes. I would like to know if it is possible to find out who changed something
