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
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 C# dynamic Keyword: DLR, ExpandoObject, and DynamicObject Explained Explore the C# dynamic keyword and the Dynamic Language Runtime: use cases for dynamic JSON deserialisation, ExpandoObject for runtime member... 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
Editorials Dean Mathews in Editorials Entrepreneurship Vs. Employment: Which Is the Best? Being an entrepreneur isn’t for everyone; by the same token, being an employee is not either. There are serious pros... 04 October 2018 3 min read
Books Grant Fritchey in Books SQL Server Execution Plans, Third Edition, by Grant Fritchey Every Database Administrator, developer, report writer, and anyone else who writes T-SQL to access SQL Server data, must understand how... 04 October 2018 2 min read
Database Administration Kellyn Pot'Vin-Gorman in Database Administration How to Linux for SQL Server DBAs — Part 2 SQL Server DBAs are typically quite familiar with security and best practices in Windows but may not understand how security... 26 September 2018 17 min read
.NET Diogo Souza in .NET Getting Started with CQRS in ASP.NET Core: MongoDB, RabbitMQ, and SQLite Implement CQRS in ASP.NET Core using MongoDB for the query side, RabbitMQ as the message broker for events, and SQLite... 26 September 2018 16 min read
Editorials Kathi Kellenberger in Editorials Is Certification Worth It? I was recently asked if I thought getting a Microsoft certification was valuable. I see quite a few benefits. Certifications... 23 September 2018 3 min read
Software Delivery Afsana Atar in Software Delivery A Primer on Defect Management Defects in software can occur in any phase of the software creation process. The earlier and better they are managed,... 19 September 2018 21 min read
