Posted in Database

An Overview of User-defined SQL Server Types

In this article, we will explore User-defined SQL Server Types and their usage. An Overview of System Data Types SQL Server supports various data types…

Continue Reading... An Overview of User-defined SQL Server Types
Posted in Database

SQL SERVER – CREATE Statement in TRANSACTION

Recently my client of Comprehensive Database Performance Health Check asked me if we can use the CREATE statement in the TRANSACTION or not. The answer…

Continue Reading... SQL SERVER – CREATE Statement in TRANSACTION
Posted in Database

Learn SQL: SQL Injection

SQL Injection is a well-known technique used to attack SQL-based applications. In this article, we’ll focus on examples showing how you could exploit database vulnerabilities…

Continue Reading... Learn SQL: SQL Injection
Posted in Database

SQL Authority 14 Years of Daily Blogging and Upcoming Changes

Yesterday’s blog was a special blog as it was my 14th anniversary of daily blogging at SQLAuthority.com. Additionally, yesterday’s blog was also a 5286 continuous…

Continue Reading... SQL Authority 14 Years of Daily Blogging and Upcoming Changes
Posted in Database

How to Write Efficient Query? – Interview Question of the Week #300

Question: How to Write Efficient Query? Answer: There is no right or wrong answer to this question. Honestly, there is no definition of an efficient…

Continue Reading... How to Write Efficient Query? – Interview Question of the Week #300
Posted in Database

Install SQL Server Linux (2017 version) on SUSE Linux in Amazon EC2 instance

In this article, we will install and configure SQL Server Linux (2017 version) on SUSE Linux in the Amazon EC2 Instance. Introduction SQL Server works…

Continue Reading... Install SQL Server Linux (2017 version) on SUSE Linux in Amazon EC2 instance
Posted in Database

SQL SERVER – Fix Error 8632 – Internal Error: An expression Services Limit Has Been Reached

Recently I was helping a client with  Comprehensive Database Performance Health Check and we found a very strange error when we tried to run a…

Continue Reading... SQL SERVER – Fix Error 8632 – Internal Error: An expression Services Limit Has Been Reached
Posted in Database

T-SQL scripts to identify unused database files

In this article, I am going to show how we can automate the report of unused database files using T-SQL. Introduction Often organizations have a…

Continue Reading... T-SQL scripts to identify unused database files
Posted in Database

SQL SERVER – Follow Up Question on Write Efficient Query

Earlier this week, I published a video Performance Challenge – Write Efficient Query – SQL in Sixty Seconds #140. The video got amazing feedback. After…

Continue Reading... SQL SERVER – Follow Up Question on Write Efficient Query
Posted in Database

Prediction with Classification in Azure Machine Learning

Introduction After discussing Regression in the previous article, let us discuss the techniques for Classification in Azure Machine learning in this article. Like regression, classification…

Continue Reading... Prediction with Classification in Azure Machine Learning