Currently browsing SQL Server

THE WORLD DISCUSSES #PYTHIAN ON TWITTER. HAVE A QUESTION? USE OUR HASHTAG AND ASK AWAY.

Log Buffer #258, A Carnival of the Vanities for DBAs

Database blogging is more than about announcing that your last night’s backup was successful. While that’s extremely important to keep track of, the database world across Oracle, MySQL, and SQL Server technologies has grown way beyond. This Log Buffer Edition also extends beyond and more in this Log Buffer #258.

Read the rest of this entry . . .

HP Cloud starts to Rain!

So HP Cloud is finally yielding for some beta rain since their announcement late Sep.

It started late September when I signed up for private beta testing. They sent me this when I signed up

Thanks for your interest in HP Cloud Services. We will be sure to follow up with you when access becomes available. Since we’re only accepting a limited number of customers for our private beta based on customer profiles, we cannot guarantee that every request will be accepted.

However, we will review your submission and follow-up with you directly.

Two weeks ago, I got invited to join the beta and start testing the platform. Read the rest of this entry . . .

When DBCC INPUTBUFFER disappoints

Today we have an alert from one of the client server about blocking, I have immediately start looking at it using below statement

SELECT * FROM
MASTER..SYSPROCESSES
WHERE BLOCKED != 0;

Read the rest of this entry . . .

Log Buffer #257, A Carnival of the Vanities for DBAs

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 . . .

Log Buffer #256, A Carnival of the Vanities for DBAs

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 . . .

T-SQL: Retrieve all users and associated roles for ALL databases

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 . . .

Log Buffer #255, A Carnival of the Vanities for DBAs

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 . . .

Log Buffer #254, A Carnival of the Vanities for DBAs

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 . . .

Log Buffer #253, A Carnival of the Vanities for DBAs

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 . . .

Log Buffer #252, A Carnival of the Vanities for DBAs

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 . . .

Start NowWith Pythian - database design, management and emergency handling capabilities...

Live Updates

pythian: RT @pythianfielding: My #ukoug2011 #Exadata IORM presentation starts in a few mins in hall 7A
more



Testimonials

  • Serge Racine

    DBA, Brookfield Energy

    We are very satisfied by the service given to us by Andre and Shakir in support of our recent data quality and reorganization initiative.... more