Question: What mechanism allows SQL Server 2008 to commit transactions on the mirror faster than SQL Server 2005?
This question was...
2009-05-13
1,656 reads
Suggested Reading: Microsoft SQL Server 2008 Administration with Windows PowerShell
My earliest forays into writing powershell for SQL Server found me...
2009-04-30
2,262 reads
Have you ever wished that creating a backup on the fly was easier and quicker? Whether you do it with the GUI or with T-SQL, you still have to open up Management Studio, connect to the database, and go through the steps. You have to figure out ...
2009-04-29
4,263 reads
Behind Every Great Restore is a Great Backup
I showed you how to do a database backup with powershell a few...
2009-04-22
2,512 reads
I Need a Backup ... And I Need It Now
Have you ever wished that creating a backup on the fly was...
2009-04-18
3,495 reads
Fully qualified domain name that is. One of the little gotchas I encountered when rewriting my database mirroring automation scripts in powershell was that there is no simple way to get the SQL Server's fully qualified domain name. I didn't want to...
2009-04-16
3,677 reads
What's my name?
Fully qualified domain name that is. One of the little gotchas I encountered when rewriting my database mirroring...
2009-04-11
9,354 reads
A Port, a Port! My Kingdom for a Port!!
One of the steps in setting up database mirroring is to assign...
2009-04-09
1,059 reads
Coming Soon: Pro SQL Server 2008 Mirroring
Pro SQL Server 2008 Mirroring will be the first book dedicated to the subject...
2009-03-29
2,111 reads
Do You Support the Ancient Ones?
Are you still supporting SQL Server 2000? How about 7.0 or 6.5?
Officially, Microsoft support has...
2009-03-29
2,223 reads
By Steve Jones
AI is a big deal in 2026, and at Redgate, we’re experimenting with how...
By Steve Jones
Another of our values: The facing page has this quote: “We admire people who...
By Ed Elliott
Running tSQLt unit tests is great from Visual Studio but my development workflow...
Comments posted to this topic are about the item No Defaults Passwords Ever
Hi, We have low latency high volume system. I have a table having 3...
Comments posted to this topic are about the item The Long Name
I run this code to create a table:
When I check the length, I get these results:
A table name is limited to 128 characters. How does this work?