About a month ago, I saw someone post about a website called TMART.com. It's kinda like KMart, except it has a ton more tech. Maybe that's what the T is for, but I digress. I was instantly attracted to it like an insect to a porch light... drawn in by amazing prices on practically everything...
Author: Rick Bishop
My Pick for 2018 Best App to Download Videos from Any Website
First off, let me say that I'm never paid to promote anything, so what I say is the gospel according to Rick. Sometimes I join an affiliate program so that maybe someday I'll see some green, but so far, I haven't seen a dime so please, know that you can rely on what I'm telling you. Now... I've had a love-hate relationship with my pick for the 2018 Best App For Downloading VIdeos from Websites and it is...
Emojis are Finally Here with Windows 10
The latest update for Windows 10, adds emoji support to any Windows keyboard. Emoji support was built into the Windows soft keyboard that sits in the system tray for years, but now it's available using any keyboard with a Windows key. Now you can add those cute little smiley faces 😊 to a Facebook post, … Continue reading Emojis are Finally Here with Windows 10
Obtain an Exclusive Lock to Rename a SQL Server Database
Tested on: SQL Server 2016 Developer Edition Accurate as of: January, 2018Use this script to rename a database when the SQL Server database could not be exclusively locked to perform the operation. [code language="sql"] -- First, set the database to single user mode ALTER DATABASE CodeSnippets SET SINGLE_USER WITH ROLLBACK IMMEDIATE -- Now we will … Continue reading Obtain an Exclusive Lock to Rename a SQL Server Database
Querying Stored Procedure and System Function Parameter Information
Tested on: SQL Server 2016 Developer Edition Accurate as of: January, 2018The following snippet generates a SQL Server View that displays information about the parameters that need to be passed in to System Objects. The data type information that is returned in this view is human readable (i.e. `nvarchar(200) NULL`), rather than the numeric type … Continue reading Querying Stored Procedure and System Function Parameter Information
Show ROW NUMBERS in T-SQL RESULT set
Tested on: SQL Server 2016 Developer Edition Accurate as of: January, 2018 In this query, I've added a record number column to the result set using OVER and ORDER BY clauses with the ROW_NUMBER function in T-SQL. Note that the ORDER BY clause is required. The OVER() clause tells the SQL Engine to sort data … Continue reading Show ROW NUMBERS in T-SQL RESULT set
SQL Server Admin: Identifying Active Transactions
Tested on: SQL Server 2016 Developer Edition Accurate as of: January, 2018One way to identify active tractions, is using DBCC OPENTRAN. DBCC OPENTRAN helps to identify active transactions that may be preventing log truncation. DBCC OPENTRAN displays information about the oldest active transaction and the oldest distributed and nondistributed replicated transactions, if any, within the … Continue reading SQL Server Admin: Identifying Active Transactions