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
630 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,486 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,099 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
823 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
789 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
523 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
456 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
460 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
3,945 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,145 reads
Blogs
How to find free space in Azure PosgreSQL
I wanted to figure out how big (or approximately how big) my dump file...
T-SQL Tuesday #180: Good enough is perfect Roundup
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
Using SQL Compare with Read-only Access
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
Forums
Compare rows within the same table
I have a table. Structure in script below. I have to compare and see...
Microsoft Recommendations for Update Stats?
I have an application team that is insisting on daily (and for some, weekly)...
how can i tell if our db2 driver is ms or ibm or other?
i see this in the definition of a linked server on our wh sql...
Question of the Day
A Strange Result
What does this code return in SSMS 20 from SQL Server 2019?
select '|' + CHAR(0)+'abc' + '|';See possible answers