Monday, June 27, 2016

Using powershell to call arguments with no spaces

›
Sometimes you have an application (like 7 Zip) that uses command line switches without a space between the switch and the value.  If you...
Tuesday, May 31, 2016

PowerShell exit codes, or "Why does SQL Server think my PowerShell script succeeded?"

›
If you search for PowerShell logging, or PowerShell output, you'll find lots of folks who are frustrated by PowerShell's error handl...
1 comment:

Powershell Invoke-Webrequest error "Internet Explorer engine is not available"

›
We encountered the following error in an SSIS job that launched a PowerShell script, and the job was executing (we thought) successfully.  T...
Thursday, May 5, 2016

Fighting sp_send_dbmail error: "Failed to initialize sqlcmd library with error number -2147467259."

›
We recently encountered a bunch of problems with sp_send_dbmail, and they all returned this: Failed to initialize sqlcmd library with erro...
4 comments:
Thursday, January 29, 2015

Paste SQL (and other) text into OneNote 2013 with syntax highlighting (really)

›
I've been searching for a way to get SQL scripts into OneNote while retaining syntax highlighting from SSMS for a long time now. It...
8 comments:
Wednesday, December 10, 2014

SQL Agent Connection Failure after Cluster Reconfiguration

›
We had some unfortunate event befall one of our SQL clusters lately, and it’s led to some interesting fallout. First, the TempDB LUN was un...
Wednesday, November 12, 2014

Who is using this database? Is it in use at all?

›
This is a question we get as SQL Server DBAs all the time:  is this database in use?  Most of us are in the habit of putting this question b...
Thursday, February 20, 2014

SQL Server Reporting Services Service Start Timeout

›
SSRS will often timeout when starting under Windows Server: The error is:  Windows could not start the SQL Server Reporting Services (MSS...
43 comments:

Creating a Self-Signed SSL Certificate in Windows without IIS (for SSRS, for instance)

›
Sometimes you have need for a SSL certificate on a Windows server when you don't have IIS installed.  Like when you want to install SQL ...
19 comments:
Saturday, November 30, 2013

0x80004005 error when launching Windows Store in Windows 8.1

›
I ran into a problem recently that really had me scratching my head for awhile:  when I launched the Windows Store on Windows 8.1 with a new...
4 comments: