How to list all CLR objects inside your database?
I wrote the following query that returns the list of all CLR functions/procedures/objects exists inside your database:
SELECT o.object_id AS [Object_ID]
...
2012-08-12
1,304 reads
Basit Aalishan Masood-Al-Farooq
Using a Dedicated Administrator Connection (DAC) on SQL Server
Dedicated Administrator Connection (DAC) allows administrators emergency access to SQL Server via SQL Server Management Studio (SSMS) or via command...
2012-08-09
1,486 reads
Recovering from out-of-disk space conditions for tempdb
Another potential problem that you need to tackle as a DBA is running out of disk space on the hard...
2012-08-06
3,248 reads
Creating and Managing User-Defined Roles in SQL Server 2012
SQL Server 2012 introduces user-defined server roles. These user-defined server roles are similar to fixed server roles with only difference...
2012-08-02
2,866 reads
Performing Unattended Installs of SQL Server 2012
In my post here, I’ve discussed the procedure to perform attended installation of SQL Server 2012 on a Windows Server...
2012-08-02
9,864 reads
How to move master and resource system databases?
I received an phone call from a friend today asking how to move master and resource system databases in Microsoft...
2012-07-29
6,874 reads
Different techniques to identify blocking in SQL Server
SQL Server is able to service requests from a large number of concurrent users. When SQL Server is servicing requests...
2012-07-27
1,587 reads
Retrieving Deadlock Graphs with Event Notification
Checkout my article (i.e. Retrieving Deadlock Graphs with Event Notification) that is published on SSWUG.org. This article shows the steps...
2012-07-26
2,918 reads
Transact-SQL Script to Monitor Replication Status
Today, I’ve written the following T-SQL script which you can use to monitor the status of transactional replication and performance...
2012-07-25
7,019 reads
Process to truncate transaction log of replicated database
This article demonstrated the steps which you must follow to gracefully truncate the publisher database transaction log file by resetting replication.
2012-07-24
11,647 reads
Blogs
Finding Balance: Things Will Come Up
By Steve Jones
I have a presentation on finding balance in your career that got quite a...
Who Are You Doing It For?
By Brian Kelley
But as I've matured over the years, I came to realize that I needed...
Presenting Twice in May 2026
By alevyinroc
I will be presenting my latest session, Documenting Your Work for Worry-Free Vacations, in-person...
Forums
Radius Latitude Longitude
I have a table with latitude longitude in the format. 45.123456 , -111.123456 ,...
degree of parallelism
Team, I'm trying to figure out what will be the best recommendation to configure...
A Fun Computer Quote
Comments posted to this topic are about the item A Fun Computer Quote
Question of the Day
A Fun Computer Quote
Which movie featured this quote?
"All programs have a desire to be useful."Happy April Fools! See possible answers