Zurb Foundation 6 with ASP.NET Core MVC – Step by Step
Step by step instructions for creating Core MVC web application using Zurb Foundation 6 user interface framework. Foundation 6 with ASP.NET Core MVC 1.
Step by step instructions for creating Core MVC web application using Zurb Foundation 6 user interface framework. Foundation 6 with ASP.NET Core MVC 1.
How to find long running stored procedures In SQL Server? Step by step illustration to find slow running SQL Server stored procedure.
What Are Extended Events In SQL Server? What are the advantages of extended events over profiler? How to use SQL Server XEvents?
How to add bootstrap in ASP.NET Web Forms and MVC projects? Step by step instruction for adding bootstrap UI framework in ASP.NET web projects.
How to Find Last Few Executed Queries in SQL Server? Simple methods to find the recently executed sql statements using DMVs (Dynamic Management Views).
How to get the row count of all tables In SQL Server database? Simple method to get the list of all tables in a database along with the number of rows.
Solution for error “Cannot find one or more components. Please reinstall the application.” when launching SQL Server Management Studio 2016 (SSMS 6.5.3).
Find the user defined function containing text or specific table name or specific column name? Here is the simple transact SQL statements to find the UDF
How to search and find user defined function (UDF) by it’s name or partial name, or even with some text in the function’s source code.
How to search and find all user defined functions or UDF In SQL Server? Several methods to find all the user defined functions in a database.
Fix for OneNote For Mac OS Crashes on Startup. Simple and quick steps to fix the crashing of OneNote on MacOS Sierra. Is onenote crashes on startup in mac?
Encrypting a string using hash code algorithm in sql server using the HASHBYPES function. Hash Code Encryption using MD2, MD4, MD5, SHA, SHA1, SHA 256 & 512
Finding Indexes On A Table In SQL Server: There are several ways to list the indexes on a table. We’ll see few easy methods to find indexes on a table
Easy method to find the size of tables in an SQL Server database. Get the size of all the tables in a database using SSMS standard report and queries.
Combine multiple rows into one string in SQL Server. Simple query in SQL Server to concatenate multiple rows Into single string.
Step by step instructions to shrink VirtualBox Vdi on Mac with Windows 10 64 bit Guest OS. Easy yaw to compact Windows 10 virtual machine vdi on Mac OS.
Shrink database file (mdf) In SQL Server database and reduce it’s size. I.e. shrinking the mdf file without affecting the ldf file.
Shrink transaction log file In SQL Server database without altering the database files . I.e. shrinking the ldf file without affecting the mdf file.
Generating more and recent transaction data In SQL Server WideWorldImporters sample database. Steps for generating more data In WideWorldImporters database.
Tips and tricks to check if column exists in a SQL Server database table. Also find the list of all tables and stored procedures having the column name.