SSMS 2008 has a nasty little bug that Microsoft doesn’t seem to want to fix until the next major release of SQL Server. Less privileged users cannot see all of the 2005 SQL Server databases and objects in schemas for which are not their default schema. Permissions must be granted on the SQL Server 2005 databases for the users to re-enable something that works just fine in SSMS 2005.
Manage your SQL Server services via Configuration Manager remotely. Never RDP onto a server again just to check which services are installed and how they’re configured.
Has performance of your SQL Server running on a Windows 2003 server just gone south? Poor performance of T-SQL Queries, SSIS slow, linked server queries slow? Were Windows 2003 updates recently applied? Better check your TCP Offload, Receive Side Scaling settings. A real world experience.
SQL Server 2008 SP2 Available for Download at Microsoft.com
This script will not only leverage SQL Server 2005+’s ability to recommend missing indexes, but will give you the create statement to create them.
Quick script to list out all of your published articles for Transaction and Snapshot Replication in SQL Server 2005+.
Have you checked your TempDB data file count and sizes? And moreover, are you monitoring its performance? A general rule of thumb for most DBAs, for best TempDB performance in SQL Server, you should have one TempDB data file for each processor core in your SQL Server and each of those data files should be…
Seems I was quoted in another SSWUG email daily newsletter a while back and missed it myself (I think I was on vacation….)
A recent request from the SSWUG email newsletter asked how we as DBAs approach and handle application/service consolidation on your SQL Server servers. I have a pretty strong feeling and approach to this topic and emailed my experience to SSWUG…..and to my surprise (for the 2nd time I just heard from another DBA friend of…
Download a script to create a SQL Server 2005+ compliant Procedure to return details for long running operations/processes.
Just posting a fantastic resource link today. SQLSecurity.com keeps a nearly always up to date listing, complete with links to KB Articles and the MS product pages, for SQL Server Versions/Builds. This one is my personal favorite of all the SQL Server build lookup pages online.
I finally broke down and decided to open a Twitter account and hope to use it professionally to share SQL Server knowledge. I don’t have enough interesting to follow yet, but I’m hopeful I can find a way to begin leveraging both the blog and the Twitter account to become more involved in the SQL…
Where is the Surface Area Configuration tool go in SQL Server 2008. It’s gone! But wait, there’s another way to satisfy this deep seeded craving of the true SQL DBA.
Looking for a SQL Server Users Group in or near Wichita, KS? Me too. There doesn’t appear to be one any closer than KC. I hope to change that.
Find SQL Server Startup Procedures. SQL Server allows for stored procedures to be executed upon start up, allowing you to set any number of configuration options or start specific traces as soon as SQL starts up. Use this TSQL to locate any existing procedures on your server that are enabled to run at startup.
Wrote a quick fix-it today for changing the owner of a SQL Agent Job from one login to another…..