SQL Server – MicroTechPoint

Introduction to Microsoft SQL Server Transact-SQL (T-SQL)

May 30, 2024July 30, 2024Brian Alderman

Microsoft SQL Server Transact-SQL (T-SQL) is a proprietary extension of SQL (Structured Query Language) used by Microsoft SQL Server and Sybase ASE (Adaptive Server Enterprise). T-SQL is a powerful and versatile language that provides procedural programming capabilities and standard SQL functionality found in all RDBMS (Relational Database Management System) products. RDBMS is a collection of programs and capabilities that enable IT teams, database administrators (DBA), and database programmers to create, update, administer and interact with a relational database. A relational database is a database that uses tables to organize data into rows and columns that contain values that are related to each other. Microsoft SQL Server is one of… Read More

TekkiGurus Announces Website Launch for the Microsoft Community

March 15, 2023July 8, 2023Brian Alderman

Community site for experts, users and solution providers using Microsoft technology Las Vegas, NV — March 15, 2023 — TekkiGurus.com, the online platform for Microsoft technology enthusiasts, has launched today to over 300,000 members of the Microsoft community. The website aims to provide a comprehensive resource for tech enthusiasts of all levels, from beginners to advanced users, with information, insights and the latest news on all things Microsoft tech. TekkiGurus.com will feature an extensive library of technology-related articles, tutorials, product reviews and how-to guides contributed from an extensive network of Microsoft MVPs, Microsoft Certified Trainers and other industry experts and thought leaders who make their living helping companies understand and… Read More

Upgrading SharePoint Server 2013 to SharePoint 2016 on a single server

June 22, 2022July 30, 2024Brian Alderman

Let’s say that you’re hosting a handful of SharePoint Server 2013 sites for a small number of users and you want to create a development SharePoint Server farm, or that you want to create a SharePoint Server 2016 farm as a short-term solution on the way to SharePoint Server 2019 or SharePoint Server Subscription Edition. In previous versions of SharePoint, if you ran an install of SharePoint on a single server, it installed SQL Server Express for you as part of the SharePoint installation. This isn’t the case with SharePoint Server 2016 or 2019, so you must install SQL Server (2014 SP1 or higher for SharePoint 2016) on the same… Read More

Links to my free training videos from several resources

January 10, 2018June 3, 2018Brian Alderman

Online Training Videos Sign up for a free 1 month trial subscription at Pluralsight using code 607-2213-JQZ4-7FRA to view my SharePoint, SharePoint Online, and Office 365 courses available from Pluralsight. Sign up for a free trial subscription at Pearson to view my Windows Server Identity with Windows Server 2016 course available from Pearson. Sign up for a free trial subscription at LinkedIn to view my course on Migrating from SharePoint 2013 to SharePoint 2016. You can also view this course on Lynda.com. Please visit the Microsoft Virtual Academy to view my Microsoft SharePoint and SQL Server courses. You can visit the ComputerWorld site to view my monthly SharePoint blogs. Thanks for visiting! Brian

Shrinking Ginormous SharePoint Database Transaction Log Files

June 30, 2015June 3, 2018Brian Alderman

I’m sure by now most of you have encountered SharePoint databases that have a SQL Server database data file (.mdf) at a size that is as little as several hundred MB’s, yet the associated log file (.ldf) is ginormous and may be GB’s in size. This ginormous transaction log file will continue to grow until the drive containing the transaction log (t-log) runs out of disk space. At this point there is no room for transactions to be added to the t-log, so users cannot perform insert, update, or delete actions in SharePoint. This restriction is applied because every type of SQL data modification is first written to the transaction log and… Read More

Moving or Renaming a Web Application Content Database

June 2, 2015June 3, 2018Brian Alderman

When creating a web application in SharePoint 2013 it will communicate with SQL Server to create the supporting content database. Depending on what steps are used to create the Web Apps it sometimes creates the SharePoint database with a not-so-‘friendly’ database name and it may contain a ginormous GUID, (which I pronounce Goo-id) as part of the database name. When working with these databases it can become challenging to specify the name of the database within PowerShell or SQL Server so you’ll want to rename the database to a more user-friendly name. You may also decide you need to move the database to a different location on your hard drives, but you don’t want to recreate the Web… Read More

Renaming the GUID-Challenged Central Administration Database

June 1, 2015June 3, 2018Brian Alderman

The Central Administration content database that is created during the installation of your SharePoint farm is probably the second most important database, with the SharePoint Configuration database being the first most important, so it is imperative that you are able to easily reference this database when performing administrative tasks. If you perform the SharePoint installation using the GUI the Central Admin database is created with a not-so-user-friendly name that includes a Globally Unique Identifier (GUID). This name makes it challenging to work with when writing scripts that reference the database because of the GUID included in the name of this database. You can avoid the GUID from being applied to… Read More

Microsoft Ignite Review

May 15, 2015June 3, 2018Brian Alderman

Last week, I spent time with over 23,000 of my closest friends in Chicago at the Microsoft Ignite conference learning, networking, eating, and enjoying a bevy as we absorbed as much information as possible on topics including Windows 10, SQL Server, SharePoint, Office 365, and Azure just to name a few. Within these areas there were sessions containing information for IT Pros, developers, information workers, and anyone else working in any capacity of technology and not just Microsoft, as there were several mentions of Apple products as well. This was the first conference of its kind in the fact it combined TechEd and several product-specific conferences, like SharePoint and SQL… Read More