In this Microsoft SQL Server and JDBC tutorial, you'll learn how to connect to a Microsoft SQL Server in Java using JDBC. The steps are relatively straightforward: Each database is different, so ...

I'm supposed to be a software developer/consultant. However, I'm also the guy people look at when the application isn't running "fast enough." With business applications, speeding up the application ...

While I am a general Linux admin, I have never administered or used PostgreSQL, although I do admin a few MySQL instances. I have just been told that a system currently hosted on SQL Server 2008 R2 is ...

I am getting a lot more unsolicited questions these days such as this one: “My co-workers tell me there is no future for SQL Server DBAs. Will I have a job in the long-term? I’m confused and ...

There are plenty of ways to get the most out of SQL Server without just upgrading to the latest version. For database admins working with older (maybe much older) SQL Server systems, here are four ...

If you are a SQL programmer, learning recursive SQL techniques can be a boon to your productivity. A recursive query is one that refers to itself. I think the best way to quickly grasp the concept of ...

Recently I encountered a problem in a stored procedure that was caused by an unexpected result from the SQL Server ISNUMERIC() function. I was using SQL Server 2008 R2 but the issue has long been ...