(Pinal Dave) Working on PowerShell scripts have been an interesting journey. I have written a couple of posts before on using WMI events. Was pondering on this thought and this blog is inspired by combining using of WMI with PowerShell. So what are we trying to solve?
Tag: sql server
TSQL Script to Clear SQL Server Cache
(Devi Prasad) Below script that can be used to clear SQL Server Cache. Helpful while working on performance tuning of SQL Scripts.
Securing your Azure Virtual Network using Network ACLs with Narayan Annamalai
(Scott Hanselman) Senior Program Manager Narayan Annamalai teaches Scott how to use Network ACLs (Access Control Lists) within an Azure Virtual Network. You can create control access to objects within Azure by subnet and network!
PowerShell: How to Find Logical and Physical Processors on SQL Server?
(Pinal Dave) Working on PowerShell scripts have been an interesting journey. I have written a couple of posts before on using WMI events. Was pondering on this thought and this blog is inspired by combining using of WMI with PowerShell. So what are we trying to solve?
How to Clone a SQL Server Login, Part 3 of 3
(K. Brian Kelley) I have read part 1 and part 2 of your tip series and the tips are great. I have a large environment with numerous SQL Server databases where I need to clone logins. How can I automate this code to save time and ensure accuracy?
How to Clone a SQL Server Login, Part 3 of 3
(K. Brian Kelley) I have read part 1 and part 2 of your tip series and the tips are great. I have a large environment with numerous SQL Server databases where I need to clone logins. How can I automate this code to save time and ensure accuracy?
SQL SERVER – Puzzle – DISTINCT Values in NVARCHAR
(Pinal Dave) The technique used in this blog is explained in earlier blog SQL SERVER – Creating Dataset Using VALUES Clause Without Creating Table. To read more about Collation and Unicode refer to MSDN. This topic in general is very deep and complicated sometimes that you get to learn something eve
SQL SERVER – Puzzle – DISTINCT Values in NVARCHAR
(Pinal Dave) The technique used in this blog is explained in earlier blog SQL SERVER – Creating Dataset Using VALUES Clause Without Creating Table. To read more about Collation and Unicode refer to MSDN. This topic in general is very deep and complicated sometimes that you get to learn something eve
Using DAX to make your Power BI DataViz more meaningful
(Jason Thomas) One of the best features I like about Power BI Desktop is that the data acquisition, data modeling and data visualization functionalities are all integrated in a user friendly way. I don’t have to leave the Power BI desktop to perform any of these common operations when I am playing w
SQL Server name limitation with GPConnNet and VS Tools
(Steve Endow) I previously wrote about a situation where the Dynamics GP GPConnNet library is unable to connect to a SQL Server instance if a port number must be specified.
