Asp Dot Net Tricks A… · 08:59 30 Jan 2018
Delete all rows from all tables SQL server
Have you ever come across the problem to delete all rows from all tables available in a database? One of my colleagues asked me this question that… Read More
Sql Server Database Blog Posts
Sqlserver-Dba.com · 13:11 24 Nov 2017
Troubleshooting an error message An error occurred in the Microsoft .NET Framework while trying to load assembly id xxx and needed to identify CLRs related to a particular database.
Th… Read More
Nothing Is Bug Free · 15:31 04 Feb 2016
This script is a parameterized stored procedure, [dbo].[DB_BACKUP_TO_DISK], to backup SQL Server Database (.BAK). Everything is to call this procedure with all parameters. See belo… Read More
Nothing Is Bug Free · 05:24 20 Dec 2015
see also -- Got Error: Invalid object name 'master.dbo.spt_values'As usually we use below connection string to connect to SQL Server using OLEDB provider.Data Source=DBSERVER;Initial Ca… Read More
Msdn Blogs | Get The… · 23:32 08 Feb 2018
As part of the Azure Database Migration Service (Azure DMS) Public Preview, we have released a PowerShell library to automate bulk database migrations from SQL Server to SQL Azure Database… Read More
Msdn Blogs | Get The… · 10:53 12 Dec 2017
Hi all,
This blog covers the process of migrating SAP ASE databases to Microsoft SQL Server using SQL Server Migration Assistant (SSMA) tool.
Sybase SAP Adaptive Server Enterprise (ASE) dat… Read More