It is important to understand, that the DBA’s work is barely limited only to the mere database performance… . . . → Read More: Some tools of the trade and why a DBA should know more
|
|||||
|
Recently I read Brent Ozar’s post about SQL Server’s flaws and a part of that post impressed me so much that I had to comment. First, here is the excerpt, and then there is a short note to Brent. 3. Database Diagrams. In SSMS, when you drill into a database, the very top thing is “Database Diagrams.” . . . → Read More: Borrowed post: 5 things SQL Server should truncate NOTE: do NOT run the code in this example unless you are sure what it does. Make sure you understand the parameters of the command and make sure you limit the processes you will terminate only to the ones which should be terminated! As a DBA sometimes I run programmatically multiple processes of the same kind, and . . . → Read More: How to terminate processes in Windows A new security layer for SQL Server is proposed and discussed in the SQL Server circles: the security layer is called “Do you know me?” and consists of a simple pop-up screen whenever the SSMS is opened. The pop-up screen displays a random question with multiple answers and unless the user answers the question correctly, the . . . → Read More: New proposed security layer for SQL Server  4 comments  IT, Installation, Jokes, Performance, SQLServer, Security, T-SQL  2005, 2008, 2011, layer, Security, SQL Server, SSMS Once again, sharing is how technology goes forward. If it wasn’t for the sharing… . . . → Read More: … and best things are (almost) free (?)!!!  |
 |
||||
|
Copyright © 2010 Feodor Georgiev's blog - All Rights Reserved |
|||||
|
|
|||||
