Skip to content
  • Facebook
  • GitHub
  • YouTube
  • Pinterest
My Tec Bits
  • Home
  • Microsoft
    • .Net
      • ASP.NET
      • MVC
      • Visual Studio
    • IIS
    • SQL Server
      • SQL Server 2019
      • SQL Server 2017
      • SQL Server 2016
      • SQL Server 2014
      • SQL Server 2012
      • SQL Server 2008
    • Windows OS
  • Web Development
    • Java Script
    • Jquery
    • Python
    • Bootstrap
    • Zurb Foundation
    • Web Security
  • More
    • macOS
    • Reviews
  • Online Tools
    • Fitness Calculators
    • Encoders & Decoders
    • Cryptography
    • Unit Converters
    • Math. Calculators
    • Date & Time Calculators
    • Finance Calculators

Beaulin Twinkle

Shrink Transaction Log File In SQL Server

Aug 18, 2018Oct 19, 2016 by Beaulin Twinkle
SQL Server shrink transaction log 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.

Categories SQL Server Tags Database, SQL, SQL Server 2008, SQL Server 2012, SQL Server 2014, SQL Server 2016 Leave a comment

Generating More Data In WideWorldImporters Database

Aug 18, 2018Oct 15, 2016 by Beaulin Twinkle
Generating More Data In WideWorldImporters 01

Generating more and recent transaction data In SQL Server WideWorldImporters sample database. Steps for generating more data In WideWorldImporters database.

Categories SQL Server Tags Database, SQL, SQL Server 2016 Leave a comment

Check If Column Exists In Table Of SQL Server

Aug 18, 2018Oct 13, 2016 by Beaulin Twinkle
Check If Column Exists In SQL Server Table 05

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.

Categories SQL Server Tags SQL, SQL Server 2005, SQL Server 2008, SQL Server 2012, SQL Server 2014, SQL Server 2016 Leave a comment

Encrypting Stored Procedure, View & Function in SQL Server

Aug 18, 2018Sep 22, 2016 by Beaulin Twinkle
SQL Server Encrypting Stored Procedures Views and UDF

Encrypting stored procedure in SQL Server for hiding the source code of the stored procedure, view and function. Using WITH ENCRYPTION to hide source code.

Categories SQL Server Tags SQL, SQL Server 2008, SQL Server 2012, SQL Server 2014, SQL Server 2016 1 Comment

Bootstrap 3 With MVC 5 And Entity Framework 6 Database First

Jan 7, 2019Aug 18, 2016 by Beaulin Twinkle
Bootstrap3 with ASP.NET MVC5 and EF6

Bootstrap 3 With MVC 5 And Entity Framework 6: Step by step instruction for creating ASP.NET MVC 5 with EF 6 web application using Bootstrap 3

Categories .Net, Internet & Web Dev., Twitter Bootstrap Tags ASP.NET, C# (C Sharp), Entity Framework, MVC, MVC 5, Visual Studio, Visual Studio 2015, Web Site 9 Comments

ViewModel vs ViewData vs ViewBag vs TempData vs Session in MVC

Aug 7, 2021Jul 28, 2016 by Beaulin Twinkle
ViewModel vs ViewData vs ViewBag vs TempData vs Session in MVC

When to use ViewModel, ViewData, ViewBag, TempData or Session in MVC? What are the similarities & differences? ViewModel vs ViewData vs ViewBag vs TempData.

Categories .Net Tags ASP.NET, MVC, MVC 4, MVC 5 9 Comments

Using DNN Visual Studio Project Template

Aug 18, 2018Jul 22, 2016 by Beaulin Twinkle
DNN Visual Studio Project Template 01

Installing and using the DNN visual studio project template for developing web application modules for Dotnetnuke

Categories .Net, DNN, Internet & Web Dev. Tags CMS, Content Management System, DotNetNuke, Visual Studio, Visual Studio 2013, Visual Studio Web Express, Web Site Leave a comment

Update From Select Statement in SQL Server

Feb 25, 2023Jun 16, 2016 by Beaulin Twinkle
Update From Select

Update from select statement in SQL Server. Updating a table using select statement form the same table or different tables using join.

Categories SQL Server Tags SQL, SQL Server 2008, SQL Server 2012, SQL Server 2014, SQL Server 2016 3 Comments

Joining Tables from Databases on Different SQL Servers

Mar 11, 2021Jun 15, 2016 by Beaulin Twinkle
Joining Tables from Databases on Different SQL Servers

How to write a SQL select query joining multiple tables from databases located on different SQL Server Instances? Accessing table from remote SQL Server.

Categories SQL Server Tags SQL, SQL Server 2008, SQL Server 2012, SQL Server 2014 3 Comments

Free or Highly Discounted Microsoft Development Tools

Jan 27, 2021Mar 5, 2015 by Beaulin Twinkle
Microsoft Development Tools

Some useful options to get and use free or highly discounted Microsoft development tools and software. Microsoft is providing lot of free and discounted development tools for budding developers.

Categories .Net, Microsoft, SQL Server Tags Visual Studio Leave a comment

MVC with Bootstrap: Razor vs jQuery vs KnockoutJS

Aug 18, 2018Feb 8, 2015 by Beaulin Twinkle
My Tec Bits

Razor view engine vs jQuery vs KnockoutJS: Which one is best for my requirement? Which one to select Razor vs jQuery vs KnockoutJS.

Categories .Net, Internet & Web Dev., Jquery, Twitter Bootstrap Tags ASP.NET, Knockout.js, MVC, MVC 4, Visual Studio, Visual Studio Web Express, Web Site 1 Comment

