This system stored procedure returns information on windows accounts or groups in SQL Server. One of … xp_logininfoRead more
sp_validatelogins
The system stored procedure sp_validatelogins returns a list of logins in an SQL Server instance that … sp_validateloginsRead more
Deadlock Basics
Deadlocks in SQL Server can be difficult to avoid completely, but there are some basic rules … Deadlock BasicsRead more
Virtual Log File Basics
The SQL Server transaction log files are managed as singe files in SQL Server. But internally … Virtual Log File BasicsRead more
sp_describe_first_result_set
The system stored procedure sp_describe_first_result_set was introduced in SQL Server 2012 and it returns meta data … sp_describe_first_result_setRead more
Configuring SSRS
I was configuring SSRS (SQL Server Reporting Services) to run locally on my new developement machine, … Configuring SSRSRead more
Introduction to SQL Server Data Tools – SSDT
SQL Server Data Tools, SSDT, is a plugin to Visual Studio 2010 and later, with the … Introduction to SQL Server Data Tools – SSDTRead more
Bollinger Bands in T-SQL
Bollinger Bands® is a technical analysis tool trademarked by its inventor, John Bollinger. The basis for … Bollinger Bands in T-SQLRead more
Relative Strength Index RSI in T-SQL
The relative strength index (RSI) is a calculation in TA (Technical Analysis) which measures the strength … Relative Strength Index RSI in T-SQLRead more
MACD in T-SQL
The MACD (Moving Average Converenge Divergence) is a calculation in technical analysis used as a indicator … MACD in T-SQLRead more