Monday, January 31, 2011

SQL Script to check if cubes processe...

SQL Script to check if cubes processes are running or not - Following script will list down all processes which were... http://ping.fm/WI7an

Sunday, January 30, 2011

Agent XPs Component is turned off - C...

Agent XPs Component is turned off - Cannot show requested dialog. Additional information: unable to execute requeste... http://ping.fm/EQax2

SQL Server, Error: 547 Maintenance Pl...

SQL Server, Error: 547 Maintenance Plan Error - I was trying' to delete an obselete SQL Server Agent job until this ... http://ping.fm/v3jVk

SQL Script to check space used by all...

SQL Script to check space used by all log files - Following script helps us to get Current total Log File size occup... http://ping.fm/90IlH

Wednesday, January 26, 2011

SQL Script to Change Collation Settin...

SQL Script to Change Collation Settings for user database - Collation refers to a set of rules that determine how da... http://ping.fm/MuDx1

SQL Basics - What is SQL? SQL is the ...

SQL Basics - What is SQL? SQL is the core language used to do operations like store, access, modify & managing th http://ping.fm/ERPZU

Tuesday, January 25, 2011

SQL Script to check SQL Server cluste...

SQL Script to check SQL Server cluster Nodes - Following Script will help your to check SQL Server Cluster Nodes, wh... http://ping.fm/e7TzK

Monday, January 24, 2011

SQL Script to check storage utilized ...

SQL Script to check storage utilized by every database object http://ping.fm/8aawI

Sunday, January 23, 2011

Chapter 4 ? HOW TO CREATE A USER DEFI...

Chapter 4 – HOW TO CREATE A USER DEFINED DATABASE IN SQL SERVER http://ping.fm/yDDsT

Linux 6 is released? - Linux 6 is rel...

Linux 6 is released… - Linux 6 is released Related Posts:Adding Linux Expert to Community This is my test post SQL ... http://ping.fm/MMhbo

Friday, January 21, 2011

How much database space is required d...

How much database space is required during Index rebuild? - These are the Few Question, which every DBA want to get.... http://ping.fm/Pjz8G

Tuesday, January 18, 2011

How to Shrink Database File ? - SQL S...

How to Shrink Database File ? - SQL Script to shrink a unused space from a database file. -- ***********************... http://ping.fm/fO9VO

Monday, January 17, 2011

Script to shrink a database non used ...

Script to shrink a database non used space - HOW To SHRINK a Database? SQL Script to shrink a non used space from a ... http://ping.fm/NAVQn

Sunday, January 16, 2011

SQL Script to kill problematic sessio...

SQL Script to kill problematic session from SQL Server - SQL command / script to exclude/terminate/kill a problemati... http://ping.fm/66WwB

SQL Script to change a mirror endpoin...

SQL Script to change a mirror endpoint - SQL Error Database Mirroring login attempt failed with error: Connection ha... http://ping.fm/rj0dC

Friday, January 14, 2011

SQL Script to generate script for exi...

SQL Script to generate script for existing database permissions http://ping.fm/EZk9l

SQL Script to modify the database fil...

SQL Script to modify the database file size - Script that modifies the data file size for a specific database file. ... http://ping.fm/Qwr7z

Thursday, January 13, 2011

SQL Script that changes SQL Jobs Owne...

SQL Script that changes SQL Jobs Owner to SA - It's not a good practice to use individual domain user login to run S... http://ping.fm/pGTSM

Script to get all Database Size occup...

Script to get all Database Size occupied at file system level http://ping.fm/SUxBS

Wednesday, January 12, 2011

Script to Retrieve Tables, Indexes, F...

Script to Retrieve Tables, Indexes, Files and File Groups Information http://ping.fm/kWdXq

Monday, January 10, 2011

SQL Script to Get Free Space Informat...

SQL Script to Get Free Space Information where Database Files are located http://ping.fm/O5qRP

How to Purge data in SQL Server ? - W...

How to Purge data in SQL Server ? - What is Data Purging ? Data purging is just deleting the old data from the table... http://ping.fm/D6B3b

How to Clear Recent SQL Server Connec...

How to Clear Recent SQL Server Connection List From SSMS ? - Today a junior level developer had made a human error m... http://ping.fm/ZkGlS

Sunday, January 9, 2011

Can I run SQL Server 2005 32 bit on a...

Can I run SQL Server 2005 32 bit on a Windows Server 64 bit ? http://ping.fm/4XJUE

Thursday, January 6, 2011

Can I use Profiler on SQL Server Expr...

Can I use Profiler on SQL Server Express Edition ? - NO, SQL Server profiler is not supported on Express Edition. Re... http://ping.fm/y1xM3

How to Configure Antivirus on SQL Ser...

How to Configure Antivirus on SQL Server ? - Exclude the following files and directories from virus scanning on Dedi... http://ping.fm/e0Sir

Wednesday, January 5, 2011

When SQL Server Evaluation Edition wi...

When SQL Server Evaluation Edition will Expire ? - Evaluation Edition works for 180 days from the date of installati... http://ping.fm/B1E6h

How to check when was SQL Server inst...

How to check when was SQL Server installed ? - I am using Evaluation edition for testing and writing blog. Evaluatio... http://ping.fm/tedIQ

Tuesday, January 4, 2011

How to Restore SQL Server 2008 backup...

How to Restore SQL Server 2008 backup in SQL Server 2005 - Can we restore a SQL Server 2008 backup in SQL Server 200... http://ping.fm/tKjMA