That's another best practice to rename the "sa" account. You should do it if you can.

There should not be any problem as far as you have some another account with...

Both CDC and Replication has their own unique purposes. CDC captures the Audit Log of the table and Replication ensures that all the Secondary instances are up to date with...

SA should be disabled in Production environment. There could be another login/user with required roles.

If Windows AD Accounts can be used instead of SQL Server Authentication then it provides additional...

I guess HTML can be stored with VARCHAR(MAX) or XML Data Types. If this is what you wanted?

On the top you have mentioned that you have removed the AlwaysOn but in the bottom you mentioned you cannot remove this DB from AlwaysOn. Would you please clarify whether...

https://blogs.msdn.microsoft.com/sql_protocols/2006/02/21/understanding-login-failed-error-18456-error-messages-in-sql-server-2005/

http://www.sommarskog.se/error_handling/Part2.html

A value between 0 and 255 that may give more information about the underlying cause for the error. An important example is message 18456, Login failed for user '%s'....

-- DB Size
SELECT 
database_name = DB_NAME(database_id)
, status = state_desc
, log_size_mb = CAST(SUM(CASE WHEN type_desc = 'LOG' THEN size END) * 8. / 1024 AS DECIMAL(8,2))
, row_size_mb =...

Some error messages can be raised at multiple points in the code for the Microsoft SQL Server Database Engine. For example, an "1105" error can be raised for several different...

Are you trying to build the dynamic T-SQL query to SELECT the dynamic columns and filter using WHERE clause using dynamic columns ? If yes, then you can use the...

I hope below query will work for you.

-- TABLE SCHEMA WITH SAMPLE DATA 
DECLARE @Employee TABLE
(
AppNumber VARCHAR(20)
, Employee VARCHAR(50)
, [Date] DATE
, Time_generatedat TIME
)

INSERT INTO @Employee (AppNumber, Employee,...

I hope below query will work for you.

-- TABLE SCHEMA WITH SAMPLE DATA 
DECLARE @Employee TABLE
(
AppNumber VARCHAR(20)
, Employee VARCHAR(50)
, [Date] DATE
, Time_generatedat TIME
)

INSERT INTO @Employee (AppNumber, Employee,...

Try this.

select C.EmpLocationName, B.EmpCategoryName, count(A.EmpCategoryID) as CategoryCount
FROM EmployeeMaster A
LEFT JOIN EmployeeCategory B ON A.EmpCategoryID = B.EmpCategoryID
INNER JOIN EmployeeLocation C ON A.EmpLocationID = C.EmpLocationID
where ISNULL(A.IsDeleted,0) = 0
Group by...

Kindly share your query.

Auto Update Statistics option of SQL triggers the update of statistics only after certain conditions are met. Hypothetically when around 10-20% of the total rows are added/modified in a table.

So...