Generate SQL script to extract user permissions from a SQL database
When you restore a database, it will also restore all permissions along with it. But what if you are restoring...
2018-04-19
12,389 reads
How to check whether and when sql index statistics were updated last time?
I was working for a client on their very critical and heavily used database. The application was an E-commerce website...
2018-04-19
7,979 reads
How to start SQL Server job using TSQL and wait for it to complete?
If you ever had a need to start a SQL job using sp_start_job stored procedure in msdb then you know...
2018-04-19
15,871 reads
The Prompt Actions Menu
A quick post on SQL Prompt here. Someone is asking about the Prompt Actions menu. This is the menu that...
2018-04-19
996 reads
Overview of SQL Server Backup Types
SQL Server backups, in itself, is a vast subject; so vast, there are multiple books written about them. In this...
2018-04-19
541 reads
Bring Your Own Key to Azure SQL Database TDE
I have previously written about using Transparent Data Encryption (TDE) with Azure Key Vaule as a great way to store...
2018-04-30 (first published: 2018-04-19)
2,116 reads
Power BI Custom Visuals Class (Module 99 – Drill-Down Donut Chart
In this module you will learn how to use the Drill-Down Donut Chart. The Drill-Down Donut Chart allows you to...
2018-05-01 (first published: 2018-04-19)
3,519 reads
Finding Untrusted Foreign Keys and Constraints
In the previous blog, we discussed the Foreign Keys Constraints and how the CHECK Constraints are useful to verify the...
2018-04-30 (first published: 2018-04-19)
3,169 reads
Script to review replications
This script is from my library and I use it to review what is going on with my transactional replications, try to remove statements that didn't get purged for...
2018-04-18
39 reads
Python Jupyter Notebooks in Azure
There’s a new feature in Azure, and I stumbled on it when someone posted a link on Twitter. Apologies, I...
2018-04-27 (first published: 2018-04-18)
3,320 reads
Blogs
Car Update September 2026
By Steve Jones
Software is hard. While I love our Lucid Gravity, I realize that they are...
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,...
Forums
Absolute and Relative References
Comments posted to this topic are about the item Absolute and Relative References
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