(Kenneth Fisher) You’ll frequently hear that you should add the COPY_ONLY clause when taking an ad-hoc full backup to avoid messing up the backup chain. Just in case you haven’t: You should add the COPY_ONLY clause when taking an ad-hoc full backup to avoid messing up the backup chain.
Tag: sql server
Finding Out Which MDX Calculations Are Being Evaluated By Your Query In Analysis Services Multidimensional, Part 1
(Chris Webb) Since Analysis Services 2012 there have been two trace events that provide a lot of information about what’s going on in the Formula Engine when you run a query in Analysis Services Multidimensional: Calculation Evaluation and Calculation Evaluation Detailed Information.
Using AT TIME ZONE to fix an old report
(Rob Farley) As soon as I saw the SQL 2016 feature AT TIME ZONE, which I wrote about here at sqlperformance.com a few months ago, I remembered a report that needed this feature.
What’s New in Reporting Services 2016 – Part 2
(Koen Verbeeck) SQL Server 2016 was released the first of June 2016. This release comes packed with dozens of new features and capabilities, and Reporting Services (SSRS) has its biggest revamp since SQL Server 2008R2. In the first part of this tip, we introduced a couple of new features, such as th
Compare column names for case sensitivity
(Jen McCown) I’m reviewing the code for the upcoming Minion CheckDB, and one of the things we’re checking for is case consistency in column names.
What SQL Server for Linux says about Microsoft’s future plans
(Brien Posey) SQL Server on Linux may just be the start. After making PowerShell open source, Microsoft can build Linux versions of any of its server technologies. And it has reason to do so.
Using Extended Events Telemetry Session
(Arun Sirpal) You are probably wondering what this is, quite honestly I was wondering too. Well it is an extended events session known as telemetry_xevents that is shipped with SQL Server 2016.
#0399 – SQL Server – SSIS – Debugging – Exploring the Data Viewer
(Nakul Vachhrajani) I often get questions regarding debugging of SSIS packages with the most common scenario being a need to “see” the data flowing down the data pipeline. SQL Server Integration Services (SSIS) packages are explored and edited visually within the SQL Server Data Tools (SSDT) and he
Create Database Copies in Azure SQL Database
(John Miner) Many institutions have the requirement to take a database copy at the end of the month. This allows the institution to look at the state of the database at a point in time. How can this business requirement be solved with Azure SQL database?
Parse Dynamics AX Context Info
(Jason Brimhall) More and more I am seeing clients requiring assistance with the Microsoft Dynamics Suite. Each of the products in the suite comes with a different set of performance issues and gotchas.