(blobeater) Getting straight to the point, I initiated a very common task recently, another scale up request.

(Greg Larsen) If you have been coding TSQL for a while you probable are familiar and frustrated with this error message:

(Jack Vamvas) Question : An error message has started appearing in the SQL Server Error Logs during a nightly full backup.

(Grant Fritchey) I’m going to start with a sentence that makes a lot of people crazy; As a DBA and database developer, I love Entity Framework.

(Prashanth Jayaram) Data growth has raised the stakes in the market increasing the size of SQL Server estates that DBAs are expected to manage. Because of this, fast and efficient configuration management can be very helpful.

(Jason Brimhall) Whether it is for a client, an audit, or just for good housekeeping, DBAs will often need to figure out who has access to what. In addition, they may need to know by what means people have access within your databases.

(Kenneth Fisher) Indexes are probably the number one tool we have to improve performance. That said, there are times when we want to put that index on hold.

(Jack Vamvas) Question: I’m trying to execute a batch script which includes a SQLCMD

(Rajendra Gupta) This article will discuss SQL Server FILESTREAM including installation, configuration, enabling and general considerations.

(Pinal Dave) Sometimes, I get some quick questions via my blog comments and I do spend the time to search on them and reply or write a blog. In this blog we would learn how to fix: Msg 9514 – XML data type is not supported in distributed queries.