In Houston? Hungry for lunch? Want to learn SQL Server from an expert? Head over to the Microsoft office and learn the top SQL mistakes and how to avoid them from Kevin Kline
Not in Houston? or hungry? there's always the live meeting option!
Here are the details from the HASSUG Site:
The Dedicated Admin Connection, Commonly called the DAC is used to manage SQL Server when a regular connection wont succeed. Here's what SQL Books Online (BOL) has to say about the DAC «This diagnostic connection allows an administrator to access SQL Server to execute diagnostic queries and troubleshoot problems even when SQL Server is not responding to standard connection requests.»
Occasionally, while troubleshooting SQL servers in a large environment, especially one thats managed from many different geographic locations you could come up with this error, if more than 1 person is using the DAC. It should also be noted this only happens if you have remote DAC enabled in your environment
Error 17810
Things are tight
It seems like budgets are being cut everywhere, and IT training seems to be one of the first places cut. In an earlier post I outlined where you could get a lot of valuable training for relatively little cost. In this post I will explore a few methods that have worked for me over the years to get your boss to say YES to paying for you to refresh your fountain of knowledge.
With the economy being what it is, many companies are cutting back on training budgets yet our need for knowledge as database professionals never stops. Luckily the SQL Server community is one of the liveliest around and there are solutions.
I'd estimate that almost everyday of the week you can find live webcasts about various subjects in the SQL Server arena, the problem here is that many of these top quality training events aren't well publicized. I never knew about them until joining Twitter a few years back. As it turns out, many SQL user groups around the world stream their meetings online via live meeting, there are PASS VC's webcasts, Vendor sponsored webcasts, and the list goes on and on.
Local Events
When is high availibility not? When its any version of SQL running on a clustered Windows 2003 Server or sql 2005 running on clustered Windows 2008 Server. Seems that while you can dynamically add a disk and use it in SQL when your running a standalone server, if your running in a «highly availiable» cluster configuration you have to take SQL offline to add the disk as a dependency in order to be able to use it within SQL. Here's the proof right from SQL books online.
Im sure there was a good reason to require this at the time but clearly this wasnt thought out in the grand scheme of taking 0 downtime. Anytime a single server has a more highly availiable architecture than your system that is designed for high availibility -->youre doing it wrong, Sorry someone had to say it
← Previous
01
02
03
Next →
Delicious
Digg
Facebook
Furl
Google Bookmarks
Live Favorites
Magnolia
Reddit
Slashdot
Stumbleupon
Technorati Favorites
Twitter
Yahoo! Buzz
Write a comment
No trackbacks
RSS 2.0
Bloglines
MyYahoo
Netvibes
Newsgator
Rojo