(Manoj Pandey) Yesterday I was having a discussion with one of the Analyst regarding an item we were going to ship in the release.

(Derik Hammer) The standard backup strategy seems to always include backups running at midnight, hoping that they complete before anyone starts using the applications. There is value in performing maintenance on off-hours.

(Jack Vamvas) Question: When executing a statement through SSMS returning a large recordset , I’m getting a System.OutOfMemoryException error. The error occurs before the recordset fully returns. Why is this error occurring and what is the workaround?

(Sergey Gigoyan) Any SQL Server database developer knows that NULL does not mean 0 or an empty string, it means that the value is unknown. The result of a straightforward comparison with NULL is unknown, so special instructions are required (IS NULL, COALESCE, NULLIF, etc.) to get the desired correc

(Rajendra Gupta) Currently we don’t have any functionality to check for consistency errors in SQL Server Analysis Services (SSAS) databases, cubes or partitions. SQL Server 2016 solves this problem by introducing database consistency checks (DBCC) commands for SQL Server Analysis Services.

(Pinal Dave) You need to know SQL Server basics to keep database performance at the highest level. This knowledge will also help you to be prepared to any potential problems.

(Nakul Vachhrajani) Most development environments that I have worked in have a developer edition of Microsoft SQL Server on the local machine of the developer. Hence, both the client (SSMS) and the database server are often on the same machine.

(Mark Broadbent) Performing database and transaction log backups (and restores) are the meat and veg of a DBA’s responsibilities and if you are a seasoned professional I am sure you will have performed those operations ad-infinitum.

(Ryan Adams) Have you ever seen the error below in your SQL Server log shortly after startup? You’ll actually see two of them and you can see the difference between them in the screen shot, but here is the text.

(Dallas Snider) When I process my neural network data mining model in SQL Server Analysis Services (SSAS), I get the following messages in my Process Progress window.