(Pinal Dave) One of the most popular questions any PowerShell expert would receive is how to install the most popular dbatools based on Powershell scripts?
Tag: sql server
Introduction to Azure SQL Database Managed Instances
(John Martin) You have heard about Azure SQL Database Managed Instances, but you are not sure what they are and how you might be able to use them. In this post, I will cover what a Managed Instance is and how it is positioned so that you can look at how you might be able to use it.
How to get the AD groups of a login with sys.login_token
(Jack Vamvas) Question: I’d like to get the list of AD groups of a login currently logged into a SQL Server. I’ve read your post on xp_logininfo limitations – and one of the issues I’m experiencing is that xp_logininfo only returns details from AD global groups not universal groups.
Dynamically Changing A Chart Axis In Power BI Using Bookmarks And Buttons
(Chris Webb) A very common requirement when building Power BI reports is to allow the end user to change what is displayed on a chart axis dynamically. A lot of people have blogged about how to do this – Kasper’s blog post here is a great example – but the problem is that all of these solutions invo
Azure Cosmos DB features, pricing morph with new provisioning model
(Jack Vaughan) Microsoft continues to add Azure Cosmos DB features, including a capability to provision database throughput that creates new pricing considerations for users of the multimodel distributed cloud database.
SQL SERVER – FIX – Error 1402 – Could not Open Key: UNKNOWNComponents – System Error 5 (Another Solution)
(Pinal Dave) I encountered this error while installing KB3045311. In fact, you might get such errors when installing any patch for one of my customers. The error was the very popular system error 5.
Each session should be able to have its own temp table, but there can be problems.
(Kenneth Fisher) You should be able to create a #temp in every session. That’s the idea, right? It’s one of the things that differentiates a global temp table from a local temp table. But there can be some difficulties with that.
Use AU Analyzer for faster, lower cost Data Lake Analytics
(Matthew Hicks) Do you use Data Lake Analytics and wonder how many Analytics Units your jobs should have been assigned? Do you want to see if your job could consume a little less time or money? The recently-announced AU Analyzer tool can help you today!
Using DATABASEPROPERTYEX to Find Last Good DBCC CHECKDB Time
(Thomas LaRock) For decades, a pain point for SQL Server administrators has been determining when the last known DBCC CHECKDB was run against a database. Microsoft has not exposed this information in an easily digestible format.
Troubleshooting SQL Server Database Mail not sending emails
(Jack Vamvas) Question: The Database Mail component is not send emails. The emails are registering – but remain in the “unsent” status.