Linked Servers in a sentence or two: Linked servers in SQL Server are connection definitions from one data source to another (or same instance) so that queries can be written joining tables spanning the multiple data sources. Although Linked Servers can be made to other data sources besides SQL Server (as we saw on how … Continue reading SQL Server: Curse Of Linked Server Security And The Fix – Pass-through Authentication
A better Read-Host - by Jeff Hicks Read-Host is very useful but it is too simplistic to write "good" code using it. Jeff Hicks (Twitter: @JeffHicks, Blog: jdhitsolutions.com/blog/) who needs no introductions in the PowerShell world (and whose books I read to learn PowerShell), created a better Read-Host. I love his version. Please checkout the nice … Continue reading PowerShell: Read-Host On Steroids – Enhancements To Jeff Hicks Version
How could such a nice tool have such a terrible choice of colors for errors and warnings? I am talking about the ISE and the unreadable contrast of colors. You can fix it. Open and update your profile by running this from your ISE (which opens your profile in NotePad) notepad $profile Add the above … Continue reading PowerShell – Hate The Error Text And Warning Text Colors? Change It!
In mature IT shops, all deployment scripts in a release are run into the database using command-line batches as opposed to doing it by hand. Error running SQLCMD scripts in SSMS Occasionally, when one is testing a single script within a release to make sure it works, he/she needs to jump to the command line to … Continue reading SQL Server: Run A Script In Command Line Mode (SQLCMD) Inside SQL Server Management Studio (SSMS)