Categories
Sql Server

Central Management Server In SQL Server

Central Management Server In SQL Server Central Management Server In SQL Server designate an instance of SQL Server as a central management server in SQL Server. Central management servers store a list of all instances of SQL Server that is organized central management server groups. Actions will act on all servers in the server group of central […]

Categories
Iphone-iOS Microsoft Office

iPad-Export PDF from Word

iPad-Export PDF from Word This post is about iPad-Export PDF from Word.Microsoft office for iPad is a great tool. It had lots of features and solved a lot of day to day issues like editing and sending these document while traveling or outside office. The great thing is it’s FREE. You just have to sign […]

Categories
Sql Server

How to Drop Multiple Table with a Naming Pattern in SQL SERVER

How to Drop Multiple Table with a Naming Pattern in SQL SERVER Tomorrow I got an email from my boss to drop all tables starting with naming pattern ‘DUMMY’ in test database. There are thousand of tables with NAMING PATTERN DUMMY in that database. It is very annoying to delete all the tables one by […]

Categories
Sql Server

Import Data From Excel to SQL Server Using SSIS

Import Data From Excel to SQL Server Using SSIS In this post we will learn how to Import Data From Excel to SQL Server Using SSIS or how to import data from excel to sql server. In this SSIS package we have to configure Excel Source and OLEDB destination. After Configuration and connection setup is done you […]