Your Friend the Computer
You know it is time to reassess your relationship with
your computer when....
2001-05-28
1,593 reads
Articles
Removing NT Administrators as Sysadmins
By default, all NT administrators of the domain that your SQL Server is installed in, have SA rights in every database. This presents interesting challenge for DBAs, political and technical. Does your NT administrator group need SA rights to every database? The answer is no.
2001-05-25
4,054 reads
2001-05-25
3,985 reads
Quickly Enabling and Disabling Constraints and Triggers
In some cases, you may have to be able to quickly disable all the constraints and triggers in a database. This article shows you how to do this with a few lines of T-SQL.
2001-05-24
9,926 reads
Simplifying Instead Of Triggers
Instead of triggers are a new feature in SQL Server 2000 which greatly extend the functionality of triggers. This article covers a basic introduction to Instead of Triggers and illustrates possibilities for their use.
2001-05-24
8,842 reads
2001-05-23
2,172 reads
Using FileSystemObject with DTS
This article will show you how to use the FileSystemObject to determine the existence of a file inside DTS.
2001-05-23
8,325 reads
SP_MSForeachtable - Life Without Cursors.
Is there such a thing as a task where you would not need a cursor? Hidden in the depths of the master database are a series of stored procedures that can replace some cursors with these one-liners.
2001-05-22
14,191 reads
Standing Back And Looking At Benchmark Results
What do the TPC-C benchmarks mean to the average DBA? In this article, Neil Boyle steps back and looks at them from a practical view.
2001-05-22
5,772 reads
Using DMO to Execute a Job
Using DMO to execute a job is a powerful technique that is easy to apply. This article by Andy Warren has all the code you need to do it!
2001-05-22
5,328 reads
Blogs
Polyglot Persistence
By Steve Jones
I’ve seen the term polyglot persistence floating around Redgate a bit recently in the...
Six Months!
Oh good gosh. Six months without a single blog post. Most important information: I’m...
Speaking at dataMinds Connect 2024
I’m very excited to announce I’ve been selected as a speaker for dataMinds Connect...
Forums
Have you seen this in the news today?
You might want to look into this issue: Windows flaw lets hackers sneak into...
how to find the cpu memory disk and network of the OS where RDS is residing.
hi, i have one RDS, but i do not have any other permissions, and...
“user_scans” of table “sys.dm_db_index_usage_stats”
I am trying to find answer to the below. What exactly the scan means...
Question of the Day
A Lack of Memory Grant Feedback Persistence
SQL Server has added an Intelligent Query Processing feature called Memory Grant Feedback. In SQL Server 2022, this can be persisted across queries to improve the performance of future executions. In SQL Server 2022, when is memory grant feedback not persisted if the plan is evicted from cache? (choose 2)
See possible answers