Why Are There So Many Editions?
SQL Server has grown from two editions in the v6.5 days to 7 with SQL Server 2008. Why are there so many editions? Steve Jones gives his thoughts.
Can you shrink your transaction log files to death?
can undermine server performance. An expert runs various tests to determine how transaction log file size responds to various T-SQL commands.
Database Mirroring FAQ: Can a 2008 SQL instance be used as the witness for a 2005 database mirroring setup?
Question: Can a 2008 SQL instance be used as the witness for a 2005 database mirroring setup? This question was sent to me via email. My reply follows. Can a 2008 SQL instance be used as the witness for a 2005 database mirroring setup? Databases to be mirrored are currently running on 2005 SQL instances but will be upgraded to 2008 SQL in the near future.
Do You Verify Your Database Backups?
Backup verification is a vital part of a well-designed database maintenance plan and yet some DBAs neglect to do it. Brad McGehee ownders why.
Do You Verify Your Database Backups?
Backup verification is a vital part of a well-designed database maintenance plan and yet some DBAs neglect to do it. Brad McGehee ownders why.
Why Are There So Many Editions?
SQL Server has grown from two editions in the v6.5 days to 7 with SQL Server 2008. Why are there so many editions? Steve Jones gives his thoughts.
Why Are There So Many Editions?
SQL Server has grown from two editions in the v6.5 days to 7 with SQL Server 2008. Why are there so many editions? Steve Jones gives his thoughts.
Why Are There So Many Editions?
SQL Server has grown from two editions in the v6.5 days to 7 with SQL Server 2008. Why are there so many editions? Steve Jones gives his thoughts.
Another Reason to Avoid Cross-Database Ownership Chaining
This past weekend we were moving database files around because we added new LUNs to an existing production cluster. We went at the old tried and true way, we detached the databases, moved the files, and re-attached the databases. That seemed to work well...
Introduction to Windows PowerShell for the SQL Server DBA Part 1
I have been hearing about Microsoft's scripting language called Windows PowerShell which is extensively used nowdays for administering and managing Windows servers and workstations. Exchange Server 2007 and Windows Server 2008 are just two of the Microsoft server products that have included this as part of their administrative tools. I want to know how Windows PowerShell can help me as a SQL Server DBA.
Blogs
PlanTrace Now Supports PostgreSQL
PlanTrace Now Supports PostgreSQL The same plan analysis you know from...
A New Word: the Kinder Surprise
By Steve Jones
the kinder surprise – . the point in your early adolescence when you realize...
Crash-Consistent Snapshot Cloning - Hyper-V Edition
If you’ve been following my T-SQL Snapshot Backup series, most of what I’ve covered...
Forums
The New Wave of Security Threats
Comments posted to this topic are about the item The New Wave of Security...
There's Too Much to Learn
Comments posted to this topic are about the item There's Too Much to Learn
How to Calculate Distance Between Coordinates in SQL Server
Comments posted to this topic are about the item How to Calculate Distance Between...
Question of the Day
SSoL Support on the OS
On which Linux versions is SQL Server 2025 on Linux supported?
See possible answers