Saturday, December 31, 2011

Port For SQL Server - What is default...

Port For SQL Server - What is default port for SQL Server ? OR On which port SQL Server Database Services Runs ? OR ... http://ping.fm/Szo8G

Friday, December 30, 2011

SQL Script to find Expected Finish TI...

SQL Script to find Expected Finish TIME for current running BACKUP / RESTORE http://ping.fm/81Ubh

TOP SQL Server Posts for 2011 - This ...

TOP SQL Server Posts for 2011 - This is a quick review of top posts for year 2011 How to Setup Replication with SQL ... http://ping.fm/x3QBJ

Thursday, December 29, 2011

SQL Server Licensing ? Core Based Lic...

SQL Server Licensing – Core Based Licensing - Microsoft SQL Server will no longer be licensed by the CPU socket and ... http://ping.fm/B4lM1

SQL Server Injection - What is SQL In...

SQL Server Injection - What is SQL Injection? The ability to inject SQL commands into the database engine through an... http://ping.fm/wX3Vf

Wednesday, December 28, 2011

SQL WHERE ? Video Tutorial - Prior to...

SQL WHERE – Video Tutorial - Prior to understand Where clause, lets do a quick recap of SQL and then we will focus o... http://ping.fm/QXklF

How to Backup SQL?Video Tutorial - HO...

How to Backup SQL–Video Tutorial - HOW to BACKUP SQL ? How to backup SQL Server Database ? Ensuring reliable backups... http://ping.fm/qYvKZ

Installing SQL Server 2008 R2 SP1 - I...

Installing SQL Server 2008 R2 SP1 - I was rebuilding my machine this week and I installed three Instances of SQL Ser... http://ping.fm/mSxfh

Tuesday, December 27, 2011

How to Export SQL Profiler / Trace to...

How to Export SQL Profiler / Trace to SQL Server as table ? - I am running a running a SQL Server Profiler, a graphi... http://ping.fm/TNG3C

SQL Server Version / Builds List Comp...

SQL Server Version / Builds List Complete - In my previous post, where I was maintaining all SQL Server Versions and... http://ping.fm/hPTay

Monday, December 26, 2011

SQL Server Management Studio (SSMS) i...

SQL Server Management Studio (SSMS) is slow - My SQL Server Management Studio (SSMS) takes approx. 2-3 minutes to op... http://ping.fm/azrHs

SQL Server Express with Reporting Ser...

SQL Server Express with Reporting Services - Can we run Reporting Services with SQL Server Express Edition, which is... http://ping.fm/TJa0G

Sunday, December 25, 2011

Installing SQL Server Express Edition...

Installing SQL Server Express Edition on Windows 7 (Screen Shots) http://ping.fm/2sNfl

Saturday, December 24, 2011

Merry Christmas !!! - Bells are ringi...

Merry Christmas !!! - Bells are ringing and everyone is singing, It's Christmas! It's Christmas! Wishing you a Merry... http://ping.fm/Pr0oA

Wednesday, December 7, 2011

How to Give Read Definition Permissio...

How to Give Read Definition Permission to a User for all Procedures and Functions http://ping.fm/ANAM6

Tuesday, December 6, 2011

SQL Server 2012 Editions Licensing Co...

SQL Server 2012 Editions Licensing Costing - SQL Server Licensing is depends on which edition your are buying and un... http://ping.fm/xgmV1

Wednesday, November 30, 2011

Install SQL Server 2008 R2 ?Step by S...

Install SQL Server 2008 R2 –Step by Step with Screenshots - Step-by-Step procedure for installing a new instance of ... http://ping.fm/jY6Ym

Thursday, October 27, 2011

Fireside Chat with SQL Server Enginee...

Fireside Chat with SQL Server Engineers After 24 Hours of PASS – Thurs, Sept 8, 2011 http://ping.fm/6t204

Thursday, October 13, 2011

SQL Server 2012 - SQL Server 2012 Th...

SQL Server 2012 - SQL Server 2012 Thank you for being part of our SQL Server community and all of your support as w... http://ping.fm/sHK6X

Wednesday, September 28, 2011

What?s new in PowerPivot for Excel wi...

What’s new in PowerPivot for Excel with SQL Server Code Name "Denali" CTP3 http://ping.fm/3dzqH

