T-SQL does not have an easy way to transpose a row and a column. Of course, there is the PIVOT statement, but it doesn’t quite accomplish the task. In this article, Darko Martinovic shares another method using a SQLCLR stored prodedure.… Read more
Azure Active Directory is a service that provides an authorization layer for different kinds of web applications easily. It is possible to implement it with many programming languages. Jakub Kaczmarek describes the development of an authorization procedure used in an Angular-based Chrome extension project.
… Read more
We make a special effort in March to acknowledge the accomplishments of women. Women have been making gains in many professions over the past several decades but are still underrepresented in technology. There are several hypotheses about why this is the case, but often women find they are not welcome in the “brogrammer” cultures of … Read more
SQL Server 2017 now includes a new feature to represent complex relationships in data called Graph Databases. Robert Sheldon introduces Graph Databases in the first article of this new series. … Read more
Most techniques used to develop enterprise applications may also be used to develop games. In this article, Mircea Oprea explains how to use a RESTful API to call a web service from a game using C# and Unity.… Read more
Developer shops may decide to use Read Committed Snapshot Isolation (RCSI) to reduce contention, and possibly improve performance, but it is not without its own pitfalls. In this article, Uwe Ricken describes a situation where long running transactions caused a severe performance degradation when RCSI was in use.… Read more
Stored procedures, for example, are very easy to document. The comment block at the beginning stays with the code and a CREATE or ALTER script contains everything to reproduce the proc. SQL Server tables, however, are more difficult to document. You can use Extended Properties to document columns and constraints, but working with Extended Properties is difficult at best. Phil Factor demonstrates ways to easily add Extended Properties to your build scripts. … Read more
With the release of .NET Core, developers must learn what has changed over classic ASP.NET programming. In this article, Dino Esposito explains that the skills you have will carry over well as he shows how to work with Action Control in ASP.NET Core. … Read more
Joe Celko reminisces about the origins of databases and one of the early pioneers, Charles Bachman. He explains how pointer chains were used to traverse data in the NDL standard and referential integrity that we use today.… Read more
Time management is simply the ability to plan how and where you spend your time throughout the work day. When you have a proper time management strategy in place, you will be more productive, enjoy your work more and have less stress. The process of implementing time management is really quite simple; it’s all about … Read more
Changing a data type seems like a simple task unless the table is quite large and downtime must be kept to a minimum. Danny Kruge walks you through the process he created to change an INT to a BIGINT in a large table.… Read more
Comparing URLs in C# code is a common task and seems simple. Camilo Reyes shows us that there are many pitfalls to avoid since people can come up with several ways to type the same URL. He then demonstrates how to solve several URL comparison problems.… Read more
As software development evolves to service-oriented architectures, the underlying frameworks and methods used must change as well. Mircea Oprea demonstrates how to create a service to manage authentication across components and servers.… Read more
Subscribe for more articles
Fortnightly newsletters help sharpen your skills and keep you ahead, with articles, ebooks and opinion to keep you informed.