The lingua franca of databases, Structured Query Language is ubiquitous, powerful, and important for developers to understand. Start with these tips. Since Structured Query Language was invented in ...

In the several weeks leading up to the PASS Virtual Summit in November, I had the good fortune to work with several members of the SQL Server team at Red Hat. They included people such as Louis ...

New BI and reporting features in SQL Server 2008 R2 hit the mark, but other additions leave SQL Server shops wanting more With Microsoft SQL Server 2008 R2, Microsoft begins to fully realize its ...

Well, in version R2, the tool offers a new way of looking at managing your server databases. Here's what you'll drool over. I've mentioned the SQL Server Utility briefly in past posts, but I want to ...

In the AI era, we're constantly talking about how important data is—storing data, disseminating data, and protecting data. As data specialists, we understand bad data management leads to bad use of AI ...

After all of these years, SQL injection vulnerabilities still stand as an old reliable for attackers seeking to break into corporate databases. "SQL injection is still out there for one simple reason: ...

Stan Sorensen, Director of Product Management, Microsoft SQL Server. REDMOND, Wash., Oct. 10, 2003 — While reporting is a critical part of a company, it has historically not been an easy task.

Other than the slight risk of hitting the max number of databases (32k), what problems are there with having lots of databases in SQL? We've got an off-the-shelf application that adds a database for ...

Tim Kridel is an independent analyst and freelance writer with years of experience in covering technology, telecommunications and more. Just how much does the Department of Defense rely on Microsoft ...

Ok, so my boss wants me to find out about making some log files smaller. For example, one database has a data file that's about 50 MB, and the log file is about 550MB. He wants to clear up space and a ...