Microsoft SQL Server
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.
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
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.
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.
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.
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.
In this post I quickly cover the new features in SQL Server RC0 setup.
In this post I’ll Briefly cover the changes to SQL Server licencing which happened in two areas, edition changes and licensing changes. Lets get started.
ew 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.
Tis the season to be fearless in blogging and read the blogs around the database globe. To make your foray in intrepid world of database blogs, this Log Buffer Edition compiles some of the most interesting posts in this Log Buffer #250.