Blog

In the past when you would write a query and a large set of results would return, one would typically use the “TOP” or “row number” statements in the query to help reduce the load. In SQL Server 2012 and onwards, a new set of commands has been made available. You can now apply paginationRead more

There are a few ways to determine the size of databases within SQL Server without needing to right click the DB and select the Properties option. We can use the classic T-SQL query directly from the SQL Server Management Studio to display all DBs as well as their sizes. SELECT DB_NAME(database_id) AS DatabaseName, Name ASRead more

  Have you ever wondered just how many email addresses Outlook can hold in each of the To, CC & BCC fields? There is a limit to how many you can input in each field and this limit is based on the size of the contacts rather than the actual number of contacts in the field.Read more

Most people who read this blog are technology-competent folks who generally never get infected by anything; although, if they do, they know how to deal with. By the same token, we are often called upon by friends and family to serve as free technical support and more often than not, it’s because they clicked on aRead more

  Windows Server 2012 and other operating systems (Windows 8, 8.1) have the ability to use Windows PowerShell commands that are built on .NET framework. Windows PowerShell is a powerful command line that allows administrators to perform any adding, changing of any option you see on the Graphical User Interface (GUI), and perform other manipulationsRead more