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
Tags » SQL Server
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
Fresh news from Power BI Designer – the March Update for the Preview is available.
There are some very, very exciting features announced:
- GoogleAnalytics connector… 69 more words
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