Glenn Berry (@GlennAlanBerry) of SQLskills.com talks about the 64GB memory limit in SQL Server 2012 Standard Edition and explains why Microsoft should reconsider this licensing strategy in light of forthcoming hardware advances.
Hit-highlighting is a feature that many people wish SQL Server's Full-Text Search would support natively. This is where you can return the entire document (or an excerpt) and point out the words or phrases that helped match that document to the search. Doing so in an efficient and accurate manner is no easy task, as I found out first hand.
Playing around today, I discovered that I couldn't connect to my local named instance using the dedicated administrator connection. This post shows why and explains how you can avoid getting locked out of your own instance.