As Microsoft continues to develop and promote their cloud-based SQL services, database administrators will have to become adept at administering their company’s Azure-based assets. If you’re a “reluctant DBA” – someone tasked with managing databases just because you’re “the Microsoft person” in your environment and not because you have any DBA training – Azure can … Continue reading How to Administer a SQL Azure Database?
Tag Archives: DBA
Three Easy Ways to Improve Performance in Any SQL Server Database
The boss is yelling. Users are grumpy. SQL Server’s performance is tanking, and it’s making all of your organization’s line-of-business applications slow. And it’s your problem, just because you’re the “Microsoft person” in your environment. What’s a “reluctant DBA” to do? There are three straightforward things you can do to improve performance on almost any … Continue reading Three Easy Ways to Improve Performance in Any SQL Server Database
3 Tips for Tweaking SQL Server’s SharePoint Performance
If you’re a “reluctant DBA” supporting SQL Server, in an environment that uses SharePoint Server, you may sometimes find yourself wondering how you can get better performance out of the combination. SQL Server is the back-end for SharePoint, so better SQL Server performance equals better SharePoint performance. Of course, you don’t have full control over … Continue reading 3 Tips for Tweaking SQL Server’s SharePoint Performance
What SQL Azure Means for the Reluctant DBA
Fun joke heard at a recent conference: “What color is the sky when you have no clouds? Azure.” Cue big laffs at Microsoft’s expense. The reality, though, is that SQL Azure – the version of SQL Server that lives in Microsoft’s Azure cloud computing service – is a pretty important product. Especially for organizations that … Continue reading What SQL Azure Means for the Reluctant DBA
Moving DTS packages to a SQL Server 2005 Server by Jeff Jones
I have a bunch of DTS packages sitting in the MSDB database on my SQL Server 2000 system. I want to move the packages to my SQL Server 2005 server to continue executing them while I begin the migration. It looks like I need to generate a .dts file from the SQL 2000 MSDB and … Continue reading Moving DTS packages to a SQL Server 2005 Server by Jeff Jones