How Do I Move SQL Database Files Around?
Here is a script that will generate a script to move database files around in SQL 2005/2008. Continue reading ?
2010-05-11
23 reads
How Do I Move SQL Database Files Around?
Introduction
Today’s script is one that I had not planned on blogging so soon but since Paul Randal just talked about...
2010-05-11
604 reads
Catching Up
Hey there gang ! – It’s been a while since I’ve written and I apologize. It’s shameful I know. I just completed...
2010-05-10
352 reads
Time Matters: Part 1
If you’re anything like me, you value every second of your day and you constantly try to find new ways...
2010-05-10
462 reads
Finding Enterprise Only Features in Your SQL Server 2008 Database
Microsoft added a new DMV, sys.dm_db_persisted_sku_features to SQL Server 2008 that you can use to determine whether you have any...
2010-05-10
1,158 reads
New Free eBook: Defensive Database Programming with SQL Server
Simple-Talk Publishing has released a new, free 291 page eBook called Defensive Database Programming with SQL Server, by Alex Kuznetsov....
2010-05-10
1,808 reads
Upcoming May SCSUG Meeting
This coming Thursday is the SCSUG meeting. This is no normal meeting. Instead of the standard format of pizza/socialization followed...
2010-05-10
906 reads
PASS Professional Development VC Reboot!
This is just a quick post to let everyone know that this week marks the return of the PASS Professional...
2010-05-10
482 reads
SQLSaturday Summit at the PASS Summit
Now that we’ve moved SQLSaturday to PASS and we’re seeing some really nice growth in the number of events, I...
2010-05-10
498 reads
When was SQL Server last started ?
http://www.sqlservercentral.com/blogs/sqldbauk/archive/2010/04/29/when-was-sql-server-last-restarted_3F00_.aspx
A very good tip from the SQL DBA in the UK!
2010-05-10
519 reads
Blogs
Monday Monitor Tips: Configuring Access to the MCP Server
By Steve Jones
I have been experimenting with MCP servers in a few ways, including the Redgate...
The GO Barrier: Why SSMS Multi-Server Query Waits for the Slowest Connection
By Zikato
I deployed a schema change to 30 servers using multi-server query and deploy-at-low-priority. Small...
10 Things I Hate About Fabric Deployment Pipelines— And Some Alternatives
Fabric deployment pipelines look like they solve CI/CD for Fabric content, especially for people...
Forums
A Challenge of Our Knowledge
Comments posted to this topic are about the item A Challenge of Our Knowledge
The memory toll of VARCHAR(MAX) in SQL Server
Comments posted to this topic are about the item The memory toll of VARCHAR(MAX)...
Transaction Log Truncation
Comments posted to this topic are about the item Transaction Log Truncation
Question of the Day
Transaction Log Truncation
In SQL Server 2025, where can I find information about items that prevent or delay the transaction log truncation?
See possible answers