Moving data in and out of SQL Server is a fundamental task for any developer or DBA. Chad Miller brings us a new way that we can load Powershell output into a SQL Server database.
2011-05-13 (first published: 2008-12-16)
29,678 reads
I was recently asked a question on restoring a database using PowerShell with the following requirements
Take a database backup file...
2011-03-16
2,581 reads
SQL Server PowerShell Extensions (SQLPSX) includes a set of function for working with SSIS which among other things allow you...
2011-02-07
3,226 reads
The best new management feature added to SQL Server 2008 is Policy Based Management or PBM. PBM allows DBAs to...
2010-12-30
1,727 reads
For years we’ve been told you should use Enterprise Manager in SQL Server 2000 or SQL Server Configuration Manager in...
2010-12-13
3,196 reads
Windows PowerShell has the concept of execution policy that determines in which cases script and configuration files are able to...
2010-11-30
1,310 reads
In this two part blog post we will demonstrate how to query an Oracle database from Powershell. Before we can...
2010-03-04
2,943 reads
In part one we installed and configured the Oracle client software, in this post we will query an Oracle database...
2010-03-04
2,472 reads
The over-reliance on a familiar tool is best described with the quote, “if all you have is hammer, everything looks...
2010-02-23
4,134 reads
As many of you know the system stored procedure sp_validatelogins is used for finding invalid logins. Although sp_validatelogins is useful there's...
2010-01-19
2,220 reads
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
System-versioned temporal tables were introduced in SQL Server 2016. They provide information about data...
By Steve Jones
Another post for me that is simple and hopefully serves as an example for...
We are currently on SQL server SP1. Should we go ahead and apply SP2? ...
Hi there I would like to cast a NVARCHAR(MAX) variable string to an XML...
Hello sql server reporting 2019, i created temp for 180 days and not sure...
Ask SSC