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
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 – Part 1 CQRS (Command Query Responsibility Segregation) allows developers to segregate data modification from selecting data. In this first article of the... 26 September 2018 15 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
Data Privacy and Protection William Brewer in Data Privacy and Protection Fifty Different Ways to Enact Data Privacy Laws? Now that the GDPR has gone into effect, many are wondering what will happen in the United States. California is... 19 September 2018 13 min read
.NET Lance Talbert in .NET Introducing the Unity Job System Performance is important to video game players. If a game is slow, the player may experience unintended difficulties in timing,... 17 September 2018 15 min read
