Tag Archives: T-SQL

5 questions for time limited interview for BI developer position that touch almost all areas related to modern Microsoft BI

1. For example it’s necessary to allow user to input worker’s salary but ensure that it’s in range related to the worker’s category. Ranges for categories are stored in a separate table. Data inserted by using T-SQL. Where is the … Continue reading

Posted in Business Capability, Data to Knowledge, programming, Uncategorized | Tagged , , , , , , | Leave a comment

Restoring objects in SQL Server

This is a code googled in panic after occasional deletion of a stored procedure. Does real magic saving hours of work that could be spent on re-writing:  

Posted in Administration, programming, Uncategorized | Tagged , , | Leave a comment

Querying Tabular model XML/A with XPath

There can be various reasons to extract metadata from Tabular model, for example to compose documentation or logical model diagram. The next collections are useful from architectural point of view: list of dimensions, list of measure groups and measures, list … Continue reading

Posted in programming, Uncategorized | Tagged , , , , , , , | Leave a comment

R capability in SQL Server 2016

After the recent news that SQL Server 2016 will support R and old news that Microsoft acquired RevolutionR I was interested if SQL Server is planned to use parallel computing (map-reduce based realisation R) or existing open-source version. Attending seninars … Continue reading

Posted in Data to Knowledge | Tagged , , , , , , | Leave a comment

Quickly generate sequence of dates

DECLARE @Dates TABLE ([Date] date) INSERT INTO @Dates([Date]) SELECT DATEADD(DAY, NUMBER, ‘1 mar 2012’) FROM (SELECT DISTINCT number FROM master.dbo.spt_values WHERE NAME IS NULL) N WHERE DATEADD(DAY, NUMBER, ‘1 mar 2012’) < ‘1 may 2013’

Posted in Uncategorized | Tagged | Leave a comment

Concatenating Row Values in Transact-SQL

A useful trick for logging subsystem based on T-SQL: Found here among a number of similar solutions realised various ways.

Posted in programming | Tagged , | Leave a comment

Simplest Market Simulator on T-SQL

Ten hours of rash and the simplest market simulator is ready! Gracefully composes buy/sell commands list by trend events and perfectly calculates total return of fund, Sharpe ratio and other statistical parameters. This is an example of a task it helps to accomplish: If … Continue reading

Posted in Data to Knowledge, programming | Tagged , , , , , | Leave a comment