Database Administration Greg Larsen in Database Administration Protecting SQL Server Data Using Static Data Masking In order to protect data and comply with regulations such as the GDPR and HIPAA, databases used by developers and... 07 January 2019 19 min read
Sysadmin Arvind Kumar in Sysadmin Robotics Process Automation: The New Digital Assistant When most of us think of robotics used in enterprises, automating manufacturing processes comes to mind. Robotics Process Automation (RPA),... 02 January 2019 9 min read
Opinion Pieces Alamzeb Khan in Opinion Pieces Cyber Insecurity in Pakistan Journalist Alamzeb Khan discusses recent security breaches in Pakistan that have affected millions of people and accounts. … 02 January 2019 11 min read
.NET Diogo Souza in .NET Getting Started with CQRS – Part 2 In this second article of the series, Diogo Souza walks you through creating the MongoDB code, the query side of... 31 December 2018 20 min read
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