Monday, September 26, 2011

What?s New for Business Intelligence ...

What’s New for Business Intelligence in SQL Server Denali - Microsoft Next version of SQL Server, code name Denali, ... http://ping.fm/K0gZZ

Sunday, September 25, 2011

Sample SQL Server Developer Resume ? ...

Sample SQL Server Developer Resume – BI - < NAME- DBATAG> PROFESSIONAL SUMMARY: Over 7 years of experience in analyz... http://ping.fm/yBxnr

SQL Server Partial Data backup, a new...

SQL Server Partial Data backup, a new backup type in SQL Server 2005 http://ping.fm/DwRrs

SQL Script to get Backup Information ...

SQL Script to get Backup Information - SQL Script to know when all was last backup was being performed ? SQL Script ... http://ping.fm/Q5vHy

Thursday, September 22, 2011

Schedule Analysis Services Database B...

Schedule Analysis Services Database Back Up - Can we schedule a Analysis Service (OLAP)Database backup ? How to Back... http://ping.fm/VO4u4

Backing Up an Analysis Services Datab...

Backing Up an Analysis Services Database - How to Backup Analysis Services Database ? Backing up Analysis Services d... http://ping.fm/OXKgF

Monday, September 19, 2011

Max Memory setting for SQL Server Ana...

Max Memory setting for SQL Server Analysis Services - Can we set a MAX Memory setting for Microsoft SQL Server Analy... http://ping.fm/Olj0G

SQL Server Analysis Services Authenti...

SQL Server Analysis Services Authentication Modes - Question : Can I have SQL Server Authentication Modes for SQL Se... http://ping.fm/b0C58

Friday, September 16, 2011

StreamInsight 1.2 ? New in SQL Server...

StreamInsight 1.2 – New in SQL Server Code Name "Denali" CTP3 http://ping.fm/4yxtU

Monday, September 12, 2011

SQL SCRIPT to identify Bottleneck / D...

SQL SCRIPT to identify Bottleneck / Diagnostic Information Queries http://ping.fm/9q9mC

Sunday, September 11, 2011

Question & Answer Section ? Beta - It...

Question & Answer Section – Beta - It's my immense pleasure to launch Questions & Answers service at SQL Server Trai... http://ping.fm/B0pyN

Saturday, September 10, 2011

Performance Issue with ACT, should we...

Performance Issue with ACT, should we upgrade to ACT 2011 Premium for better performance ? http://ping.fm/CTDVW

Friday, September 9, 2011

SQL Script to know Temporary Tables a...

SQL Script to know Temporary Tables and Their Size - Check my previous Post How to Optimize tempdb ? , where I have ... http://ping.fm/PcUbP

Saturday, September 3, 2011

SQL Script to get Client Connection D...

SQL Script to get Client Connection Details - Being a DBA, to optimize a performance, at times, you might want to kn... http://ping.fm/aOwNW

Friday, September 2, 2011

Script to Identify worst Performing Q...

Script to Identify worst Performing Queries - Being a DBA, to optimize a performance, a DBA need to know What are mo... http://ping.fm/2vzkD

Tuesday, August 30, 2011

How to Integrate Map with SQL Server ...

How to Integrate Map with SQL Server Reporting Services – Video http://ping.fm/AeivE

Sunday, August 28, 2011

How to test DR if Mirroring is being ...

How to test DR if Mirroring is being used a DR solution? - Testing a DR solution is very critical to ensure DR setup... http://ping.fm/MMidq

SQL Script to Compare SQL Server Sett...

SQL Script to Compare SQL Server Settings - How to Compare SQL Server Settings ? This is pretty simple, we can run s... http://ping.fm/fLzyo

Friday, August 26, 2011

Script to compare object code between...

Script to compare object code between two Production and development databases http://ping.fm/AlG1r

Thursday, August 25, 2011

SQL Script to List all Linked Server ...

SQL Script to List all Linked Server Logins and their properties http://ping.fm/mjGBG

Wednesday, August 24, 2011

Master Data Services ? What?s New in ...

Master Data Services – What’s New in SQL Server Code Name "Denali" CTP3 http://ping.fm/3Kg7K

