Howdy,<BR><BR>Using MS SQL Server.<BR><BR>I've created a stored procedure to handle some things so the program doing the entry can be stupid, which is ideal. The problem is I'm sending table names as ...

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

With the official release of Microsoft's latest database offering, let's see what was improved and what still needs some work ...

SAP has released its November security updates that address multiple security vulnerabilities, including a maximum severity ...

eWeek content and product recommendations are editorially independent. We may make money when you click on links to our partners. Learn More Last September, Errata Security CEO Robert Graham told us ...

Microsoft pulled its SQL Server 2014 Service Pack 1 on Thursday after numerous reports of installation errors. Microsoft said it plans to make SP1 for SQL Server 2014 available again sometime "in the ...

LUMIGENT TECHNOLOGIES ON Monday plans to release Log Explorer Version 3.0, which allows users to identify causes of problems in Microsoft SQL Server databases and recover data. The product uses the ...

Today's DBA is the Sherlock Holmes of IT — always in demand to solve performance mysteries. But even Sherlock needed Watson to do the footwork for him. In the same way, DBAs need smarter tools to keep ...

An announcement last week by Microsoft's Customer Service and Support team indicated that Windows patches from Microsoft's July 10 "update Tuesday" release may have caused SQL Server failures after ...

Microsoft announced this week that it is having problems with ISO releases of SQL Server 2012 Service Pack 2. Service Pack 2 for SQL Server 2012 was released last month. However, there's a problem ...