(Scott Murray) What are Power BI Pulse Charts and how are they used? Can you provide a step by step example on how to get started with Power BI Pulse Charts?
Tag: sql server
SQL SERVER – FIX: Arithmetic Overflow Error in Object Execution Statistics Report in Management Studio
(Pinal Dave) Many times, there are unforeseen conditions and few developers can’t predict which writing the code of a product. This is the reason we have bugs in the products and we all have job to do. One of my clients was not able to run one of the inbuilt reports which come with SQL Server Manage
(Kenneth Fisher) T-SQL Tuesday Our host for T-SQL Tuesday this month is Jens Vestergaard (b/t) and he has asked about our favorite SSMS tool. My initial thought was to talk about using solutions in SSMS but I’d already written about that.
(Hannes du Preez) There are times that you need to access information from the previous row or next row from the current row. Here is a small trick that makes use of a CTE to get this information:
(SourabhAgarwal) Replication Distribution database is the perhaps the most important entity in the entire replication topology. Apart from storing the replication metadata and history for replication agents, the distribution database, in case of transactional replication, also provides intermediate
(Graham Okely) One of the issues with Availability Groups is that you need to make sure the SIDs on the primary and secondary are the same, so when you failover there are no issues connecting to the database.
(Jack Vamvas) Question: There is lots of information around the SQL Server Change Data Capture (CDC) feature, and I’m trying to decide if CDC is suitable for the purposes of a project which requires data auditing.
(Jason Brimhall) One of my most favorite things in the world is the opportunity to deal with extremely varying database and environment requirements. Many vendors and databases seem to have a wide swath of different requirements.
The Order You Select Columns In The Power Query Editor Can Affect The Output Of Some Transformations
(Chris Webb) Maybe this is obvious to more experienced Power Query users, but something I always point out when I’m training people up on Power Query is that the order that you select columns in the Power Query Editor window (both in Power BI Desktop and Excel) can affect the output of certain trans
SQL SERVER – Upgrade Error – ALTER DATABASE Statement Not Allowed Within Multi-statement Transaction
(Pinal Dave) Most of the time applying service pack for SQL Server is a child’s play. Double click on exe, keep hitting next, next and finally press update. But when it fails, you would need an expert to fix the issue. Recently, one of my clients faced a problem while installing SQL Server 2014 Sp2.