Profile

Cover photo
Lane Duncan
51 followers|851,625 views
AboutPostsPhotosVideos

Stream

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...

Lane Duncan

Shared publicly  - 
 
Thus begins the zombie apocalypse.
MIAMI (Reuters) - A Miami police officer shot and killed a naked man found chewing on another man's face on an exit ramp of a major causeway, local media reported on Sunday. The incident occurred ...
1
Add a comment...
Have him in circles
51 people
José Manuel Calvar González's profile photo
Curt Herridge's profile photo
Pete Wann's profile photo
Kamlesh Patidar's profile photo
Gene Scruggs's profile photo
Gene Roberts's profile photo
Pete Wann's profile photo
Jim Youmans's profile photo
Медик СРК's profile photo

Communities

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...

Lane Duncan

Shared publicly  - 
 
Executing SQL Server Batch Statements Within One Exec(sql) Call
Sometimes you'll run into a situation where you want to script a series of SQL batch statements dynamically.  For instance, you might wan...
1
Add a comment...

Lane Duncan

Shared publicly  - 
1
Gene Roberts's profile photoLane Duncan's profile photo
2 comments
 
Ha!  You're a funny man.
Add a comment...
People
Have him in circles
51 people
José Manuel Calvar González's profile photo
Curt Herridge's profile photo
Pete Wann's profile photo
Kamlesh Patidar's profile photo
Gene Scruggs's profile photo
Gene Roberts's profile photo
Pete Wann's profile photo
Jim Youmans's profile photo
Медик СРК's profile photo
Communities
Basic Information
Gender
Male