MSSQL

  We usually export a dataset in SQL Server to Excel instead of CSV. But in some cases we may need to export to csv …

  We can set a session’s language With SET LANGUAGE Command. This command affects the system datetime format and system messages. If you want to …

  One day I opened SSMS (SQL Server Management Studio) and wanted to check the Extended Events Session that captured Timeouts. To find out how …

  We use SUM Function to calculate the sum of values in a column. SUM is a aggregated function and generally we use it with …

  There may be several reasons for this error. A friend of mine said that when he received this error, the database files were deleted. …

  We can concatenate string columns with STRING_AGG function. STRING_AGG function requires 2 argument. Thats why we must put seperater between values. Let’s make examples …

  To move the MSDTC disk to another storage, we need to remove MSDTC from the cluster and then re-add to the cluster. To remove …

We have mentioned the LEAD and LAG functions announced with SQL Server 2012. In this article, we will examine the FIRST_VALUE function. Now let’s look …

As a consultant and training provider in business intelligence projects on SQL Server, some analytic functions I expected to be announced for a long time …

  First, you should request two 5 GB disks from new storage. These 2 disks must be visible to all servers included in the windows …