Pragmatic Works Software for MVPs

This is just a quick post to remind folks who are current Microsoft MVPs that Pragmatic Works offers NFR licenses...

The Importance of a SQL Server Inventory

Pop quiz!
It’s time to true-up with Microsoft, what are your current license counts?Operations needs to schedule maintenance on ServerY, what...

Comments on Acceptable Behavior

Here’s the situation. We’re absolutely falling down as men and professionals. Ladies, feel free to read on and comment, but...

Who are the sysadmins in this sql server?

Here’s a quick query that you can run to find out the users with sysadmin fixed server role. Sysadmins have a...

Run SSMS as different Windows user

When connecting to a server from SSMS using Windows Authentication, you are limited to using only user which you used...

Do You Know These Free Events?

I frequently attend a few online training events that greatly help me learn new things. Thought I would share, if may...

Intel Ivy Bridge Release Coverage

Web sites, blogs and media outlets in Europe and the U.K. are starting to post some early Ivy Bridge stories,...

Denali – Blog a Day Series : May, 2012

Denali

 
Microsoft has launches sql server 2012 aka Denali on March, 2012. Free Express and evolution edition for the same is...

Sysprocesses CPU and CPU Percentage - utilization

I am not sure how many of you have faced this situation? I have faced it many many times. Somebody...

SQL Server 2012 Core Factor Table for AMD Processors

As of April 1, 2012, Microsoft has a new SQL Server 2012 Core Factor Table for AMD processors. You can...