Posted by Fahd Mirza on Feb 3, 2012
With new year many new projects, new technologies, new frameworks and new ideas are springing up at the speed of light and bloggers in the database arena are keeping up with this pace and this Log Buffer Edition is also living up to that pace and covers some of those posts in Log Buffer #257.
Read the rest of this entry . . .
Posted by Fahd Mirza on Jan 27, 2012
Searching for the blogging inspiration? On the look-out for that Eureka moment for your next blockbuster blog post? Finding the exact ingredients for your dream rambling? Well in the Log Buffer Edition, there are some awe-inspiring posts in this Log Buffer #256. Get Inspired, keep blogging.
Read the rest of this entry . . .
Posted by Mohammed Mawla on Jan 24, 2012
A frequent inquiry concerning databases’ security is to retrieve the database role(s) associated with each user for auditing or troubleshooting purposes.
Each database user (principal) can be retrieved from sys.database_principals and the associated database roles can be retrieved from sys.database_role_members
The following code runs against ALL the databases using SP_MSForeachdb and all roles for one principal is concatenated in one row Read the rest of this entry . . .
Posted by Fahd Mirza on Jan 20, 2012
With winter and its cold weather starting to set in across most of the world, now is the time when travelers start to think about warming things up. For most, that means flying to hot and sunny destinations. Another way of looking at it, however, is to head out for a different kind of sizzle. There’s perhaps no better way to heat up the chilling months with blogging. Let’s snuggle up in this Log Buffer Edition with hot blog posts in Log Buffer #255.
Read the rest of this entry . . .
Posted by Fahd Mirza on Jan 13, 2012
After having party and festive time during holidays, bloggers are returning with reinvigorated zest and with uplifted zeal and the blogs are sprouting energy and promise. The new year is already here and the blogs across the database rainbow are oozing colors of all kinds. This Log Buffer Edition depicts some of them in Log Buffer #254.
Read the rest of this entry . . .
Posted by Fahd Mirza on Jan 6, 2012
A very very Happy New Year 2012 to all of you. These are the festive and jubilant times when people look back on previous years and make plans for their new year and beyond. Well, this Log Buffer Edition is no different. This week covers the new year posts of the bloggers across the database arena in Log Buffer #253.
Read the rest of this entry . . .
Posted by Fahd Mirza on Dec 30, 2011
As we all look forward eagerly to 2012, bloggers around the gblobe are writing about their insightful reflections on 2011. You’re also welcome to write your’s regarding to database arena in the comments, if you like. This Log Buffer Edition welcomes you to the new year with festive posts from Oracle, SQL Server and MySQL bloggers in Log Buffer #252.
Read the rest of this entry . . .
Posted by Mohammed Mawla on Dec 28, 2011
A DBA is kinda like a chauffeur, he doesn’t own the car but it would be nice to drive one that has Electronic stability control or Anti-lock braking system or airbags, etc…
For SQL server editions, it’s nice to have the Enterprise edition especially with big databases, we can use online index operations, fast recovery, peer to peer transactional replication, partitioning, etc…
Its the same for small databases, less than 10GB, standard/workgroup edition will be better than Express edition since more CPU cores can be used, more RAM can be added, you get SQL server agent, etc… Read the rest of this entry . . .
Posted by Fahd Mirza on Dec 23, 2011
New Year is the time to bid farewell to the old year and welcome the coming year. It is the time to remember the golden olden blog posts. It is the time for new beginnings and new starts in life, and of course for new blog posts. Bloggers in the database arena are also enjoying the festivities with full zeal and zest and this Log Buffer Edition, which is Log Buffer #251 covers just that. Happy Holidays.
Read the rest of this entry . . .