Buffer Pool Extension In SQL Server 2014

Aug 18, 2018Nov 10, 2014 by Beaulin Twinkle
SQL Server 2014

What is Buffer Pool Extension in SQL Server 2014? What is it’s purpose and benefits of using buffer pool extension in sql server?

Categories SQL Server Tags SQL, SQL Server 2014 Leave a comment

Types of DBMS

Aug 18, 2018Nov 8, 2014 by Beaulin Twinkle
RDBMS

What are the types of dbms or databases? What are the different database/dbms types?

Categories Oracle Database, SQL Server Tags Database, DBMS, RDBMS Leave a comment

Installing Fedora in VMWare

Apr 10, 2023Nov 8, 2014 by Beaulin Twinkle
Fedora in VmWarwe

Step by step instructions for Installing and setting up Fedora linux OS in VMWare Player. Simple steps to install Fedora in VMWare.

Categories Linux, Others Tags Fedora, Linux distribution, VMWare Leave a comment

Setting Up DNN Module Development Environment

Jan 7, 2019Jun 8, 2014 by Beaulin Twinkle
DNN Module Devevelopment Environment

Setting up a (DotNetNuke) DNN Development Environment for developing DNN Modules

Categories .Net, DNN, Internet & Web Dev. Tags CMS, Content Management System, DotNetNuke, Web Site 1 Comment

DNN: Upgrading DotNetNuke website from 6.x to 7.x

Jan 7, 2019May 6, 2014 by Beaulin Twinkle
Dot Net Nuke

DNN Upgrade: Upgrading a Dot Net Nuke (DNN) Content Management System Website from version 6.x to 7.x.

Categories .Net, DNN, Internet & Web Dev. Tags CMS, DotNetNuke Leave a comment

Google Play Antivirus App Scam

Aug 18, 2018Apr 8, 2014 by Beaulin Twinkle
Virus Shield - Android App Scam

How to avoid app scams

Categories Android Tags App, Google Play, Mobile, Scam, Security Leave a comment

Useful Bootstrap Resources For Web Developers

Aug 6, 2021Apr 2, 2014 by Beaulin Twinkle
Twitter Bootstrap

Some useful websites, links and articles for web developers who are planning to use Twitter Bootstrap. Hand-picked bootstrap resources.

Categories Internet & Web Dev., Twitter Bootstrap Tags ASP.NET, Bootstrap 3, Bootstrap 4 Leave a comment

SQL Server: Joining Tables from Different Databases on the Same Server

Aug 18, 2018Feb 26, 2014 by Beaulin Twinkle
SQL Server Query To Join-Tables From Different Databases

SQL query for joining tables from multiple databases on the same server. Joining tables from different databases in a single select query.

Categories SQL Server Tags Database, SQL, SQL Server 2008, SQL Server 2012, SQL Server 2014 4 Comments

Bootstrap: Structure and Layout

Aug 18, 2018Nov 25, 2013 by Beaulin Twinkle
Bootstrap-Tutorial-001

Article on the basic structure and layout of a html page for using Twitter Bootstrap as the user interface framework. Structure and layout for bootstrap.

Categories Internet & Web Dev., Twitter Bootstrap Leave a comment
Older posts
Newer posts
← Previous Page1 … Page14 Page15 Page16 … Page21 Next →

Article Categories

  • Android (2)
  • Apple (22)
    • macOS (22)
  • Internet & Web Dev. (152)
    • DNN (4)
    • Java Script (10)
    • Jquery (8)
    • PHP (7)
    • Python (83)
    • Twitter Bootstrap (25)
    • Web Security (11)
    • Zurb Foundation (6)
  • Linux (4)
  • Microsoft (318)
    • .Net (69)
    • IIS (10)
    • Internet Explorer (3)
    • Office (2)
    • SQL Server (225)
    • Windows (24)
  • Networks And Distributed Systems (2)
  • Oracle (7)
    • Java (2)
    • Oracle Database (5)
  • Others (6)
  • Reviews (10)

Recent Articles

  • Installing .NET SDK in Linux Mint and debugging C# code using VS Code Jun 21, 2024
  • Generating random number in C#  Jun 6, 2024
  • How to calculate running total in SQL Server? Apr 27, 2024
  • How to import XML data into SQL Server using SELECT query? Apr 10, 2024
  • How to prevent VS Code from replacing an already opened preview tab with a subsequently opened one? Mar 13, 2024
  • Separating letters and numbers from strings in SQL Server Mar 6, 2024
  • How to call or run another application from python code? Feb 15, 2024
  • How to store images in SQL Server? Jan 17, 2024
  • Error: A table that has FILESTREAM columns must have a nonnull unique column with the ROWGUIDCOL property. Jan 8, 2024
  • Fix for Error: “FILESTREAM feature is disabled” while adding FILESTREAM Jan 4, 2024

Subscribe MyTecBits.com

Online Tools

  • Fitness Calculators
  • Encoders & Decoders
  • Cryptography
  • Unit Converters
  • Math. Calculators
  • Date & Time Calculators
  • Finance Calculators

Popular Articles

  • Convert UTC DateTime to different time zones in SQL Server
  • Upgrade python version in visual studio code python workspace
  • Where is SQL Server Configuration Manager?
  • Formatting SQL statements in SSMS
  • Row Number Without Using Order By In SQL Server
Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use. Learn more...
  • Home
  • About Us
  • Contact Us
  • Site Map
  • Terms Of Use
  • Privacy Policy
© 2012 - 2025 My Tec Bits. All Rights Reserved.