Who did what?
This select will show the last sql statement for every open session plus many helpfull information.
2012-01-13 (first published: 2008-03-04)
4,187 reads
- Interests: MusiC (Heavy Metal), basket ball
2009-12-17 (first published: 2008-07-13)
1,847 reads
2009-04-17 (first published: 2008-10-15)
1,103 reads
2009-04-09 (first published: 2009-03-16)
1,375 reads
Get DBMail information
get the profile name and the account name etc about the dbmails created on the server
2008-09-12 (first published: 2008-07-13)
988 reads
2008-08-27
1,018 reads
2008-08-20 (first published: 2008-06-19)
1,120 reads
2008-06-20 (first published: 2008-05-11)
1,462 reads
Script permissions on all databases
i took the core from a script found in the site for generating permissions and update it.
2008-05-06 (first published: 2008-03-06)
3,559 reads
space check
When run it will check the space left on the disk. If it was under 4GB it will raiserror.
2008-05-05 (first published: 2008-03-04)
1,437 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