Tags » SQL Server

SQL SERVER - System procedures to know SQL Server Version

There are several ways to know the version of SQL Server. But did you know that there are two system procedures through which you can know the version? 102 more words

SQL Authority

SQL Server Query Optimizer - when joins are ignored

The query optimizer in SQL Server is very powerful and smart – provided you give it enough information and clues to do its job.  One recent discovery caught me by surprise – the fact that SQL Server can skip performing joins altogether in certain scenarios. 491 more words

SQL Server

Check Disk Offset using Powershell

Quick script to make sure your disk partitions are properly aligned for a sql server installation. Read this article for disk partition best practices as to why you should always ensure that your offset is correctly set. 41 more words

SQL Server

PowerBI Designer Preview March Update is Available!

Fresh news from Power BI Designer – the March Update for the Preview is available.

There are some very, very exciting features announced:

SQL Server

SQL Server Service Accounts

I’m reading through the third chapter of the 70-462 Administering Microsoft SQL Server Databases training kit and encountering a lot of references to SQL Server Service Accounts. 413 more words

SQL Server

Filegroups - Piecemeal Restores

This is an extension to my partial restores blog, the difference is, with this example I will bring up Filegroups in an online fashion, thus users can access that Filegroup while I bring up others. 369 more words

SQL SERVER

SPN Registration Failure Issue

While I was configuring my lab machine, I observed the SPN registration was failed on one of my server with the below error.

The SQL Server Network Interface library could not register the Service Principal Name (SPN) [ MSSQLSvc/KRISHNA02.SKGLAB.LOCAL ] for the SQL Server service. 374 more words

SQL Server