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

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

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

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 over two decades of IT experience, Microsoft data platform MVP Thomas LaRock has seen nearly every SQL Server troubleshooting nightmare under the sun. In an upcoming session called "The Top 5 ...

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

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

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 released an emergency update for Windows Server 2022 at the end of last week. It corrects problems with SQL servers. The update with the KB number KB5041054 upgrades the server to build ...

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