Invoke-SqlCmd ist a great cmdlet for PowerShell for querying SQL databases. But sometimes you don’t want to install the extra requirement SQL Server Management Objects on the server.
Invoke-SqlCmd -ServerInstance $Server -Database $Database -Query "SELECT * FROM Staff"
There’s an simple alternative. Use the .NET classes in the System.Data.SqlClient namespace which are available on every computer which has the .NET framework installed.
function SqlQuery($server, $database, $query)
$connection = New-Object System.Data.SqlClient.SqlConnection
$connection.ConnectionString = "Server=$server;Database=$database;Integrated Security=True;"
$command = $connection.CreateCommand()
$command.CommandText = $query
$result = $command.ExecuteReader()
$table = new-object “System.Data.DataTable”
SqlQuery $Server $Database "SELECT * FROM Staff"
window.location = "http://peter-doering.com/mynewurl"
You may want to update the URL after you’ve updated parts of the page with an Ajax call. This would enable the users to share the current page as link or to add an bookmark.
HTML5 introduced a new API for manipulating the browsers history. You can use the pushState()-method to change the current page url without page reload.
history.pushState(null, null, "http://peter-doering.com/mynewurl")
history.pushState(null, null, "http://peter-doering.com?id=1234")
Good News! Some days ago Microsoft published a release candidate of their first update to TFS 2017 (Release Notes).
The very big improvement is the new personal homepage.
If you’re using Visual Studio Online (VSO) in the cloud, you can activate the new homepage by clicking on the preview link.
Have a look at the Work tab. TFS has now an overall report of the open work in all team projects. This is the great new feature we have waited for years. Thank you Microsoft!
Nw you can always keep track of your open work in all projects.