Lock escalation : SQL Server 2008
Lock escalation is a event which occurs when SQL Server decides to upgrade a lock at a lower level hierarchy...
2010-11-29
1,339 reads
Determining An Enterprise Execution Policy Setting
Windows PowerShell has the concept of execution policy that determines in which cases script and configuration files are able to...
2010-11-28
2,376 reads
New Domain - My blog has a new domain name gethynellis.com
About a year ago I started to write a blog, previously to that, for about three years I had been...
2010-11-28
629 reads
SQL Server 2008 R2 Best Practices Analyzer
A big part of my DBA career has centered around identifying and sharing SQL Server DBA best practices. There are...
2010-11-27
2,661 reads
Do You Protect Your Passwords?
Protect Your Password! As a consultant, I am frequently receiving new passwords at clients and becoming aware of the password...
2010-11-26
680 reads
Book Review - The Checklist Manifesto
Andy Warren recommended The Checklist Manifesto to me and after seeing his review, I decided to grab it. It’s written...
2010-11-26
1,853 reads
What Am I Thankful For
Earlier this week, I suggested that we share a message of thanks on our blogs. Since I suggested we put...
2010-11-26
979 reads
Leading the Albanian PASS Chapter
Yesterday, I have received the official email from the PASS HQ, and the confirmation that now I'm the leader of...
2010-11-25
825 reads
SSIS Denali Annotations
I have written a couple quick blogs recently sharing some of the new usability changes for SSIS in Denali.In previous...
2010-11-24
673 reads
How Do I Change SSRS Report Credentials with Powershell?
Today’s script took a long time to write. The concepts are fairly simple and the resulting script is quite trivial...
2010-11-24
7,212 reads
Blogs
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....
Prep data for AI vs. Fabric Data Agent Instructions: What Goes Where?
By James Serra
Making Data AI-Ready, Part 3 (This is the final article in a three-part series...
Forums
A design question in a parent child relationship
I am not sure which is the best way to proceed. I have parent...
Hyperscale Replicas III
Comments posted to this topic are about the item Hyperscale Replicas III
Development Is Fun
Comments posted to this topic are about the item Development Is Fun
Question of the Day
Hyperscale Replicas III
In an Azure SQL Database Hyperscale Edition, how many named replicas can be configured?
See possible answers