Profile

Cover photo
Lane Duncan
56 followers|1,126,046 views
AboutPostsPhotosVideos

Stream

Lane Duncan

Shared publicly  - 
 
Using SSRS ReportServer database in SQL Multi-Subnet Availability Group
Using SSRS report data sources on a SQL Availability Group that is behind a multi-subnet listener is supported, and it mostly works.  Having the SSRS ReportServer database on a multi-subnet AG, however, isn't supported, as detailed here .  To wit: The use o...
Using SSRS report data sources on a SQL Availability Group that is behind a multi-subnet listener is supported, and it mostly works. Having the SSRS ReportServer database on a multi-subnet AG, however, isn't supported, as de...
1
Add a comment...

Lane Duncan

Shared publicly  - 
 
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 handling and logging capabilities. It turns out, they're pretty robust, but because PowerShell has separate error and standard out...
1
Add a comment...

Lane Duncan

Shared publicly  - 
 
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 error number -2147467259. Super irritating, that error, because it seems to suggest that you're doing something you're not....
1
Add a comment...

Lane Duncan

Shared publicly  - 
 
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 unpresented accidentally during some SAN maintenance.  As I’m not a SAN admin, I’m not y...
1
Add a comment...

Lane Duncan

Shared publicly  - 
 
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 (MSSQLSERVER) service on local computer.  Error 1053:  The service did not respond to the start or control request in a time...
1
Add a comment...

Lane Duncan

Shared publicly  - 
 
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 user, the store itself failed with an error.  The error message in the Store app read, "We weren't able to connect t...
1
Add a comment...
Have him in circles
56 people
Tim McDonough's profile photo
Brandon Rasley's profile photo
Joseph Good's profile photo
Gene Scruggs's profile photo
Emma Duncan's profile photo
sree prasad's profile photo
Jim A's profile photo
Sasidhar Bellamkonda's profile photo
Dale Ellis's profile photo

Communities

Lane Duncan

Shared publicly  - 
 
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're using a variable for the value, sometimes PowerShell won't parse the values out right, so the thing will fail. In thi...
1
Add a comment...

Lane Duncan

Shared publicly  - 
 
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.  There was, though, zero output.  A couple of things going on here, then. First, the error: The response content cannot...
1
Add a comment...

Lane Duncan

Shared publicly  - 
 
Paste SQL (and other) text into OneNote 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's seems unnecessarily hard: OneNote doesn't support RTF-formatted text from the clipboard, which shouldn't be a problem, si...
1
Add a comment...

Lane Duncan

Shared publicly  - 
 
I'm sure going to try to get back to posting more frequently. Here's the latest on using extended events to check for user database activity.
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 back on the application owners, or of using a simple scream test to see if it’s import...
1
Add a comment...

Lane Duncan

Shared publicly  - 
 
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 Server Reporting Services (SSRS). You could use OpenSSL, or download the 1+GB Windows SDK to get the makecert utility .  ...
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 Server Reporting Services (SSRS). You could use OpenSSL, or download the 1+GB Windows SDK...
1
Add a comment...

Lane Duncan

Shared publicly  - 
 
Scripting SQL Server Error Log Location in TSQL Queries
While it's possible to view the SQL Server error log location in the SSMS GUI, sometimes you want to build a script that'll write a log t...
1
Add a comment...
People
Have him in circles
56 people
Tim McDonough's profile photo
Brandon Rasley's profile photo
Joseph Good's profile photo
Gene Scruggs's profile photo
Emma Duncan's profile photo
sree prasad's profile photo
Jim A's profile photo
Sasidhar Bellamkonda's profile photo
Dale Ellis's profile photo
Communities
Basic Information
Gender
Male