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)
3,971 reads
2009-12-17 (first published: 2008-07-13)
1,793 reads
2009-04-17 (first published: 2008-10-15)
1,095 reads
2009-04-09 (first published: 2009-03-16)
1,327 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)
970 reads
2008-08-27
1,001 reads
2008-08-20 (first published: 2008-06-19)
1,109 reads
2008-06-20 (first published: 2008-05-11)
1,448 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,486 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,419 reads
Blogs
Continuous integration and delivery (CI/CD) in Azure Data Factory using DevOps and GitHub - Part 2
By Rayis Imayev
(2020-Jan-28) This blog post is a followup to my previous post about DevOps (CI/CD) for...
Extended Events Misperceptions: Profiler is Easier, Part 2
I wrote a short blog post about the misperception that Profiler was easier than...
CREATE TABLE MyTable (Col1 CHARACTER VARYING (50))
If you read the title to this post and your first thought was That’s...
Forums
Tell The Name OF Most Beautiful Places In The World
I am an experienced tourist and always plan for visiting the Most Beautiful Places...
Fastest way to load a CSV file in SQL Server Table
What is the fastest way to load a file in SQL Server Table ?...
Replication question
Im an Oracle DBA by trade and been tasked with setting up transaction replication...
Ask SSC