Performance Tunning -Checklist
continue with performace tunning stuff, I would like to make a checklist (kind of) for general performance tunning or dba...
2010-05-06
1,135 reads
Viewing the results before and after, during Update
DBAs & Developers using everyday UPDATE statement, and everytime before update they want to see what to update, after this they...
2010-05-06
3,507 reads
Using CPU-Z to Discover Hardware Information
I think it is very important to be able to discover exactly what type of hardware is in an existing...
2010-05-05
1,009 reads
New SQL Server Standard: Resource Governor by Roy Ernest
The latest issue of the SQL Server Standard is available for download (login required, free registration). Volume 7 Issue 4...
2010-05-05
740 reads
American Express PASS Card (Not What You Think)
Had logged in to American Express check my business account and noticed this on on the front page – a PASS...
2010-05-05
587 reads
SQL Server Integrity Checks – DBCC CHECKDB
I like to run integrity checks against my databases very regularly, sometimes daily if I can get away with it....
2010-05-05
2,186 reads
SQL 2005 TableSpace
In the first post of this series I highlighted and described two stored procedures that are shipped from Microsoft. These...
2010-05-05
4,714 reads
Review: SSD Tweaker
Ran across this while doing some other reading, SSD Tweaker lets you change a few settings that are supposed to...
2010-05-05
577 reads
Getting a Page of Results
The other day I was looking over a couple of articles on paging, looking to see if I could learn...
2010-05-05
412 reads
Winner of the April SQL Aloha Contest
This month’s question had 28 responses, and as usual, I found it difficult to select a winner because all of...
2010-05-05
496 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