Security and Permissions presentation from the Baton Rouge SQL Server User Group Meeting, 3/14/2012
Last night I presented a new presentation I'm working to add to my inventory, SQL Server Permission and Security. This...
2012-03-15
570 reads
Last night I presented a new presentation I'm working to add to my inventory, SQL Server Permission and Security. This...
2012-03-15
570 reads
Deleting duplicate rows out of a table can be tricky. A brute force way to do this is with a...
2012-02-28 (first published: 2012-02-21)
4,220 reads
Here's a script from my toolbox I use to find dependencies between SQL objects. The where clause has a number...
2012-02-21
1,035 reads
"Cannot alter a server audit from a user database. This operation must be performed in the master database."
If you're trying...
2012-02-03
1,058 reads
Sent: Friday, January 20, 2012 10:30 AM
To: William Assaf
Subject: dba has a questionWilliam,
Can you send me references to support my contention that NOLOCK...
2012-01-24 (first published: 2012-01-21)
3,868 reads
Got stored procedure problems? I feel sorry for you son.
Here's a quick query to pull the cached execution plan out...
2011-12-16
1,693 reads
This news may be a few months old, but it is worth noting that there is now a column called...
2011-12-16
1,384 reads
A query that calls sys.dm_exec_requests and pulls the statement text out of the request is a handy script for any DBA's...
2011-10-19
3,148 reads
Here's my official blog page for my presentation on SQL Server Admin Best Practices with DMV's from the Houston TechFest...
2011-10-15
921 reads
One of the things I run into every now and then is this provincial idea that reports can and should...
2011-10-10
1,297 reads
By Steve Jones
SQL Bits 2025 was amazing, as always. It’s been my favorite conference to attend,...
By Rohit Garg
As data becomes the backbone of modern business, understanding how to manage and analyze...
Here’s how these tools can make Kubernetes security easier and help you avoid common...
Comments posted to this topic are about the item The Hidden Cost of MAXDOP:...
Comments posted to this topic are about the item The Hidden Cost of MAXDOP:...
Comments posted to this topic are about the item Using Heaps
When does Microsoft recommend using a heap as a table structure (no clustered index)?
See possible answers