Essential SQL on SQL Server 2008
SQLServ er® database software is one of the most powerful database engines used today. Microsoft’s latest release of SQLServ er, SQLServ er® 2008, is a comprehensive database platform that provides secure and reliable storage for both relational and structured data, enabling one to build and manage high-performance data applications. SQLServ er 2008’s close integration with Microsoft® Visual Studio® development system, Microsoft® Office® system, and a suite of new development tools sets it apart from previous versions and from other database engines.
This system allows one to build, debug, and operate applications faster than ever before. SQLServ er 2008 can be installed on small machines using the Microsoft ® Windows® operating system as well as large servers. In recent years, the computer industry has seen a dramatic increase in the popularity of relational databases and multiuser databases, and there is a great need for application developers and people who can write SQLco de efficiently and correctly for relational and multiuser databases.
Essential SQL on SQL Server 2008
DBA Survivor - Become a Rock Star DBA
Another thing you need to know about being a DBA is that you will have fewer friends at work than when you started. Now, that is not necessarily a bad thing. See, you have been placed into a position of responsibility, and with this responsibility you will need to make some decisions, and those decisions will not always be popular. Thus, you may lose some friends at work, but these losses will be more than offset by the gains you have in the overall DBA community. So you have that going for you, which is nice.
With that responsibility, you will also find that you start getting more blame than credit for your work. I promise you this: no one will ever stop by your desk in the morning and thank you for the fact that everything ran smoothly last night. But you better believe if a batch load took five minutes longer than expected, you will have four different people asking you “WTF?”
DBA Survivor – Become a Rock Star DBA
SQL Puzzles and Answers
Professional SQL Server 2008 Internals and Troubleshooting
WHILE PUTTING TOGETHER THE PROPOSAL that eventually became this book, the aim was to write a
troubleshooting guide that covered the additional tools available from the SQL Server community.
It soon became clear, however, that to effectively talk about the tools, so many digressions were
necessary to explain the results that the fl ow and impact were interrupted. The decision was made
to alter the approach to include architectural information, not just on SQL Server, but on the whole
platform on which SQL Server depends.
Continue Reading »
Professional SQL Server 2008 Internals and Troubleshooting
