February 2010 - Posts

• Using Windows Authentication from a non-domain joined machine

  Sometimes it is necessary to use Windows domain credentials to authenticate with a SQL Server from a non-domain joined machine. Here’s a trick from my coworker Martin Kastenbaum to pass Windows domain credentials from a non-domain joined machine. You Read More... Posted Friday, February 26, 2010 6:28 PM by John Paul Cook | 25 Comments

• ODBC Multiplatform Survey - Microsoft needs your input

  This is from Chris Lee, Senior Program Manager for SQL Connectivity at Microsoft: The Microsoft SQL Server Connectivity team has received feedback indicating interest in ODBC support for non-Windows platforms and is now conducting a more detailed survey Read More... Posted Tuesday, February 23, 2010 8:21 PM by John Paul Cook | 0 Comments

• Don’t take the SSMS login for granted!

  My boss couldn’t login using SSMS after he told me to drop a database no longer in use. It was easy to fix. Think about it – he could login before the database was dropped, but not after. It was his default database. When your default database does not Read More... Posted Friday, February 12, 2010 9:24 PM by John Paul Cook | 0 Comments

• SQL Heartbeat – my favorite free tool

  There are many great scripts available for monitoring SQL Server. But admit it, don’t you miss animation and color? I’ve been using SQL Heartbeat for about two weeks and I really appreciate the animation and color. These features make the output highly Read More... Posted Thursday, February 11, 2010 9:16 PM by John Paul Cook | 8 Comments

• SQL Search - free tool for searching your SQL Server

  I downloaded Red Gate's new free utility SQL Search http://www.red-gate.com/products/SQL_Search/index.htm earlier this week. A coworker just asked me if there is an easy way to search all stored procedures for a specific string. SQL Search was the answer! Read More... Posted Thursday, February 11, 2010 11:52 AM by John Paul Cook | 6 Comments