How It Works: SQL Server I/O Presentation by Bob Dorr

Once upon a time, in a server farm far far away… enough talk. I was researching some warning messages on my SQL boxes and came to this 2010 paper by one of the  Microsoft Customer Service and Support (CSS) SQL Support team members. It is a really great presentation about SQL Server IO needs and, well, how it works.

Read it, read it, read it.

ok, now cya!

Posted in SQLServer, Windows | Tagged , , , , | Leave a comment

Tips for Exam 70-462: make your labs using Azure trial

The complexity of certification exams is climbing up lately – up to the clouds. Gone are the days where a simple 3 VM lab was enough to try out every new tech release to newer versions of some product – SQL Server in this case.

Read it, do it. Practice, practice, practice. You can even try some PowerShell on this setup.


You can try this too: (I will do it myself later).

You can always go the DIY route and use VMs on your home computer, but it is good to get a feeling for administering something in the cloud – there are clouds everywhere lately, really.

PS: but I will do it in my home too, of course, so I won’t loose my setup in case of rain…

Posted in Cloud, SQLServer, VMware, Windows | Tagged , , , , , | 1 Comment

MS SQL: New ways to test disk performance

Sometimes things get easier, better or simples. Actually we became spoiled to expect this kind of evolution from everything in the world, and this is not always the case. But sometimes it is. Jokes aside, a while ago I opted for simpler tools to do performance tests that are easier to translate into real-world examples, and recently one of these tools has got a revamp in functionality and this new and updated version is worth testing.

The tool is CrystalDiskMark, wich has been updated in version 4 to use a new framework to do it’s testing (Microsoft DiskSpd).

It’s good to be able to keep it simple, but if we need anything more detailed you can also go directly to the bones of it and use the new DiskSpd directly and with more control. This is a great article that I wanted to share with you, please take your time to read it and apply it to your database servers:



Posted in SQLServer, Windows | Tagged , , , | Leave a comment

Get all job steps in SQL Server


You never know when you will need to get all the jobs steps in a hurry. This is a great script for this situation.

Originally posted on Sufian's Diary:

Someday you might need to see the steps of any specific job or find in which step of which job does a specific query is used. Confused!

Following query will show you all the steps of a specific job having a specific query in any of its steps.

FROM Msdb.dbo.SysJobs JOB
INNER JOIN Msdb.dbo.SysJobSteps STEP ON STEP.Job_Id = JOB.Job_Id
WHERE JOB.Enabled = 1
AND (JOB.Name = ‘%Job_Name%’ OR STEP.COMMAND LIKE ‘%Exec AnotherStoredProcedure%’)

View original

Posted in Uncategorized | Leave a comment

New year, new post, new MongoDB

Everytime I think of MongoDB I remember Sheldon Cooper playing Bongo on TBBT tv series. Just for fun, because of the sound of the words.

But to start a new year nothing better than a new DB system. Please take a look at the announcement page for MongoDB 3.0.

PS: this image did not scale well… what an irony!


Posted in Uncategorized | Leave a comment

Last post of the year: SQL Server 2014 Checklist for Performance

I would like to share these kind of things directly from SqlServerCentral, and not only posting links. But linking seems the best way to do it currently. Also I decided to increase that post count to 20 (yea, the yearly stats are post #19). Just for the fun of it :)

Be sure to read these quick tips (and discuss in the forums) because it may help you more than you can imagine. This is a greate piece by Rudy Panigas.

I would like to add two little tips:

  • Keep your app data on a single database. Cross-database queries are bad.
  • Forget that Linked-Servers exist. Use other technology instead.

cya all next year!!!

Posted in SQLServer | Tagged , , | Leave a comment

2014 in review

The stats helper monkeys prepared a 2014 annual report for this blog. (They did not have much work, only 18 posts this year. Gotta increase that number.)

Here's an excerpt:

The Louvre Museum has 8.5 million visitors per year. This blog was viewed about 90,000 times in 2014. If it were an exhibit at the Louvre Museum, it would take about 4 days for that many people to see it.

Click here to see the complete report.

Posted in Uncategorized | Leave a comment

SQL Server: Service Packs and Database Mirroring

Usually the Mirroring feature of SQL Server is pretty resilient to random failures at several parts of the link between the two servers. It is so resilient because it uses only built-in features that are not affected by the outside world – so you can boot your servers, cut and reconect the link, do a lot of stuff and the database will still resume mirroring once everything is good again.

But a Service Pack is something that messes with those built-in SQL features, so this can definetily mess up with your mirroring session. Please be safe and perform these kinds of upgrades gracefully. Kinda, like reading this link: .

Because if you fail to do so, you may end with two suspended databases. And in this case you will have to take all your servers down, upgrade them all to the same SP level, restart them all, make use of the three little commands noted below, and pray for the database god/goddess/entity to resume your mirroring session. If everything goes fine, you will see your mirroring session back to “Synchonized” state.

See, I can not guarantee that this will work. But, you know, mirroring is resilient.


Edit: I though about creating a new post just to show how resilient Database Mirroring is. But instead I will just do this quick note: even if your mirror server runs out of space, Mirroring will be able to resume as soon as you add some space. You may see the event below in your mirror instance, so be sure to keep an eye open for it (this could cause your main DB Log file too grow a lot too, so you have two symptoms for this situation).

Error: 1454, Severity: 16, State: 1.
Database mirroring will be suspended. Server instance 'YOUR_SERVER' encountered error 5149, state 3, severity 16 when it was acting as a mirroring partner for database 'YOUR_BASE'. The database mirroring partners might try to recover automatically from the error and resume the mirroring session. For more information, view the error log for additional error messages.
Database mirroring is inactive for database 'YOUR_BASE'. This is an informational message only. No user action is required.
Bypassing recovery for database 'YOUR_BASE' because it is marked as a mirror database, which cannot be recovered. This is an informational message only. No user action is required.

To fix it, simply expand the data disks on your mirror server (I’m assuming you know how to do this, since you are reading this kind of article) and issue the command “ALTER DATABASE SET PARTNER RESUME”. Let the Mirroring magic happen, et voilà, database synchronized again.


Posted in Uncategorized | Leave a comment

Free Microsoft exams: get your voucher now!

I was not able to check if there is some exam for SQL Server, but this can help someone anyway.

Quick recap of conditions:

  • Offer good until December 31, 2014 for up to a total of 10,000 vouchers distributed worldwide.
  • Eligible exams: A voucher may be redeemed to take one of the following MCP exams: 71-532 (beta), 70-533, 70-346 or 70-347. This offer does not include Microsoft Technology Associate exams.
  • Offer ends on December 31, 2014 or while supplies last. Individuals must register for and take all exams prior to December 31, 2014.

Exam 71-532 Developing Microsoft Azure Solutions (beta) – This exam is currently in beta.
Exam 70-533 Implementing Microsoft Azure Infrastructure Solutions
Exam 70-346 Managing Office 365 Identities and Requirements
Exam 70-347 Enabling Office 365 Services


Posted in Uncategorized | Leave a comment

Talk about MS-SQL, Oracle, NoSQL and Babylonian accounting tablets

Looking at the past can teach us a lot of things. This is a great way to know more about the things you like. And this is a great article about some fundamental characteristics of the major database systems today.

It’s definitely worth a look.

Fun quote:

You can either have data under transactional control, or you can have anarchy; take your pick. — Robert Young


Posted in MongoDB, MySQL, Oracle, SQLServer | Tagged , , | Leave a comment

Get every new post delivered to your Inbox.

Join 59 other followers