Blog Stats
- 192,310 hits
-
Prashanth Jayaram
I’m a Database technologist having 11+ years of rich, hands-on experience on Database technologies. I am Microsoft Certified Professional and backed with a Degree in Master of Computer Application. My expertise lies in T-SQL programming, Replication and PowerShell You can connect me via https://social.technet.microsoft.com/profile/prashanth jayaram/ http://www.sqlshack.com/author/prashanth/ https://www.tumblr.com/blog/prashantjayaram http://www.sqlservercentral.com/blogs/powersql-by-prashanth-jayaram/ http://www.toadworld.com/members/prashanthjayaram/ My Articles are published in following sites http://www.ssas-info.com/analysis-services-articles/ http://db-pub.com/ http://www.sswug.org/sswugresearch/community/
Personal Links
Verified Services
-
DZone MVB
-
Microsoft
Archives
- September 2017 (2)
- August 2017 (3)
- July 2017 (3)
- June 2017 (3)
- May 2017 (3)
- April 2017 (1)
- March 2017 (4)
- February 2017 (1)
- January 2017 (3)
- December 2016 (1)
- November 2016 (2)
- October 2016 (2)
- September 2016 (2)
- August 2016 (3)
- July 2016 (6)
- June 2016 (2)
- May 2016 (9)
- April 2016 (12)
- March 2016 (4)
- February 2016 (2)
- January 2016 (6)
- December 2015 (2)
- August 2015 (1)
- March 2015 (3)
- February 2015 (3)
- January 2015 (5)
- December 2014 (4)
- November 2014 (3)
- October 2014 (1)
- September 2014 (1)
- August 2014 (1)
- July 2014 (1)
- June 2014 (1)
- May 2014 (2)
- April 2014 (4)
- March 2014 (4)
- February 2014 (5)
- January 2014 (8)
- December 2013 (2)
- November 2013 (1)
- October 2013 (2)
- September 2013 (6)
- August 2013 (5)
- July 2013 (6)
- June 2013 (6)
- May 2013 (9)
- April 2013 (16)
Top Posts & Pages
- PowerShell - Find OS architecture (32 bit or 64 bit) of local or remote machines Using Powershell
- SSAS - Find Cube Database Name, Size,Status and Total Size of SSAS Server
- MongoDB - Insert,Update,Upsert and Delete Examples - CRUD
- T-SQL - Read CSV files using OpenRowSet
- SQL Server : Could not load file or assembly 'Microsoft.SqlServer.BatchParser, Version=10.0.0.0
- The RPC server is unavailable. (Exception from HRESULT: 0x800706BA)
- How to Replace Multiple Strings in a File using PowerShell
- SQL Server DB Migration – Cloning a database to another collation
- T-SQL - Find Number of Rows of Database(s) tables Using Undocumented Procedure - sp_MSforeachdb and sp_MSforeachtable
- Planning a SQL Server Backup and Restore strategy in a multi-server environment using PowerShell and T-SQL
Categories
- AlwaysOn (1)
- Backup and Restore (5)
- Citrix (1)
- databases_files (2)
- Exchange (2)
- FileProperty (1)
- GENERAL (3)
- JSON (4)
- MongoDB (16)
- NoSQL (1)
- Philosophy (1)
- PowerShell (61)
- Python (1)
- Robocopy (2)
- SCCM (1)
- Security (2)
- SETVAR (2)
- sp_msforeachDB (1)
- sp_MSforeachtable (1)
- SQL (75)
- SQL 2012 (4)
- SQL 2016 (7)
- SQL 2017 on Linux (1)
- SQL AZURE (1)
- SQL Indexes (1)
- SQL Server 2017 (6)
- SQL Server Backup (1)
- SQL Server vNext (2)
- SQL XML (1)
- SQLCMD (3)
- SSAS (4)
- SSRS (3)
- String handling (1)
- sysfiles (3)
- T-SQL (31)
- Uncategorized (33)
- Variable Passing (1)
- XenApp VDA (1)
- XenDesktop VDA (1)
- XML (1)
- Follow Prashanth Jayaram on WordPress.com
- The Big DaySeptember 21st, 2017The big day is here.
- The Big DayOctober 25th, 2016The big day is here.
Category Archives: SQLCMD
SQL Server: Monitoring Disk Space with FSUTIL command line utility
Table of Contents Introduction Pre-requisites Data flow Enable xp_cmdshell Download SQL Code Output Conclusion References See Also Introduction This article talks about one of SQL method to fetch the disk usage details and use of T-SQL in conjunction with invoking … Continue reading
Posted in SQL, SQLCMD, Uncategorized
Tagged FSUTIL Examples, FSUTIL FSINFO, xp_cmdshell examples
Leave a comment
SQLCMD – Database Backup and Restore – Automation – Quickest and Simplest method
In today’s world we rely more on third party tools to do a Backup and Restore of databases. Most of us still use SQL Native method to do a Database Backup and Restoration. This post illustrates the quickest way of … Continue reading
Posted in Backup and Restore, Robocopy, SETVAR, SQL, SQLCMD, Uncategorized
Tagged Backup and Restore, Robocopy, SERVERPROPERTY, SQLCMD
7 Comments
SQLCMD –Quick Copy of Files – Using Robocopy
The requirement is to move the files to different server programatically and hence I’ve decided to use Robocopy in SQLCMD. Robocopy is a command line utility. It has been available as part of the windows resource kit and It’s one of … Continue reading
Posted in Robocopy, SETVAR, SQLCMD, T-SQL
Tagged Robocopy, SQLCMD, Sqlcmd variables and exmples
3 Comments
