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
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
via Ping.fm
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
via Ping.fm
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
via Ping.fm
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
via Ping.fm
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
via Ping.fm
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
via Ping.fm
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
via Ping.fm
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
via Ping.fm
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
via Ping.fm
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
via Ping.fm
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
Subscribe to:
Posts (Atom)