A sample template that allows to upload the content of a CSV file to a Azure SQL database as soon as the .csv file is dropped in an Azure Blob Store. Full article is here: Generate also Shared Access ...

To encrypt and decrypt a string we have a predefined functions in Sql Server 2008 that are easy to use. Suppose we want to save some data that doesn't need to be exposed as a plain text then in such ...

Managing database performance and cost at scale is a challenge for any SaaS business. At TrackAbout, Inc. (a Datacor company) we provide a SaaS platform for tracking reusable, returnable containers ...

An aggregate function error in SQL occurs when you try to use an aggregate function in a way unsupported by the SQL language. You may experience the error if you do ...

DATEDIFF is a common function in the SQL Server to find the number of days between two dates. Oracle offers its own solution, although does not have the DATEDIFF function. You have the right to access ...