Phil Factor Temporary Tables in SQL Server Temporary tables are used by every DB developer, but they're not likely to be too adventurous with their use, or exploit all their advantages. They... 01 August 2020 22 min read
Blogs Dennes Torres in Blogs New Technologies to Study One great result from PASS Summit, especially when we are close to a new SQL Server release, is to identify important technologies to study on... 28 November 2018 7 min read
Hugh Bin-Haad Relational Algebra and its implications for NoSQL databases With the rise of NoSQL databases that are exploiting aspects of SQL for querying, and are embracing full transactionality, is there a danger of the... 01 April 2016 4 min read
Kathi Kellenberger T-SQL Window Function Speed Phreakery: The FIFO Stock Inventory Problem Sometimes, in the quest for raw SQL performance, you are forced to sacrifice legibility and maintainability of your code, unless you then document your code... 16 March 2016 14 min read
Dennes Torres Creating a Date Dimension in a Tabular Model As well as its multidimensional model, SQL Server Analysis Services (SSAS) now has a tabular model of database that either runs in-memory or in DirectQuery... 15 March 2016 23 min read
Dennes Torres Creating a Date Dimension in an Analysis Services (SSAS) Cube A walk-through can be a great help to understanding SQL Server Analysis Services, especially when it solves the problem of providing an effective date dimension... 24 February 2016 33 min read
Sergei Dumnov Using R Machine Learning Script as a Power BI Desktop Data Source You can develop a Power BI Dashboard that uses an R machine learning script as its data source and custom visuals. Here is a simple... 27 January 2016 11 min read
Casimir Saternos Data Manipulation in R: Beyond SQL Although SQL is an obvious choice for retrieving the data for analysis, it strays outside its comfort zone when dealing with pivots and matrix manipulations.... 13 January 2016 19 min read
Michael Sorens Documenting Your PowerShell Binary Cmdlets Whereas it is easy to provide inline documentation for a normal scripted PowerShell cmdlet or function so as to provide comprehensive help at the command-line... 17 November 2015 31 min read
Christos Matskas Using SignalR to Create Mobile Applications SignalR isn't just for web applications. It can also provide the basic real-time communications for a connected Windows Universal Application or even iOS and Android... 16 November 2015 12 min read
Edward Elliott SQL Server Data Tools (SSDT) and Database References SQL Server Data Tools (SSDT) provides, via the DacPac, interesting support for verifying not only those references within the database, but also those to other... 16 November 2015 12 min read
Doris Robinson Testing and the Application Lifecycle In application or database development, testing is too often given secondary importance. There are advantages to the whole delivery process if testers can get involved... 07 October 2015 19 min read
Robert Sheldon Power Query Formula Language in Power BI Desktop The Power Query Formula Language (PQFL) is a functional language that drives the Power BI transformations, and allows you to create mashup queries from scratch.... 21 September 2015 19 min read
Robert Sheldon OpenStack: The Good and Not-So-Good Bits OpenStack holds a great deal of promise as a cloud platform built on open standards, and has support from the major players in cloud services.... 03 September 2015 15 min read
Robert Sheldon Working with SQL Server data in Power BI Desktop What's the best way of providing self-service business intelligence (BI) to data that is held in on-premise SQL Server? Not, it seems, Power BI 2.0... 24 August 2015 24 min read
Robert Sheldon An Introduction to the OpenPOWER Foundation In a bid to challenge Intel's dominance of high performance computing environments, IBM have introduced OpenPOWER, a flexible open-source framework based on their POWER processor... 03 August 2015 12 min read
Arkadiusz Pachucy Multi-Platform Mobile Development with PhoneGap It seems a great idea to have your application on all the main mobile platforms as well as on the desktop. Nothing beats writing an... 27 July 2015 17 min read
Robert Sheldon The Evolution of SQL Server BI It is sometimes hard to keep up with Microsoft's direction in Business Intelligence. Over the years, we've been presented with so many ways of aggregating,... 27 July 2015 14 min read
Joe Celko SQL Style Habits: Attack of the Skeuomorphs Although we like to think that our programming techniques are progressive and in tune with the bleeding edge of software development practices, too often they... 14 July 2015 13 min read
Michael Sorens The Poster of the Plethora of PowerShell Pitfalls One of the downsides of learning a new computer language is that transfer of training doesn't always work to your advantage. In fact, the habits... 25 June 2015 28 min read
