Today is a happy day for me. My course Getting Started with Enterprise Search using Apache Solr was released today. Look at it to get started on search! And also my article as a guest writer in Pluralsight’s blog, These 5 things are destroying your meetings, was released today! Take a look at it if you suffer from extreme meeting disorder! This looks so nice in Twitter!
Enterprise search used to be not for the faint of heart or with a thin wallet. However, since the introduction of Apache Solr the name of the game has changed. Solr brings high quality enterprise search to the masses. Don’t leave home without it! And let me help you get started! My intention is to create a series of posts where I can help you get started with Solr. This process can be easy if tackled with the appropriate resources, but it can be daunting if you chose the wrong ones. I will start by describing what each module of my training covers, click on the bullet to be taken directly to the post. Why Solr & Enterprise Search? Architecture of an Enterprise Search Application Solr Configuration Content: Schemas, Documents and Indexing Searching & Relevance Making it all Work: Put a UI on It! Final Words My course is available in Pluralsight: Getting Started with Enterprise Search using Apache Sol. You can watch it here: http://pluralsight.com/training/courses/TableOfContents?courseName=enterprise-search-using-apache-solr
Happy is a good way of describing it. However it goes beyond that. I am grateful that I have been chosen as a speaker in Atlassian’s 2014 Summit! If you are reading this before the conference you can find me here: Atlassian Summit 2014 Take a quick look: All these years working hard with Agile and Jira pay off! Silicon Valley, here I go!
This is just a quick rant/question. Does anyone know why you have to type your password twice when setting up the Application Pool Identity in IIS? It seems an extremely dumb feature as #1 you can copy paste the password or #2 just type it but given you usually include service accounts here with stupidly complicated passwords then why do you have to suffer typing it twice? Windows “evolves” but the underlying things are exactly the same. Can’t Microsoft spare a little bit of time making Windows more usable and fix little itty bitty things like this one that overall will have a better user experience? Oh well, who cares about devs anyway!
So I am taking databases offline and I need to find out which ones have active connections to them. People usually do a sp_who However that brings a lot of info that I don’t need. I prefer to use this query so I see the DBs with number of connections! SELECT DB_NAME(dbid) as DBName, COUNT(dbid) as NumberOfConnections, loginame as LoginName FROM sys.sysprocesses WHERE dbid > 0 GROUP BY dbid, loginame ; Brilliant query!
We had a spaghetti of database owners so I decided to get this straightened out. How to do it? Simple! – Open New Query in SQL Server Management Studio in the database that you want to change the owner – Run EXEC sp_changedbowner ‘domain\owner’ – Wait for Command(s) completed successfully. As simple as that!