(Alejandro Cobar) As SQL Server DBAs, we can all agree that backups are essential and must be managed properly so that we can be able to recover from any disaster scenario. However, there are some cases where having the backup file is simply just not enough because you might not know how much disk s
Tag: sql server
SQL SERVER – Why Server Authentication is Disabled? What Mode is SQL Server Using Currently?
(Pinal Dave) Sometimes I see weird issues with SQL Servers, and it helps me in understanding how the software works. In this blog, I would share my learning about the cause of Server Authentication mode disabled. If it is disabled, how would you know what mode is used by SQL Server?
Power BI Q&A Linguistic Schema
(Scott Murray) What options are available to manually set the Power BI Q & A settings?
Power BI, HTTP/2, Internet Explorer 11 And Older Versions Of Windows
(Chris Webb) A very quick performance tip: do you have users consuming Power BI reports with Internet Explorer 11 and an older Windows OS like Windows 8.1 or Windows 7?
SQL SERVER – LogonUserExEx Fails for User & GetToken – Logging on as the CNO Failed With Error 1326
(Pinal Dave) SQL Always-On feature is so tied to cluster that sometimes you would need to look at various logs to fix a failure. In this blog I would share my learning about fixing error LogonUserExEx fails for user & GetToken – Logging on as the CNO failed with error 1326.
Containers and DevOps
(Grant Fritchey) Over the last couple of years, one of these single most exciting technologies to come out around the Data Platform has been containers. You may not see them change your production setup.
How to create a PSCredential object
(Jack Vamvas) Creating a Credential Object is useful when you require to pass a username and password through Powershell commands.
Move SQL Reporting Services to Another Server
(Joe Gavin) You need to migrate a SQL Server Reporting Services (SSRS) Native Mode environment installed on one server and move it all to another server. Check out this tip to learn the steps.
Why you should never use default string lengths.
(Kenneth Fisher) TL;DR; You probably don’t know what you’re going to get.
SQL SERVER – PolyBase Error Msg 46530 – External Data Sources Are Not Supported With Type GENERIC
(Pinal Dave) While trying to try PolyBase on my laptop, I was getting an error. When I looked further, the solution was so different and the error message has no relation to it.