Granting Permission to Grant Permissions
I’ve never felt the need to allow this, but I saw someone ask the questions recently. Suppose you had a...
2013-02-08 (first published: 2013-01-28)
2,574 reads
"Auto update statistics" option on tempdb
"Auto update statistics" option is enabled by default on tempdb, if it is disabled, you may get trouble in some...
2013-01-28
2,941 reads
New Year Aspirations – Annette Allen – WiT
Thanks for agreeing to do this Annette, with your SQL Saturday event only a few weeks away thing must be...
2013-01-28
939 reads
Last Weeks Top 10 “Reading” Links #17
Throughout the week, I like to tweet links to the things that I’ve been reading. Since they all come out through out...
2013-01-28
974 reads
Changes
Last month I mentioned that I’d like to start including Oracle stuff on this blog. I’m getting back into that...
2013-01-28
710 reads
I’ll Meet You Half Way–Compromising To Win
Compromise is one of those things that makes the world work. I can’t say I’ve always been good at it....
2013-01-28
785 reads
Model database
Most DBAs have at least some idea what the system databases are for. Master has the list of databases & logins,...
2013-01-28
954 reads
SSIS 6 Million Rows in 60 Seconds using standard laptop
SSIS is a very powerful tool and can be very fast however I frequently come across situations where performance could...
2013-02-01 (first published: 2013-01-28)
5,176 reads
How to find and install common IFilters||For Search||Crawl
Friends, As covered in one of my previous blog:
How crawl works in SharePoint ||How indexing work||Basic concept .
We were...
2013-01-28
1,267 reads
Consider All the Possibilities When Troubleshooting
When you are troubleshooting, the rule is if you've checked the obvious possibilities and still haven't solved the problem, it's...
2013-01-28
1,677 reads
Blogs
Architecting Zero Downtime Deployments–Day of Data Boston
By Steve Jones
Here are the resources for my talk at Day of Data Boston. Slides –...
The Book of Redgate:A Prehistory
By Steve Jones
I’ve covered the values in a number of previous posts on the Book of...
Evidence-bound: what AgentDBA will and won’t link
By Arun Sirpal
When the evidence names the database, it says so. When it doesn’t, it stops....
Forums
SQL Server Storage Optimization: Multiple Files in a Filegroup vs Dedicated File
Hello, I would like to get some feedback regarding the best storage optimization strategy...
Azure SQL Database Event Log Limitations
Hi, Do you know if there is a way to get more detailed logging...
Four Rules for Adding AI Without Breaking What Already Works
Comments posted to this topic are about the item Four Rules for Adding AI...
Question of the Day
Hyperscale Replicas III
In an Azure SQL Database Hyperscale Edition, how many named replicas can be configured?
See possible answers