Thank You Arun for this post.

I am a fan of this technique of yours where you give a big chunk of information/comparison in the form of a table which...

Hello Arun,

thanks for the answer. However, what I meant were the equal names  of the solution description:

Check_async_SQLAgent_jobs_and_alert.sql: Use this script to create another stored procedure which will check and...

Hello,

just to mention that the last two scripts have the same name in the initial description as well as in the scripts itself (there the description is also the...

Thanks Jeff and Grant for responding. I now have two articles waiting for Steve's approval.

Don’t know if those will make the cut. Let’s see.

Very well said Steve ! Continuously looking for areas to improve is key. Not rushing things and trying to do it right from the very get go is equally important.

Hello water490.

I do not see a row terminator, did you use one?

If the csv extract is coming from a unix based O.S. use '0x0a' as terminator if not, you can...

• This reply was modified 2 years, 9 months ago by  Arun Yadav.

Hi, all - I'm trying to automate a script to run a query against a local server group and output the results to a .csv file and then push...

Hello,

Please check the below articles:

https://docs.microsoft.com/en-us/sql/relational-databases/security/encryption/transparent-data-encryption?view=sql-server-ver15

https://www.red-gate.com/simple-talk/databases/sql-server/t-sql-programming-sql-server/encrypting-sql-server-transparent-data-encryption-tde/

https://support.delphix.com/Delphix_Virtualization_Engine/MSSQL_Server/Setting_Up_SQL_Server_Transparent_Data_Encryption_(TDE)_For_Use_With_The_Delphix_Engine_(KBA1401)

Agree with the comments. The deployment options for Azure SQL are:

SQL Databases, SQL Managed Instance, and SQL Virtual Machines.

Deployment models for Azure SQL Database are

• Single database, and
• Elastic Pool

...

Great, thanks for liking and sharing Michael....

Willing to review articles on general database administration, automation, powershell, ansible.

SQL Server 2005 SP4 cannot be removed once it is applied. It cannot be removed without uninstalling SQL Server 2005 completely. Please backup all user databases and system databases before...

Hello Tava,

From where the username and password will be taken?

Is this an interview question? Please check the following links for better understanding.

Endpoints: http://msdn.microsoft.com/en-us/library/ms179511(v=sql.100).aspx

Database Mirroring: http://msdn.microsoft.com/en-us/library/ms189852(v=sql.105).aspx

If I am getting it right.. The...