sp_refreshsqlmodule_internal – The user does not have permission to perform this action.
Honestly, I’m only posting this because I had a hard time finding anything posted on this error and I found...
2016-12-28
1,521 reads
Blog Posts
Windows Virtual Accounts and SQL Server
How SQL Server uses Windows Virtual Accounts and local groups
Managed Service Accounts (MSAs) and Virtual Accounts were introduced in Windows...
2016-12-28
2,486 reads
New Formatting in #SQLPrompt
I love SQL Prompt. This might be my favorite tool from Redgate Software and just when I thought it couldn’t...
2016-12-27
675 reads
Query Data Store–SQL Server 2016
SQL Server’s new Query Data Store is a brilliant option for databases if you are a DBA or have to...
2016-12-27
610 reads
Survey Results: Skipping the Holidays
Last week I posted a brief survey about working the holiday. To those who normally are not required to work...
2016-12-27
388 reads
Using Memory Optimized tables for reporting
I recently worked on a project for fraud. This project needed to relate 67 million accounts to one another “Kevin...
2016-12-27
1,311 reads
What keeps clearing my query stats?
I was building out a blog post about cardinality today and noticed that sys.dm_exec_query_stats was getting cleared my my Surface...
2016-12-27 (first published: 2016-12-08)
2,014 reads
A semester’s worth of Backup and Recovery blogs – The TSQL Tuesday 85 Rollup
I was thrilled to host TSQL Tuesday #85, the last TSQL Tuesday of 2016. My subject was backup and recovery...
2016-12-26
474 reads
Query Store- Part 5: Checking forced plans and Query Store Failures
Most of you would know that using query store one can force query plans. Is there a need to check...
2016-12-26
1,898 reads
SQL Server & Containers – Part Four
In this final part of my series on SQL Server & Containers I’ll detail an option to run earlier versions of...
2016-12-26 (first published: 2016-12-07)
2,068 reads
Blogs
Microsoft Tools for Making Data AI-Ready
By James Serra
Making Data AI-Ready, Part 2 (This is the second article in a three-part series...
Local Models Using GPUs with Ollama
By Steve Jones
Can you use your GPUs when running a local model under Ollama? You can,...
Don’t Fear the Technology
By Brian Kelley
The concern that a particular technology is going to destroy the world seems to...
Forums
Moving Beyond the Reboot: Finding the Culprit Behind Memory Pressure
Comments posted to this topic are about the item Moving Beyond the Reboot: Finding...
Reserved Words I
Comments posted to this topic are about the item Reserved Words I