Blogs about: Sqlcmd
Featured Blog
SQL SERVER - Change Collation of Database Column - T-SQL Script - Consolidating Collations - Extention Script
This document is created by Brian Cidern, he has written this excellent extension to SQL Expert who SQL SERVER – Change Collation of Database Column – T-SQL Script. His scripts are not only extremely … more →
Journey to SQL Authority with Pinal Dave
SQL SERVER - Change Collation of Database Column - T-SQL Script - Consolidating Collations - Extention Script
pinaldave wrote 1 month ago: This document is created by Brian Cidern, he has written this excellent extension to SQL Expert who … more →
SQLAuthority News - Download IIS Database Manager
— 1 comment
pinaldave wrote 2 months ago: IIS Database Manager allows you to easily manage your local and remote databases from within IIS Man … more →
SQL SERVER - Plan Caching and Schema Change - An Interesting Observation
— 4 comments
pinaldave wrote 2 months ago: Last week, I had published details regarding SQL SERVER – Plan Caching in SQL Server 2008 by Greg Lo … more →
SQL SERVER - Difference between SQL Server Express and MySQL
— 9 comments
pinaldave wrote 2 months ago: Both SQL Server express and MySQL are two of the Relational Database Systems (RDBMS) available today … more →
Revisited: Ola Hallengren's Stored Procedure Based SQL Server Maintenance Solution
— 3 comments
MarlonRibunal wrote 3 months ago: A year ago, Ola Hallengren contacted me and asked if I can post in my blog a link to his home-brewed … more →
SQL SERVER - Difference between Line Feed (\n) and Carriage Return (\r) - T-SQL New Line Char
— 7 comments
pinaldave wrote 5 months ago: Today, we will examine something very simple and very generic that can apply to hordes of programmin … more →
SQLAuthority News - Risk and Health Assessment Program for Microsoft SQL Server – Scoping Tool v1.1
— 2 comments
pinaldave wrote 5 months ago: Risk and Health Assessment Program for Microsoft SQL Server – Scoping Tool v1.1 is a practical downl … more →
SQLAuthority News - Download - SQL Server 2008 Developer Training Kit
— 3 comments
pinaldave wrote 6 months ago: SQL Server 2008 offers an impressive array of capabilities for developers that build upon key innova … more →
Using SQLCMD with SQL Server 2005
tgrignon wrote 7 months ago: Intro You can’t always use a GUI (examples are batch scripts, DAC, etc.) and so MS provides sq … more →
SQL SERVER - Introduction to SQL Server 2008 Profiler
pinaldave wrote 7 months ago: Introduction SQL Server Profiler is a powerful tool that is available with SQL Server since a long t … more →
SQL SERVER - FIX : ERROR : The SQL Server System Configuration Checker cannot be executed due to WMI configuration on the machine Error:2147749896 (0×80041008)
— 3 comments
pinaldave wrote 7 months ago: A couple of days back I had my computer formatted. I reinstalled it with Vista SP1 32bit. Subsequen … more →
SQLAuthority News - Download Microsoft SQL Server Management Pack for Operations Manager 2007
pinaldave wrote 7 months ago: The SQL Server Management Pack provides the capabilities for Operations Manager 2007 to discover SQL … more →
SQL SERVER - Server Type and File Extention
— 3 comments
pinaldave wrote 8 months ago: Owing to my personal experience so far, I can undeniably say that Microsoft Windows products are out … more →
SQL SERVER - 2008 - Management Studio New Features
— 1 comment
pinaldave wrote 8 months ago: Pinalkumar Dave describes the top 5 features of SQL Server Management Studio 2008. This article desc … more →
SQL SERVER - Very Powerful and Feature-Rich Backup, Zip and FTP Utility SQLBackupAndFTP
— 21 comments
pinaldave wrote 8 months ago: It goes without saying that Database Backup is the most important task for any Database Administrato … more →
SQL SERVER - 2008 - IntelliSense Does Not Work - Enable IntelliSense
— 6 comments
pinaldave wrote 8 months ago: While I was working with SQL Server 2008 IntelliSense, I realized that it was not functioning as I e … more →
SQL SERVER - 2008 - Location of Activity Monitor - Where is SQL Serve Activity Monitor Located
— 1 comment
pinaldave wrote 8 months ago: I received question from Aloke Sinha after reading my article SQL SERVER – 2008 – Activi … more →
SQL SERVER - Find All Servers From Local Network - Using sqlcmd - Detect Installed SQL Server on Network
— 8 comments
pinaldave wrote 8 months ago: I recently had requirement to create list of all the SQL Server on local network. I remembered that … more →
SQL SERVER - Practical SQL Server XML: Part One - Query Plan Cache and Cost of Operations in the Cache
— 4 comments
pinaldave wrote 8 months ago: I am very fortunate that I have friends like Michael Coles. Michael Coles is SQL Server and XML expe … more →
