Displaying posts categorized under

SQL Server

Microsoft Database Technology.

SQL Server connection in WMI Script

SQL Server connection in WMI Script. VB Script provides composition of WMI and SQL Server. You can connect SQL Server and store WMI informations in SQL Server. Before reading this blog you already know that WMI is also works like central communication machine for all network servers. To know more read http://nirav.extreme-advice.com/2013/05/15/get-disk-space-usage-from-central-server-with-wmi/. I have created one [...]

Monitor performance counter with WMI and SQL Server

Monitor performance counter with WMI and SQL Server. WMI is very important to use as central monitoring task. I have created performance monitoring which checks Disk Queue Legth, Disk Read/Sec, Disk Write/Sec, CPU Usage, Memory Usage, Disk Read Bytes/Sec, Disk Write Bytes/Sec, ASP Request/Sec. Create a table “PerformanceCounter” to store all information. Open Notepad and save [...]

Change file location of Master Database

Change file location of Master Database. To change file location of other database is very easy and it can be done in three steps. Step1 Detach that database. Step2 Cut from Old location and paste mdf and ldf files to new location. Step3 Attach database with new location. To change file location of master database [...]

Log Shipping with SQL Server 2012

Log Shipping with SQL Server 2012. SQL Server provides many ways for disaster recovery and log shipping is one of them. You can configure log shipping in three topology. 1). Configure log shipping on one instance with different database name. 2). Configure log shipping on different instance in same server. 3). Configure log shipping on [...]

Schedule SSIS Package Without Deploying

Schedule SSIS Package Without Deploying. You can schedule your package before you completely deploy it. you just need to build your SSIS Package and you will get executable “.dtsx” file. Path for “.dtsx” file is different according to SQL Server versions. For SQL Serve 2008 :  “your package path \bin\*.dtsx” For SQL Serve 2012 :  “your [...]

SSIS Package to generate MailProfile script

SSIS Package to generate MailProfile script. There is no provision to generate script for mail profile in sql server. but i have one script that can be used to create mail profile, mail account and map them together. I am using this script whenever i needed it, letter i have an idea to start scripting [...]

SSIS Package to Backup Jobs, Operators and Alerts Script using SMO

SSIS Package to Backup Jobs Script using SMO. This package willl use some SMO reference and generates SQL Server Jobs, Operators and Alerts script backup. I had written the code for SQL Server Jobs only and commented code for Operators backup and Alerts Backup. You just need to replcace Operators or Alerts instead of Jobs. [...]

SSIS Package to Backup Replication Script using SMO

SSIS Package to Backup Replication Script. Hi, This package willl use some SMO reference and generates SQL Server replication backup script same as you do it manually like, Right click on Publication –> Generate Scripts…. I have created SSIS package that automatically creates backup folder for current date and save your all replication publication script [...]

SSIS Package to get Table Schema Discrepancy using XML

SSIS Package to get Table Schema Discrepancy using XML. I have created package which uses XML in Execute SQL Task and compares two table’s schema discrepancy. You can use this script to compare table in different instances with different database or in same instance with difference database or in same instance with same database. You [...]