(Dennes Torres) Translations are a very usefull feature in multidimensional cubes. We can translate not only the cube structure, but also the data. Of course we need to have the data already translated in our table fields.
Tag: sql server
Query Store – SQL Server 2016
(Devi Prasad) Query Store in SQL Server 2016 is a kind of a Flight data recorder for SQL Server.
SQL SERVER – Querying Performance Counters from SQL Server
(Pinal Dave) Troubleshooting SQL Server is something almost every single DBA has to go through in their lifespan. It sounds simple and often we are clueless on where to start.
A few more about translation of cube dimensions
(Dennes Torres) Translations are a very usefull feature in multidimensional cubes. We can translate not only the cube structure, but also the data. Of course we need to have the data already translated in our table fields.
Query Store – SQL Server 2016
(Devi Prasad) Query Store in SQL Server 2016 is a kind of a Flight data recorder for SQL Server.
SQL SERVER – Querying Performance Counters from SQL Server
(Pinal Dave) Troubleshooting SQL Server is something almost every single DBA has to go through in their lifespan. It sounds simple and often we are clueless on where to start.
Lost Data
(Thomas LaRock) DBAs get paid for performance but we keep our jobs with recovery.
Set Select All as Default for Multi-Value Report Parameters in SQL Server Reporting Services
(Ghanesh Prasad) Most SQL Server Reporting Services (SSRS) reports contain multi-value report parameters and sometimes there be a requirement to set “Select All” as the default. There is not a simple way to set “Select All” as the default for an SSRS report, but in this tip I will demonstrate how to
Improving the Top / Top Descending Median Solution
(Paul White) Back in January 2015, my good friend and fellow SQL Server MVP Rob Farley wrote about a novel solution to the problem of finding the median in SQL Server versions prior to 2012. As well as being an interesting read by itself, it turns out to be a great example to use to demonstrate some
Lost Data
(Thomas LaRock) DBAs get paid for performance but we keep our jobs with recovery.
