(Jack Vamvas) A common problem faced by SQL server administrators is the unexpectedly large size to which transaction log files often grow. Large transaction log files pose many problems to the server itself such as sluggish performance, threat of data corruption, server downtime and server inaccess

(Scott Murray) In SQL Server Reporting Services, how can I format a partial section of a text box or separate a text box in parts or placeholders?

(Paul White) I have previously written about the benefits of using NOEXPAND hints, even in Enterprise Edition. The details are all in the linked article, but to summarize briefly:

(Pinal Dave) I know from my personal experience that many SQL Server novice users have issues while uploading and downloading data in various formats. In my practice, this kind of tasks arise very often. I would prefer to automate the process for the recurrent tasks, if the file structure is not goi

(Daniel Farina) You have to troubleshoot a SQL Server session that is taking longer than normal to complete. In this tip I will show a new SQL Server 2016 Dynamic Management View that will make it easier to understand how time is spent for the session being analyzed.

(Denny Cherry) Recently I was trying to make a drive bigger on an Azure VM by simply using Set-AzureOSDisk PowerShell commandlet (and the -ResizedSizeInGB switch). The problem is that this command is asynchronous meaning that it tells you that it’s done, even if it hasn’t finished yet.

(Jack Vamvas) In acceptance tests for migrating database servers from Physical Servers to Virtual Servers, one of the grey areas is the ESX host and the memory balloon.

(Pinal Dave) Recently in my trip to US for SQLPass, I had a unique opportunity to meet a number of attendees for my session. The session was well received and I got some great feedbacks. I loved the recent trip and it was a great experience for me to learn and prepare for the session.

(Arshad Ali) SQL Server is one of the most widely used RDBMS around the world, and one of the facts of this wide adoption comes from Microsoft’s commitment to add new capabilities to cater to the need of the changing landscape year over year.

(Chris Bell) Setting up SQL Server Agent to automate jobs and alerts is a great idea.