Browse by Tags

All Tags » Support (RSS)
There is so much out in the cosmos for helping with the manageability of SQL Server, this particular download from Microsoft is the early concept that later became the Management Data Warehouse in SQL Server 2008 which frankly is way cool. Anyway - this...
Quite a lot to cover in 45 minutes but my plan is to overview the areas in demo and a one slider and then attack each area from the beginning of October in more detail on LiveMeeting - going to sort the dates over the weekend. Here is the new abstract...
Don't forget this Wednesdays user group at Microsoft in Reading, please visit http://sqlserverfaq.com?eid=169 to register; briefly we have Clive Challinor, SQL Core Escalation Engineer and Daniel Sol, SQL Server Technical Support Engineer talking...
Thanks to Vicki Collins for this technical rollup; some interesting stuff to check out... News Microsoft Releases SQL Server 2008 Service Pack 1 Microsoft has released SQL Server 2008 Service Pack 1 with enhancements meant to ease deployment but no brand...
If you want to see how far along your restore or backup is then you can do this... select percent_complete from sys . dm_exec_requests where session_id = 53 This is in addition to the STATS = n option on the BACKUP/RESTORE commands.
Posted by tonyrogerson | 1 comment(s)
Filed under: ,
The first in my live meeting series was on SQL Server Basics - Part 1 : An introduction to the SQL Server toolset. The recording is available here: http://sqlserverfaq.com/livemeetings/sqlfaq_20090528_tonyrogerson_sqlserverbasics_tools.zip I pretty much...
Oh man, this has haunted me - when working away I VPN and remote onto my workstation at my home office and then go out to clients from there - nice and secure and allows me to keep sessions on a stable link rather than 3g or slower adsl. Every now and...
Posted by tonyrogerson | with no comments
Filed under:
When you can buy a 1TB Serial Attached SCSI (SAS) drive for just £142.22 ex VAT you just have to get 2 of them. Ok, so its just 7200rpm but do I care? Not a jot; its for my server here with just myself using it. Outside of me, and to my clients - this...
I'm giving a Full Day Seminar on the 12th September at the University of Hertfordshire which is just north of London. For full information see: http://www.sql-server.co.uk/train20080912/default.htm This is targetted for people new to SQL Server or...
Posted by tonyrogerson | with no comments
If like me you spend the majority of your life remote desktoping to various servers you should know that as of Vista SP1 the /console switch no longer gets you to the Console session on the server - you need to use the /admin switch instead; apparently...
Posted by tonyrogerson | with no comments
Filed under: