How Many DBAs Use the Maintenance Plan Wizard/Designer?
Database Administration, Database Maintenance | March 30, 2010 | 2:44 pmWhen I wrote my most recent free eBook, Brad’s Sure Guide to SQL Server Maintenance Plans, some of the DBAs I know asked me why I wrote it. After all, “real” DBAs don’t use the Maintenance Plan Wizard/Designer built into SQL Server 2005/2008 Management Studio (SSMS) to maintain their databases, they write Transact-SQL or ...read more
An Introduction to SQL Server 2008 Audit
Database Administration | | 2:05 pmExcerpted from Brad’s Sure Guide to SQL Server 2008, which is available as a free eBook.
Previous versions of SQL Server have included a variety of built-in ways to audit activity inside SQL Server. These included:
Login Auditing: Only tracks user login successes and/or failures. Results are sent to the OS Application Log.
SQL Server Profiler (SQL Trace) ...read more
SQL Server Social Group a Fresh Perspective on User Group Meetings
Speaking Schedule, User Groups | March 27, 2010 | 7:28 amThe Cam river flows through Cambridge, England. At the center of the river you can see a punt (a type of boat) used to navigate the Cam.
I must have attended at least 25 different SQL Server and .NET user groups over the past couple of years, and most of them have a familiar format: food ...read more
Need to Persuade Your Manager or Co-Worker to Your Point of View?
Books, DBA Career | March 18, 2010 | 11:05 amAt one time or another, each of us has been in a position where we need to persuade a manager, a fellow worker, or anyone for that matter, to our point-of-view. For example, you might want new server hardware, to upgrade an existing instance of SQL Server, the help of a co-worker, or you would ...read more
Want to Learn More About How to Master Microsoft Technologies?
DBA Career | | 10:03 amIf you want to learn more about how to master various Microsoft technologies, visit the website Born to Learn. This website includes blog, forums, and an event calendar to keep you up to date on how Microsoft can help you in your career. While anyone can view the site’s contents, you have to register in ...read more
Start Planning to Attend devLINK 2010
Conferences, Speaking Schedule | March 15, 2010 | 2:24 pmdevLink 2010 will be held in Nashville, TN August 5-7 on Lipscomb University. This three day, 140+ session event costs only $100, and is a great investment in your career. Registration for the event begins April 1, 2010, and you will want to register as soon as possible, as attendance is limited. If you ...read more
PASS European Conference in April
Conferences, PASS, Speaking Schedule | March 11, 2010 | 9:47 amWhile it is probably out of reach for most DBAs in the United States to attend, the PASS European Conference is a great opportunity for those DBAs in Europe, who are unable to attend the PASS Community Summit in United States, to improve their skills and make new contacts within the DBA community.
Keeping Up with PASS
PASS | March 10, 2010 | 9:57 amI have often found it a little hard to keep up with PASS news, but after a little research, I found out that PASS offers many different sources of information about its activities, but it sometimes can be hard to find, as its news and information is dispersed over many different locations. If you ...read more
