How to Recover a SQL Server Login Password
I will describe a simple method anyone can use to obtain lost password information for a SQL Server login.
2017-02-21 (first published: 2013-03-04)
64,202 reads
Geoff Albin
- Interests: running
How to Receive Alerts When You Centralize Your SQL Server Event Logs
Learn how you can get alerts when you centralize the Event log. This is part 2 of the previous article "How to centralize your SQL Server Event Logs."
2014-05-09 (first published: 2012-05-24)
7,398 reads
How to centralize your SQL Server Event Logs
Learn how you can centralize the Event log data for your servers using a process that Geoff Albin has been using for over 10 years.
2014-05-02 (first published: 2010-11-08)
13,931 reads
How to receive Deadlock information automatically via email
Receive Deadlock info from the SQL Error Log every time a deadlock occurs.
2014-01-03 (first published: 2010-12-13)
54,481 reads
How to Monitor for High CPU utilization in SQL Server
This is the method that Geoff Albin has used for years to monitor the CPU on his SQL Servers.
2012-10-19 (first published: 2010-11-17)
29,961 reads
Blogs
A New Word: Immerensis
By Steve Jones
immerensis – n. the maddening inability to understand the reasons why someone loves you...
Deploy a Dockerized Python TODO App to Azure Container Apps Using Pulumi and Azure Key Vault
In this post, I will guide you on how to deploy a dockerized simple...
Using a Local Large Language Model (LLM): Running Ollama on Your Laptop
You can now run powerful LLMs like Llama 3.1 directly on your laptop using...
Forums
SQL Server is terminating in response to a 'stop' request from Service error
Dear All, In one of the server its repeatedly restarting sqlserver services and not...
Understanding CROSS APPLY and OUTER APPLY in SQL Server
Comments posted to this topic are about the item Understanding CROSS APPLY and OUTER...
Database Files on Shares I
Comments posted to this topic are about the item Database Files on Shares I
Question of the Day
Database Files on Shares I
I want to store database files on a file share for a SQL Server 2017 instance. Can I use \\fileserver\D$ as a location?
See possible answers