How to Rebuild All SQL Server Indexes Online

How to Rebuild All SQL Server Indexes Online - Article on TechHowTos.com

This article, provides useful T-SQL scripts that can help you all SQL Server indexes online. The below script makes use of the undocumented SQL Server stored procedure “sp_MSforeachtable” and with the proper syntax, it rebuilds all SQL Server indexes online for all tables in a database, along with keeping the default Fill Factor for each … Read more

In Which Context Does SQL Server Access Network Resources?

Quick tech tips on Tech How To's

In this article, we will be discussing about: In Which Context Does SQL Server Access Network Resources?   How Does SQL Server Access Network Resources When you run adhoc queries (i.e. execute stored procedures, use OPENROWSET, etc.) targeting resources outside the scope of the SQL Server instance (i.e. a file on a network location), SQL … Read more

How To Fix the Issue “This device can’t use a Trusted Platform Module”

image

This article suggests how to fix the issue “This device can’t use a Trusted Platform Module” when enabling BitLocker encryption in Windows 10. If you try to turn BitLocker on for your OS drive in Windows 10 and thus encrypt the system drive, under certain circumstances, you might get the below error message: This device … Read more

How to Write a “Hello World” App in Visual C++

image

In this how-to, we are going to build a “Hello World” console application in Visual C++. If you don’t already have Visual Studio, the you can download Visual Studio Community Edition which is free.   Building the App in Visual Studio Ok, let’s build our Hello World app! After launching Visual Studio, we click on “File“, “New“, … Read more

How to Write a “Hello World” App in C#

What are T-SQL Snippets in SSMS? Article on TechHowTos.com

Visual Studio is an extremely powerful IDE for building many types of applications. In this how-to, we are going to build a “Hello World” Windows forms application in C#. If you don’t already have Visual Studio, the you can download Visual Studio Community Edition which is free. Ok, let’s build our Hello World app! In this example … Read more

How to Get Started with SQL Server

image

In this article, we discuss about, how you can easily get started with the SQL Server Data Platform and SQL Server Management Studio (SSMS).   Introduction SQL Server is one of the most powerful data platforms in the world. It is is Relational Database Management System (RDBMS) in which you can store, organize and process your … Read more

How To Show “This PC” Icon on Windows 10 Desktop

Windows 10 Articles and How Tos on TechHowTos.com

In this short article, we explain how you can easily configure your Windows 10 OS, in order to show “This PC” icon on the Windows desktop. “This PC” is the ultimate shortcut in Windows. Via “This PC” you can see all the drives available in Windows and easily browse their contents. Maybe, showing “This PC” … Read more