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

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

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

Database admins are able to find storage performance problems easily using Performance Monitor. But why is it so hard to get storage administrators to find and fix storage performance problems? To ...

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

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

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

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