SQL server memory management – foundations

Everyone knows that it is important to understand how SQL server memory is managed. We’ve all heard about things like object cache, procedure cache etc. So naturally when I was asked to give an overview on the subject I thought that there was really not much for me to do and a quick internet search would turn up enough information. I was in for a surprise. It turns out that… Continue reading

Posted in database, SQL server | Leave a comment

My revenue engine –IT? – an Interview with Gene Lennon of Greater Media

Corporate America tends to view its IT departments as cost centers. While that may have been true when most of our work was done with pencil and paper, and an occasional data entry into a blinking black and green screen, it is not true today and this type of thinking really needs to change – for the sake of Corporate America. Consider these two emerging trends:

  1. Hyper-competitive environment: Tight budgets
Posted in business | Leave a comment

INSERT output clause workaround

It is a mystery to me why Microsoft decides to implement features in a seemingly half-baked way. I say seemingly, because many times it turns out that implementation challenges really are formidable and the limitation is well justified. In this particular case, object of my attention is our dear friend, the output clause. One of the many useful options for this construct is an ability… Continue reading

Posted in SQL server | Tagged , | Leave a comment

DBCC FREEPROCCACHE – use with caution

DBCC FREEPROCCACHE DANGERMicrosoft documentation doesn’t usually dwell on dangers of executing admin commands. It is somewhat correctly assumed that if you have the access to run it, you know what you’re doing, but DBCC FREEPROCCACHE is one of those commands that even Books OnLine (BOL) urges extra caution. “Use DBCC FREEPROCCACHE to clear the plan cache carefully.” – it says. In fact… Continue reading | 5 Comments

Posted in query plans, SQL server | 5 Comments

TFS powershell and database projects – talk about an A-team!

We have previously discussed accessing work item information. It’s time to dig a bit deeper. Each Work Item has a Revisions collection which as you might expect, is a collection of Revision Objects. Each of these objects is a record in a work item history and contains a nullable Links property which (when… Continue reading | 1 Comment

Posted in database, Powershell, Team Foundation Server (TFS), Visual Studio | Tagged , , , , , , | 1 Comment

Internet of things – what it means to you as a DBA

Continue reading | 1 Comment
Posted in database | Tagged , , | 1 Comment

Top 10 Questions to Ask When Hiring a DBA Consultant

Hiring a DBA Consultant Database Administration (DBA) is at the heart of business processes. Many companies find it challenging to recruit and retain the in-house expertise that is required for good database management.  It can be hard to find a DBA that is good at what you need or too expensive to hire the level of expertise… Continue reading | 1 Comment

Posted in database, Strategy | Tagged , | 1 Comment

Why your CMO’s and DBA’s should have lunch together?

In many companies, the CMO and DBA don’t really know each other. They may say hi in the hall as they pass one another, but that’s about as good as it gets. In fact, I’ve come across organizations in which the marketing staff is not allowed to communicate directly to the DBA without the IT manager or the CIO involved, due to security considerations!  In large companies and enterprises, chances are that they don’t even share the same floor, building or even zip code. … Continue reading

Posted in database, Strategy | Tagged , , , | Leave a comment

A good DBA saves you money. A great DBA makes you money!

Winner DBA

Winner DBA

A good DBA will configure your database for optimal availability and performance of critical information systems. They will also set up a rock solid disaster recovery plan so that your business can continue to run smoothly even during and after disaster, and take care of your database infrastructure and disk storage needs, and monitor growth trends and advise management… Continue reading | 1 Comment

Posted in database | Tagged , , | 1 Comment

WIQL – The Wonder Query Language

As previously discussed, one of the ways to access Work Items is via WIQL query. Despite the fact that it is somewhat awkward (for example, you always have to specify a from clause, but you can only select from one table – WorkItems), It is actually rather powerfull, allowing a user many more options than the GUI query builder. It has all sorts of cool options such… Continue reading | 1 Comment

Posted in Powershell, Shell Scripting, Team Foundation Server (TFS), Visual Studio | Tagged , , , | 1 Comment