Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tags powershell, SQL Rss

   Items 1 to 4 of 4   
 

8 Ways to Export SQL Results To a Text File

This tip will show eight ways to export the results of a query to a text file.  Read more...
By Daniel Calbimonte 2016/10/26 | Source: SQLServerCentral.com | Category: export
Rating: |  Discuss |   Briefcase | 2,906 reads

PowerShell Solutions - Working with files

When we administer a SQL Database, we always have to work with files. This new article shows how to handle them using PowerShell.  Read more...
By Daniel Calbimonte 2016/10/04 | Source: SQLServerCentral.com | Category: copy
Rating: |  Discuss |   Briefcase | 1,575 reads

Using Powershell to run queries on remote server .

This is a function written in powershell , which can used to run queries remotely   Read more...
By himanshu.sinha 2016/07/20 | Source: SQLServerCentral.com | Category: powershell
Rating: (not yet rated) |  Discuss |   Briefcase | 634 reads

Automatically Creating UML Database Diagrams for SQL Server

SQL Server database developers seem reluctant to use diagrams when documenting their databases. It is probably because it has, in the past, been difficult to automatically draw precisely what you want, other than a vast Entity-relationship diagram. However, you can do it without buying any third-party tool, just using some existing Java-based open-source tools; and can even automate it entirely, using SQL and PowerShell. Phil Factor shows how.  Read more...
By Additional Articles 2016/05/27 | Source: SimpleTalk | Category: diagrams
Rating: (not yet rated)  Rate this |   Briefcase | 4,285 reads
   Items 1 to 4 of 4   
 
Tags
server (2)    
ado (1)    
bcp (1)    
c# (1)    
copy (1)    
create (1)    
diagrams (1)    
export (1)    
query (1)    
remote (1)    
smo (1)    
sqlcmd (1)    
text (1)    
uml (1)