BI Andy Brown in BI Creating Measures Using DAX In the first article in this series, Andy Brown demonstrated how to create calculated columns in Power BI using the... 28 December 2018 22 min read
Editorials Feodor Georgiev in Editorials The Single Version of the Truth If only there were a ‘single version of the truth’ in data and data analytics. Unfortunately, data and everything that... 20 December 2018 5 min read
Software Delivery Mohammad Rizvi in Software Delivery Factors Behind Successfully and Repeatedly Executing Digital Transformation Programs at a Lightning Pace IT transformation projects often fail due to poor planning, poor communication and more. In this article, Mohammad Rizvi explains how... 18 December 2018 11 min read
Editorials Kathi Kellenberger in Editorials Where’s the Bottleneck? Delta Airlines recently announced that they have implemented the first fully biometric terminal in the US, at Hartsfield–Jackson Atlanta International... 12 December 2018 3 min read
Database Administration Kellyn Pot'Vin-Gorman in Database Administration How to Linux for SQL Server DBAs — Part 3 DBAs running SQL Server on Linux will not only need to understand SQL Server security well, they will also need... 07 December 2018 14 min read
T-SQL Programming Joe Celko in T-SQL Programming Data Quality Problems with data quality are easier and cheaper to prevent than to solve later. In this article, Joe Celko talks... 05 December 2018 11 min read
PowerShell Greg Moore in PowerShell Treating SQL Server as an Object with PowerShell It’s easy to use invoke-sqlcmd to send T-SQL statements to SQL Server from PowerShell. There is, however, a rich PowerShell... 29 November 2018 14 min read
Editorials Feodor Georgiev in Editorials Common Sense Data Science Data science is so hip today that everyone is doing it. Everyone is showing off their ‘data science muscles’ by... 28 November 2018 4 min read
T-SQL Programming Phil Factor in T-SQL Programming Transferring Data with JSON in SQL Server JSON is a viable option for transferring data between systems. It has the ability to include schema information along with... 25 November 2018 31 min read
Editorials Kathi Kellenberger in Editorials Are Tech Conferences Worth It? In September, thousands of IT professionals, developers, and trainers descended on Orlando, FL, for Microsoft’s Ignite conference. This was Microsoft’s... 15 November 2018 3 min read
Data Privacy and Protection Robert Sheldon in Data Privacy and Protection SQL Server Auditing for HIPAA and SOX – Part 4 Regulations may require that you audit exactly who does what in your databases. Robert Sheldon explains how SQL Server can... 13 November 2018 13 min read
.NET Lance Talbert in .NET Voice Commands in Unity Today, we use voice in many ways. We can order groceries, ask to hear certain musical recordings, and much more... 13 November 2018 13 min read
Editorials Feodor Georgiev in Editorials Data Security: Nowhere to Hide In my view, data security is an abstract concept, just as abstract as money, religion and fascination – all devised... 01 November 2018 3 min read
Database Administration Laerte Junior in Database Administration What Is SQLPSX? SQLPSX is a useful library you can add to PowerShell to automate many DBA tasks. In this article, Laerte Junior... 29 October 2018 12 min read
Data Privacy and Protection Robert Sheldon in Data Privacy and Protection SOX and Database Administration – Part 3 Database administrators are typically responsible for the security and availability of financial data. In this article, Robert Sheldon discusses SOX,... 24 October 2018 13 min read
.NET Camilo Reyes in .NET Working with the Dynamic Type in C# Dynamic types were introduced in .NET 4. Dynamic objects let you work with structures such as JSON documents whose composition... 15 October 2018 13 min read
PowerShell Robert Cain in PowerShell Testing PowerShell Modules with Pester In the third article of this series on testing PowerShell code with Pester, Robert Cain demonstrates how to test the... 15 October 2018 45 min read
Editorials Kathi Kellenberger in Editorials Do You Have a Career or a Job? Recently, I thought about the difference between a career and a job. Technically, a job is one employment agreement out... 15 October 2018 3 min read
PowerShell Nicolas Prigent in PowerShell Azure and Windows PowerShell: Using VM Extensions In the third part of his series, Nicolas Prigent describes how to run post-deployment configuration and automation tasks on Azure... 09 October 2018 10 min read
Data Privacy and Protection Robert Sheldon in Data Privacy and Protection HIPAA and Database Administration – Part 2 HIPAA was signed into law in the United States in 1996. In this article, Robert Sheldon discusses how the act... 09 October 2018 13 min read
