(Thomas LaRock) “Too many secrets.” – Martin Bishop One of the pivotal moments in the movie Sneakers is when Martin Bishop realizes that they have a device that can break any encryption methodology in the world.
Tag: sql server
Introduction to Azure SQL Database Hyperscale
(Marcin Policht) Since its inception, the Azure SQL Database offering has been evolving in order to accommodate a wide range of needs of its customers.
SQL SERVER – Optimize Key Lookup by Creating Index with Include Columns
(Pinal Dave) I love query tuning and performance tuning projects. In one of the recent Comprehensive Database Performance Health Check my client had a very interesting scenario where their queries were running pretty fast earlier but gradually started to run slow and eventually started to take over
Azure SQL Database – Fixing My Scaling Failure
(blobeater) This is kind of a follow up from my last blog post about a scale down request issue. (https://blobeater.blog/2018/11/07/azure-sql-database-aborting-scale-request/) I was confused, so confused that I ended up logging a support request with Microsoft.
Using OpenApi.Document() To Create A Power BI Custom Connector For The Power BI REST API
(Chris Webb) The idea of creating a Power BI custom connector for the Power BI REST API is not a new one: Miguel Escobar wrote one earlier this year (see here for the source code and documentation).
Query Store and Plan Cache Plans Compared
(Grant Fritchey) Query Store plans and the plans in cache are identical, right? There won’t be differences because the plan that is in cache is the plan that was used to execute the query.
Monitor Database Offline Events
(Jason Brimhall) The other day, I shared an article showing how to audit database offline events via the default trace.
Graph database implementation with Azure Cosmos DB using the API
(Prashanth Jayaram) In my previous article, I’ve discussed a lot about the Graph database implementation with SQL Server 2017. In this case, we’ll see a walk-through of Graph API integration with Azure Cosmos DB.
SQL SERVER – Steps to Change IP Address of SQL Server Failover Cluster Instance
(Pinal Dave) There have been many questions in my mailbox asking about exact steps to change the windows cluster and SQL failover cluster IP address to the new VLAN.
How to Pass Data Between SQL Server Agent Job Steps
(Jeffrey Yao) From time to time, there may arise a business requirement that in a SQL Server Agent Job, we want to pass a parameter value or multiple values from step 1 to step 2.
