This week’s trivia… This week I present you with not just one mere factoid, but a quiz full of them! See how you score: http://www.funtrivia.com/playquiz/quiz125695e65c90.html This week’s tip… Ever wonder how to how to type multiple rows of text in a cell? I’m not talking about Wrap Text, which conveniently (or inconveniently, depending on how…
Have you ever tried to add a column to a SQL Server Table using SQL Server Management Studio, only to be confronted with the following error message: Saving changes is not permitted. The changes you have made require the following tables to be dropped and re-created. You have either made changes to a table that…
Today at my client they had a request to enable all users in the company the ability to see more details for Room mailboxes versus just the standard Blue busy bar when scheduling meetings. The primary reason is to enable the users to be able to contact the meeting organizer of a conflicting meeting to…
There is a bug in the creation process for Dynamic Distribution Groups (DDG) in Exchange 2010. When you use the Exchange Management Shell to create a DDG and specify the Organizational Unit (OU) where the DDG should reside in Active Directory, you must also specify the –RecipientContainer to search for that DDG. Otherwise the DDG…
I am starting to appreciate the absolute awesomeness of table variables. Rather than using those dreaded cursors, I use a temporary working table and use update statements to apply my calculations. The performance benefits are incredibly tangible. Table variables are very powerful and can do just about anything a temporary table can do. The only…
I like to document screenshots of installs so that in the future I can review them and make sure everything is ready like domain accounts created with proper permissions, SQL server known and ready, Windows update or not, if the client want to participate in Customer Experience Improvement Program. The screenshots below are for System…
I like to document the default screenshots for applications. This way I can review them and make sure things like Active Directory accounts are created with the proper permissions, the remote SQL server is ready, ports on firewalls are open, and anything else that could hold up an install. Below are the screenshots for System…
I have a set of records for employee utilization, and I wanted a quick way to rank them from highest utilization to lowest utilization. It turns out that the ROWNUMBER() function did exactly what I needed. Here is an example of my data: ConsultantName UtilizationPercent Consultant A 100.5% Consultant B 87.4% Consultant C 95.0% Consultant…
Next Thursday, September 20th at 11am Mountain, I will be presenting a Lync and Learn session. This session will focus on the Office 365 Lync Online Lync to Phone Service. Lync to Phone enables dial tone to Lync Online via Jajah. I hope you can join the session and learn more about Lync to Phone,…
Catapult uses cookies to enhance your experience, to display customized content in accordance with your browser settings, and to help us better understand how you use our website. By continuing to browse or closing this banner, you indicate your agreement. To learn more about the cookies we use and to set your own preferences, see our Privacy and Cookie Policy.