SQLPSX 1.6.1 Release
I completed a maintenance release of SQL Server PowerShell Extensions, which address all known open issues. This release is still...
2009-09-02
634 reads
Chad Miller
Internet Explorer Automation with WatIN
At my workplace I use an IT Service Desk application, called well, "Service Desk" from CA. The system is web-based...
2009-08-29
2,510 reads
Continuous Integration in a Development Environment using Red Gate Backup and SQL Compare
My co-worker and fellow DBA, Leigh Freijo has a blog entry about a Powershell script he created to re-integrate QA/Development database changes...
2009-08-25
1,105 reads
Tampabay SQL Server User Group Presentation
I presented a one-hour session for Tampabay SQL Server User Group on Powershell and SQL Server. I've previously delivered this session for the...
2009-08-19
829 reads
Installing SQL Server 2008 on Windows 7
When Installing SQL Server 2008 on Windows 7 RTM, I encountered a couple of issues. Supposedly you can install SQL...
2009-08-15
794 reads
ThrowAway Scripts
Although I tend to write a lot of formal scripts, as part of the development process I'll explore an object...
2009-08-12
561 reads
SQLSaturday #16 South Florida Downloads
I presented a 1 hr session at SQL Saturday #16 session PowerShell and SQL Server Administration: In this sesssion we...
2009-08-08
465 reads
SQLSaturday #16 South Florida
I'm giving a presentation at SQLSaturday in South Florida on August 8th 2009. If you haven't been to a SQLSaturday,...
2009-07-27
473 reads
Building PowerShell GUIs with Primal Forms
Although PowerShell is best suited for console applications there are times when a GUI interface just makes sense, however hand cranking...
2009-07-25
4,130 reads
SQL Server Powershell Extensions PowerGUI PowerPack
If you've been working with Powershell, you most certainly have heard of PowerGUI, for those of you who haven't PowerGUI is...
2009-07-24
1,165 reads
Blogs
Database AI Agents: The Read-Only Rule
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
Creating a SQL Stored Procedure to Load a SCD2
By DataOnWheels
This is a blog that I am writing for future me and hopefully it’ll...
Funny Money: #SQLNewBlogger
By Steve Jones
While wandering around the documentation looking for some Question of the Day topics, I...
Forums
Pro SQL Server Internals
Comments posted to this topic are about the item Pro SQL Server Internals
SQL ART: Who's Blocking Who? Visualising SQL Server Blocking With Spatial Geometry
Comments posted to this topic are about the item SQL ART: Who's Blocking Who?...
Running SQLCMD II
Comments posted to this topic are about the item Running SQLCMD II
Question of the Day
Running SQLCMD II
I run this command to start SQLCMD:
sqlcmd -S localhost -E -c "proceed"At the prompt, I type this (the 1> and 2> are prompts):
1> select @@version 2> goWhat happens? See possible answers