A Stock Price Correlation Matrix
Building a Stock Price Correlation Matrix Using TVPs, a CROSS JOIN and the PIVOT Function
2012-05-14
6,407 reads
John Ryle
Calculating Stock Returns Using the ROW_NUMBER function and CTEs
In finance, when pricing data isn't available on last day of week, month or year, calculating returns is tricky. This article addresses the issue.
2011-10-18
6,497 reads
Blogs
On Dynamic Ports, Named Instances, and Firewalls
By Will Assaf
Recently I had a client and their vendor trying to configure a firewall for...
Daily Coping 13 Jul 2020
By Steve Jones
I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to...
Last Week Reading (2020-07-12)
By Kamil
Press Azure resource providers operations List of all of the available ADF-specific RBAC permissions....
Forums
Help needed in getting all AD users and groups
I have very limited knowledge with server management. I need to extract AD users...
What do you like for third party database backup/restore for SQL server & Azure
Hi all, my company currently uses SQL server native tools to perform nightly backups. ...
Find the last occurrence of \ character and get the left of string.
How to find the last occurrence of '\' in the following string and get...
Ask SSC