HackerRank isn’t just a random collection of problems; they’ve organized their SQL section pretty well. You can find ...

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

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

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

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

I currently produce a data file on an AS400 for use in a SQL 2000 database.<BR><BR>I use the CPYTOIMPF command to produce a file from a query. I then copy it to a PC directory using the CPYTOPCD ...

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

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

If you haven't installed SQL Server 2014 Service Pack 1, keep it that way. If you have installed the service pack, you may be regretting it. Microsoft pulled it last week after install errors surfaced ...