Are You on Twitter?
Like many busy DBAs, I used to be very dismissive of Twitter. It seemed like a self-indulgent waste of time....
2010-01-28
983 reads
Windows ReadyBoost in Windows 7
Perhaps you heard of or actually tried Windows ReadyBoost in Windows Vista, and were (like me) disappointed with the results?...
2010-01-04
2,795 reads
Fun With DBCC FREEPROCCACHE
Nearly anytime you see the command DBCC FREEPROCCACHE mentioned in a blog post, magazine article or book, you get some...
2009-12-31
15,057 reads
How To Get a Count of SQL Connections BY IP Address
These queries (which work on both SQL Server 2005 and 2008) are very handy if you want to know who...
2009-12-29
3,772 reads
Fun With SQL Azure
Pinal Dave had a helpful post a few days ago about how to setup and configure SQL Azure. You will...
2009-12-08
1,844 reads
SQL Server 2008 Database Mirroring in Action
I have been pretty busy with a server consolidation and move project at work. We had four Dell PowerEdge 6800...
2009-11-17
1,413 reads
New HP Envy 15 Laptop
After quite a bit of research, I pulled the trigger on a new HP Envy 15 system last Saturday. This...
2009-11-13
2,276 reads
SQL Server 2008 Diagnostic Information Queries
Here is the script that I used in my Dr. DMV presentation this afternoon at PASS. It is a set...
2009-11-05
1,355 reads
Suggested Max Memory Settings for SQL Server 2005/2008
It is pretty important to make sure you set the Max Server memory setting for SQL Server 2005/2008 to something...
2009-11-04
3,401 reads
SharePoint 2010 And SQL Server 2008 R2
Lots of interesting news and announcements coming out of the SharePoint 2009 Conference that started today in Las Vegas. Microsoft’s...
2009-10-23
1,608 reads
Blogs
Speaking at SQL Saturday Austin 2025
By Steve Jones
SQL Saturday Austin 2025 is in just a few days. I am honored to...
Updating SSMS is Easy (w/ v21)
By Steve Jones
I’ve been using the SSMS preview for v21. This is the next evolution of...
Execute Fabric Data Pipeline from Azure Data Factory
In the blog post Call a Fabric REST API from Azure Data Factory I...
Forums
The Long Running Backup
Comments posted to this topic are about the item The Long Running Backup
Interview Tips
Comments posted to this topic are about the item Interview Tips
importing from PowerQuery... but with multiple powerqueries
I finally got the PowerQuery source to "show" in SSIS (so I can see...
Question of the Day
The Long Running Backup
I have a long running backup of the Sales database during a maintenance window that is going to take another 2 hours to complete on SQL Server 2022. I also need to perform some proactive work and add another file (ndf) to the Sales database to handle the expected growth of the next month. Can I do both simultaneously?
See possible answers