Most DBAs and Developers know how indexes work and how to write efficient queries. However, the secrets of efficient indexes and queries are actually hidden in behind-the-scene configurations. When these essential configurations are not set correctly, database application performance goes downhill. SQL Server Optimizer Engine produces many different possibilities and helps build an optimal execution plan for any query. Join IDERA and Pinal Dave on Wednesday, August 15 at 11 AM CT as he walks through three of the most important settings that help SQL Server Optimizer Engine write better execution plans with indexes. This session will not discuss query rewriting or index modification. Instead, Pinal will discuss the secret configurations which are often ignored or overlooked by SQL experts. This session is for everyone who wants to improve the performance of their system without making any code changes. You can register for this Geek Sync here . This Geek Sync will be recorded and available in our Resource Center .
I am trying to create Visual Data Lineage Transformations and Data Movement Rules via Macros. The DataMovementRuleLink.ValueOverride does not work when the RuleType is Text. It works for other Rule Types. Am I defining the correct objects in the dim section? Pierre Option Explicit Sub main Dim diag As Diagram Dim dfs As DataFlows Dim df As DataFlow Dim tr As Transformation Dim dmrl As DataMovementRuleLink Debug.Clear Set diag = DiagramManager.ActiveDiagram Set dfs = diag.DataFlows Set df = diag.ActiveDataFlow Set tr = df.Transformations.Item(„Initial Load – Step 1”) ‚ Or any other transformation in dataflow For Each dmrl In tr.DataMovementRuleLinks Debug.Print „————————————–” Debug.Print „RuleName: ” + dmrl.RuleName Debug.Print „RuleType: ” + dmrl.RuleType If dmrl.RuleName = „Test” Then Debug.Print „Old Value: ” + dmrl.ValueCurrent dmrl.ValueOverride = „Text Updated by Macro” ‚ works fine Debug.Print „New Value: ” +dmrl.ValueCurrent ElseIf dmrl.RuleName = „test2” Then Debug.Print „Rule Text: „+ dmrl.RuleText Debug.Print „Old Value: ” + dmrl.ValueCurrent ‚ Returns 2 dmrl.ValueOverride = „3” ‚ Does not work , Also tried = „Option3”. Note: RuleText=1,*”Option1″,2,”Option2″,3,”Option3″ Debug.Print „New Value: ” +dmrl.ValueCurrent End If Next End Sub
Both work … Get-WmiObject -Class Win32_PnpEntity | Select-Object -ExpandProperty Caption Get-CimInstance -ClassName Win32_PnpEntity | Select-Object -ExpandProperty Caption WMI over CIM in most cases is habit or on PSv2 and below where CIM Does not exist. Folks are just far more use to WMI and CIM is only really a thing for the more recent OS Windows versions. Well, even if you are using the latest OS and PS version. You must always plan for the lowest common denominator in your enterprise. So, get in the habit, for now of using branching code. Meaning always check for OS and PS version and take the most prudent branch. However, for PSv6 (PSCore cross platform) only CIM works, as there Get-WMI* is not in PSCore. I still find much WMI far more performant that CIM and on many things (not in this simple case), and in many cases WMI brings back more than CIM. Odd, I know but it is what it is. The primary reason for CIM over WMI is WMI(DCOM) is not firewall friendly, well that and it’s where things are in PSCore cross platform. The primary reason for WMI is backwards compatibility. ‚blogs.technet.microsoft.com/heyscriptingguy/2014/01/27/what-is-cim-and-why-should-i-use-it-in-powershell’ ‚blogs.technet.microsoft.com/heyscriptingguy/2016/02/08/should-i-use-cim-or-wmi-with-windows-powershell’ ‚powershell.org/2013/03/24/wmi-vs-cim’ ‚maikkoster.com/cim-vs-wmi-cmdlets-the-top-reasons-i-changed’ ‚maikkoster.com/cim-vs-wmi-cmdlets-speed-comparison ‚informit.com/articles/article.aspx?p=2477536’
One of PowerShell’s great strengths is that there are often a number of ways to achieve the same endpoint. It’s also a great weakness as newcomers are confused as to which approach to adopt and “experts” will tell you that you should only use approach… Read the full text.
Why WMI? and not CIM?
I’ve read and heard a lot about PowerShell speed recently – that is the speed of execution of your scripts and how you can make your code faster. The first thing to think about – and this is the one many people miss – is does the absolute speed of… Read the full text.