Cache SQL Server Data in a .NET Web Application

One of the slowest parts of any application is data retrieval and in this article, we look at how to cache SQL Server data for a web application.

PostgreSQL 101: The 10 key differences between SQL Server & PostgreSQL

Join us for the second webinar in our PostgreSQL 101 series.

As a SQL Server developer or DBA, you have a broad skill set and have become accustomed to interacting with the larger #SQLFamily community. Now, by choice or necessity you've begun to explore PostgreSQL and things feel oddly familiar and foreign at the same time.

Join Ryan Booze on May 25th to find out the things that often trip up SQL Server users when they first start exploring PostgreSQL.

Empathetic Design

An old sport saying goes like this “I could beat them with one arm tied behind my back.” Well, after six weeks with my arm in a sling, I am in awe of whoever tries that because everything is a lot harder. Like washing your hand and then drying it, becomes more of a challenge […]

Copy SSIS Environment variables to another server

Migrate SSIS environment variables from one SQL Server to another in just a few clicks using SSIS Catalog Migration Wizard.

Watashiato

Steve learns a few new words, and reflects on life and the impact we have on others.

REPLACE versus TRANSLATE for SQL Server Text Data Manipulation

Learn how to replace text in SQL Server strings using the REPLACE and TRANSLATE functions and how these could be used for data manipulation.

The Journey to Team-based Development with Flyway

This article explains why Flyway is fundamentally well-suited to the task of bringing control and automation to database development work and then the features of Flyway Teams edition that become necessary when a team of developers need to work concurrently on a database.

Demystifying Best Practices and Enhancing RDS security with Amazon GuardDuty

This article looks at four security best practices for protecting databases in AWS along with how GuardDuty can be used to provide additional security.

The Problems with Gods

An account with unlimited privileges is potentially an issue.

Getting Out of Character

In this article, Joe Celko gives us a history of the different character sets that are used in computing and how that can pertain to your usage in relational databases. Some of these you may have never heard of!