Tuesday, August 23, 2011

Part 11: Prepare Windows 2008 R2 SP1 ...

Part 11: Prepare Windows 2008 R2 SP1 VHD to boot from windows 7 http://ping.fm/9rzQC

Monday, August 22, 2011

Optimizing SQL Server for Private Clo...

Optimizing SQL Server for Private Cloud (#12) : Manage Private Cloud http://ping.fm/5jJev

Saturday, August 20, 2011

SQL Server Denali Developer Tools Jun...

SQL Server Denali Developer Tools Juneau - SQL Server Denali Developer Tools Juneau En este screencast vemos las me... http://ping.fm/9rbOq

Thursday, August 18, 2011

AlwaysOn ? New in SQL Server Code Nam...

AlwaysOn – New in SQL Server Code Name "Denali" CTP3 - AlwaysOn - New in SQL Server Code Name Denali CTP3 Santosh B... http://ping.fm/3OZ1b

Tuesday, August 16, 2011

Data Quality Services ? What?s new in...

Data Quality Services – What’s new in SQL Server Code Name "Denali" CTP3! http://ping.fm/76jpi

Sunday, August 14, 2011

SQL Server Columnstore Index Performa...

SQL Server Columnstore Index Performance Demonstration - SQL Server Columnstore Index Performance Demonstration Thi... http://ping.fm/lcPmq

Thursday, August 11, 2011

Taking SQL Server Code Name Denali Be...

Taking SQL Server Code Name Denali Beyond Relational in CTP3 http://ping.fm/F7umJ

Wednesday, August 10, 2011

Mejoras de TSQL en SQL Server Denali ...

Mejoras de TSQL en SQL Server Denali - Mejoras de TSQL en SQL Server Denali En este tutorial vemos las mejoras de T... http://ping.fm/b63iH

Tuesday, August 9, 2011

Introduccion a SQL Server Denali - In...

Introduccion a SQL Server Denali - Introduccion a SQL Server Denali En esta presentacin vemos los principales cambi... http://ping.fm/3bUsF

Monday, August 8, 2011

syspolicy_purge_history Job ? Should ...

syspolicy_purge_history Job – Should I delete this ? - I have not created this job named syspolicy_purge_history, wh... http://ping.fm/2n0Dc

Sunday, August 7, 2011

Introduccion a desarollo en SQL Azure...

Introduccion a desarollo en SQL Azure Windows Azure - Introduccion a desarollo en SQL Azure Windows Azure En esta p... http://ping.fm/a9nxP

Create primary and foreign keys SQL A...

Create primary and foreign keys SQL Azure Joins - Create primary and foreign keys SQL Azure Joins www.sqlazuretutor... http://ping.fm/e7Dm2

Thursday, August 4, 2011

Project Apollo ? What?s new in SQL Se...

Project Apollo – What’s new in SQL Server Code Name "Denali" CTP3 http://ping.fm/QF2oN

Wednesday, August 3, 2011

SQL 150 Table Creation, Introduction ...

SQL 150 Table Creation, Introduction or How can I define a data table? http://ping.fm/P7oL4

Thursday, July 28, 2011

PARSE() ? SQL Server Function usage w...

PARSE() – SQL Server Function usage with Screenshot - SQL Server Denali CTP3 has introduces a new function PARSE() t... http://ping.fm/dUn8F

TRY_PARSE() ? SQL Server Function usa...

TRY_PARSE() – SQL Server Function usage with Screenshot - SQL Server Denali CTP3 has introduces a new function TRY_P... http://ping.fm/xK0fG

Wednesday, July 27, 2011

TRY_CONVERT() SQL Server Example ? Sc...

TRY_CONVERT() SQL Server Example – Screenshot - SQL Server Denali CTP3 has introduces a new function TRY_CONVERT() t... http://ping.fm/xgStu

How to use IFF() in SQL Server ? - SQ...

How to use IFF() in SQL Server ? - SQL Server Denali CTP3 has introduces a new function IFF() to evaluates specified... http://ping.fm/wTrSX

SQL Server evaluation period has expi...

SQL Server evaluation period has expired - Today Morning, when I switched my Virtual Machine for Denali CTP1 and I w... http://ping.fm/R4JmQ

SQL Server String function ? FORMAT- ...

SQL Server String function – FORMAT- Denali - SQL Server Denali CTP3 has introduces a new function FORMAT() for form... http://ping.fm/ytYPa

Tuesday, July 26, 2011

Why to use Temporary table over table...

Why to use Temporary table over table variable ? - What are temporary Tables ? Temporary tables are a useful tool in... http://ping.fm/7c1p0

Monday, July 25, 2011

Summary Shot for SQL Server on MSDN a...

Summary Shot for SQL Server on MSDN and Microsoft Forum - Recently SQL Server Forum Support Team has published a boo... http://ping.fm/gV7S8

Friday, July 22, 2011

Strategy to Improve SQL Server Perfor...

Strategy to Improve SQL Server Performance - What Steps / Strategy we should opt to Improve SQL Server Performance ?... http://ping.fm/VPpOs

Thursday, July 21, 2011

SQL Server Integration Services: Merg...

SQL Server Integration Services: Merge Join Transformation - This is a guest post by Girish Khullar, If you want to ... http://ping.fm/Kw6bX

Wednesday, July 20, 2011

What all you need to consider for SQL...

What all you need to consider for SQL Server Hardware Migration? http://ping.fm/y261u

Tuesday, July 19, 2011

What DBA should do after SQL Server 2...

What DBA should do after SQL Server 2008 R2 SP1 and CU1 patch release? http://ping.fm/yA2vk

What DBA should do after SQL Server 2...

What DBA should do after SQL Server 2008 R2 SP1 and CU1 patch release? http://ping.fm/v2YGg

Monday, July 18, 2011

How to check Database Statistics are ...

How to check Database Statistics are optimized for Performance ? http://ping.fm/7Ikjj

NEW Demo for SQL Server Project "Cres...

NEW Demo for SQL Server Project "Crescent" - NEW Demo for SQL Server Project Crescent In this video you will see SQ... http://ping.fm/pULrO

Sunday, July 17, 2011

SQL 148 Database Naming Standards, Ex...

SQL 148 Database Naming Standards, Example 1 - SQL 148 Database Naming Standards, Example 1 Explains database namin... http://ping.fm/gYWlo

How many Non Clustered Index can be c...

How many Non Clustered Index can be created on a single table? http://ping.fm/ETlgV

Saturday, July 16, 2011

How much a SQL Server 2008 R2 License...

How much a SQL Server 2008 R2 License Cost ? - SQL Server Licensing is depends on which edition your are buying and ... http://ping.fm/Hhpu4

Thursday, July 14, 2011

What is Difference between Intel Proc...

What is Difference between Intel Processor Core 2 duo, i3, i5 and i7? http://ping.fm/h8Z1T

SQL Server Denali CTP3 Installation -...

SQL Server Denali CTP3 Installation - SQL Server Denali CTP3 Installation In this video we show the SQL Server Dena... http://ping.fm/7qiZM

(Connection to a SQL Server Table) Mi...

(Connection to a SQL Server Table) Microsoft Office Excel 2007 http://ping.fm/Zcnty

Wednesday, July 13, 2011

Setting up my Personal Desktop for SQ...

Setting up my Personal Desktop for SQL testing - I am frustrated with my DELL LATITUDE laptop (2.5 GHz processor, 4G... http://ping.fm/XIutV

SSWUG.ORG Shorties ? Benefits of Anal...

SSWUG.ORG Shorties – Benefits of Analysis Services Cubes - SSWUG.ORG Shorties - Benefits of Analysis Services Cubes ... http://ping.fm/7b3Ga

Tuesday, July 12, 2011

SQL Server 2012, Denali CTP3 has been...

SQL Server 2012, Denali CTP3 has been been released - Today SQL Server Serve Team has released and it's now availabl... http://ping.fm/g3NMV

Uso de Perspectivas en SQL Server Ana...

Uso de Perspectivas en SQL Server Analisys Services 2008 R2 - Uso de Perspectivas en SQL Server Analisys Services 20... http://ping.fm/9D0Aa

Who?s excited about the next version ...

Who’s excited about the next version of SQL Server??? WE ARE!! http://ping.fm/vP79J

Monday, July 11, 2011

What all Database Permissions are bei...

What all Database Permissions are being assigned to a particular login ? http://ping.fm/eJ8Sj

SSWUG.ORG Shorties ? Overview of SQL ...

SSWUG.ORG Shorties – Overview of SQL Server Clustering - SSWUG.ORG Shorties - Overview of SQL Server Clustering In ... http://ping.fm/vXYxF

Instalaci?e SQL Server PowerPivot ...

Instalación de SQL Server PowerPivot - Instalacin de SQL Server PowerPivot En esta demostracin vemos los pasos nece... http://ping.fm/6HKH2

How to Move SQL Server database files...

How to Move SQL Server database files to other drive ? - This question is being asked by one of the training partici... http://ping.fm/21cAP

Sunday, July 10, 2011

How to TEST SQL Server Storage drives...

How to TEST SQL Server Storage drives ? - How will you check, how your SQL Server Drives are performing ? What is th... http://ping.fm/HFm2r

Saturday, July 9, 2011

SQL Server Data Discover Power Pivot ...

SQL Server Data Discover Power Pivot - SQL Server Data Discover Power Pivot En esta presentacin tcnica hacemos una ... http://ping.fm/Z0LvQ

Friday, July 8, 2011

How to Create Database in SQL Server ...

How to Create Database in SQL Server – Video - Q : How to Create Database in SQL Server ? Creation of database in SQ... http://ping.fm/zSKFh

What Performance counters will you us...

What Performance counters will you use to set up SQL Server baseline ? http://ping.fm/AWTaw

Thursday, July 7, 2011

SQL Server JumpIn! Camp: Wrap-up Vide...

SQL Server JumpIn! Camp: Wrap-up Video! (1 min) - SQL Server JumpIn! Camp: Wrap-up Video! (1 min) The SQL Server Ju... http://ping.fm/FfizB

Friday, May 6, 2011

Export to Excel or CSV using SSIS - I...

Export to Excel or CSV using SSIS - I'm trying to export data from SQL to Excel or even a CSV. The issue I am having... http://ping.fm/94CA5

SQLRally OverDrive Events! - So you'r...

SQLRally OverDrive Events! - So you're going to SQLRally in Orlando next week? Want to take advantage of ALL of the ... http://ping.fm/uTB1b

Guide :: SQL Server Security http://h...

Guide :: SQL Server Security http://ping.fm/TcSnr

Developers? Please love your DBA ? (C...

Developers… Please love your DBA – (Connection Strings) - I've been working alot with Resource Governor for SQL Serv... http://ping.fm/4xMND

Wednesday, May 4, 2011

HOW to use ORDER BY, Group BY and Hav...

HOW to use ORDER BY, Group BY and Having Clause in SQL Query http://ping.fm/PEO5Y

Friday, April 29, 2011

SQL Server 2008 Clustering on Windows...

SQL Server 2008 Clustering on Windows 2008 Video - This is the Complete Video Services for SQL Server 2008 Cluster o... http://ping.fm/ZQrqi

Wednesday, April 27, 2011

How to Pass Microsoft Certification E...

How to Pass Microsoft Certification Exam 70-451 - Once you clear your 70-451 exam then you become a MCITP (Microsoft... http://ping.fm/FixbT

Tutorial di ADO.NET ? Esercitazione: ...

Tutorial di ADO.NET – Esercitazione: creazione di una maschera di login a un database (soluzione) http://ping.fm/HFR9y

Tuesday, April 26, 2011

Introduction to Indexes in SQL Server...

Introduction to Indexes in SQL Server – Beginner - We all understands that Indexes helps SQL Server to retrieve the ... http://ping.fm/F48fJ

Citrix MS SQL Server 2008 R2 Installa...

Citrix MS SQL Server 2008 R2 Installation - Citrix MS SQL Server 2008 R2 Installation Standard Installation von Mic... http://ping.fm/JLozP

Monday, April 25, 2011

IT Change Auditing with NetWrix Chang...

IT Change Auditing with NetWrix Change Reporter Suite - IT Change Auditing with NetWrix Change Reporter Suite NetWr... http://ping.fm/fMXtk

Sunday, April 24, 2011

SQL Server 2008 R2 Service Pack 1 (CT...

SQL Server 2008 R2 Service Pack 1 (CTP) Available - SQL Server 2008 R2 Service Pack 1 CTP(Customer Technology Previe... http://ping.fm/Upwv0

Friday, April 22, 2011

Auto Comment your SQL Script - How ca...

Auto Comment your SQL Script - How can I comment my SQL Script automatically ? One of my friend is working as SQL De... http://ping.fm/M9uXa

Thursday, April 21, 2011

Cumulative Update package 7 for SQL S...

Cumulative Update package 7 for SQL Server 2008 R2 - Cumulative Update package 7 for SQL Server 2008 R2 has been rel... http://ping.fm/ZieRW

Wednesday, April 20, 2011

Cumulative Update package 7 for SQL S...

Cumulative Update package 7 for SQL Server 2008 R2 - Cumulative Update package 7 for SQL Server 2008 R2 has been rel... http://ping.fm/L4fK9

Tuesday, April 19, 2011

SQL Script to find find database obje...

SQL Script to find find database object information - At time we might want to track database objects like what all ... http://ping.fm/gG7WC

Monday, April 18, 2011

SQL Script to track database growth d...

SQL Script to track database growth date and time - A DBA need to plan for database file size and he should ensure a... http://ping.fm/muZGm

Saturday, April 16, 2011

SQL Script to Update Usage for all da...

SQL Script to Update Usage for all databases - Following script will be used to update stats for all databases at on... http://ping.fm/K7cBM

Wednesday, March 30, 2011

HADR Demo Questions - Question: Is th...

HADR Demo Questions - Question: Is the High Performance replica mode available in Denali Standard or is that an Ente... http://ping.fm/1xLHg

Thursday, March 17, 2011

Physical SQL Server Hardware Configur...

Physical SQL Server Hardware Configuration Planning Questionnaire http://ping.fm/Y28Tb

SQL Server High Availability Question...

SQL Server High Availability Questions - Question: How replication set up impacts to application performance ? Answe... http://ping.fm/3LTZQ

Monday, March 14, 2011

SQL Script to find Installed Instance...

SQL Script to find Installed Instances on a server - How many SQL Server Instances are installed on a server? Recent... http://ping.fm/iHRrt

Sunday, February 27, 2011

SQL Script to set up Black Box in SQL...

SQL Script to set up Black Box in SQL Server - Simplest Script to create a quick trace, which will capture all the S... http://ping.fm/iEUnA

Sunday, February 20, 2011

SQL Script to check SQL Server Shared...

SQL Script to check SQL Server Shared Drive Information - In past, I have already posted an Article on SQL Script to... http://ping.fm/Bdpm7

Thursday, February 17, 2011

Querying Data in SQL Server Part 3 - ...

Querying Data in SQL Server Part 3 - Retrieving Record That Match a Pattern While retrieving data you might need to ... http://ping.fm/iIa6l

Wednesday, February 16, 2011

SQL Server 2008 Interview Questions -...

SQL Server 2008 Interview Questions - Question 1 : Which query hint will force query to execute on single CPU? MAXDO... http://ping.fm/qaTn8

Thursday, February 10, 2011

Querying Data in SQL Server Part 2 - ...

Querying Data in SQL Server Part 2 - Calculating column values If you want to do calculations on a column like add, ... http://ping.fm/E46EA

Tuesday, February 8, 2011

SQL Script to Script SQL Server Login...

SQL Script to Script SQL Server Logins - We do have a requirement for server migration. Following Script can help DB... http://ping.fm/k33Le

Monday, February 7, 2011

SQL Script to check blocking and bloc...

SQL Script to check blocking and blocked processes - Following Script will help to know what all processes are block... http://ping.fm/r3bmL

Sunday, February 6, 2011

Querying Data in SQL Server - In this...

Querying Data in SQL Server - In this chapter we will learn how to query a database in SQL Server, I am using sql se... http://ping.fm/nPh51

Friday, February 4, 2011

Script to check when database objects...

Script to check when database objects were they were changed last time http://ping.fm/ANkcJ

Tuesday, February 1, 2011

Script to check SQL Services uptime ...

Script to check SQL Services uptime - Following SQL Script will list down time for SQL Services are running and Cur... http://ping.fm/gdJj2

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