PowerShell Greg Moore in PowerShell Using a Server List to Control PowerShell Scripts PowerShell is the preferred tool for many DBAs when automating SQL Server administration. In this article, Greg Moore demonstrates how... 29 January 2019 13 min read
Data Privacy and Protection Robert Sheldon in Data Privacy and Protection Introduction to SQL Server Security — Part 2 In this article, the second in the series, Robert Sheldon demonstrates how to manage the SQL Server security with granting... 28 January 2019 23 min read
.NET Lance Talbert in .NET Introduction to Mobile Development with Unity In today’s world, some people do not need computers because they can do everything on their smartphones. Playing games is... 16 January 2019 17 min read
T-SQL Programming Joe Celko in T-SQL Programming Empty Thoughts: Working with NULL Whether or not to have NULLable columns in a table can be a religious debate, and how missing data is... 10 January 2019 12 min read
.NET Joydip Kanjilal in .NET ASP.NET Core Policy-Based Authorization: Requirements, Handlers, and Claims Implement policy-based authorization in ASP.NET Core: build custom authorization requirements, write authorization handlers, register policies in middleware, and use claims-based... 08 January 2019 13 min read
Software Delivery Michael Sorens in Software Delivery Better Code Reviews with GIT As more dev teams move their code to Git, it’s important to understand the differences between it and other tools... 07 January 2019 12 min read
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 DAX Measures in Power BI: Calculated Fields, Time Intelligence, and CALCULATE Learn to create DAX measures in Power BI: SUM, AVERAGE, COUNT for single columns, SUMX and COUNTX iterator functions for... 28 December 2018 23 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 SQL Server JSON: Transferring Data with FOR JSON, OPENJSON, and JSON Schema Validation Transfer data between SQL Server databases using JSON - exporting tables with FOR JSON, importing with OPENJSON, validating file contents... 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
