Overview of the SQL Update statement

In this article, we’ll walk-through the SQL update statement to modify one or more existing rows in the table.    After reading...

Powershell One Liners: Get current cpu utilization on all your SQL Servers

# Assuming you have list of servers in servers.txt, each server name in its own line
$ComputerNames = get-content servers.txt

# Method 1 - Using the Get-Counter cmdlet#...

Powershell One Liners: Get status of SQL Instances on All SQL Servers

# Assuming you have list of servers in servers.txt, each sever name in its own line
$ComputerNames=get-content servers.txt
Get-WmiObject -Query "select * from win32_service where...

SQL Saturday #796 – Minnesota, 2018

First, many thanks to the SQL Saturday and MNPass team for putting on another great event and letting me participate.
I...

SQL Server monitoring with built-in features

Do you think you need to use commercial tools like SQL Diagnostic Manager, SQL Sentry, Spotlight etc.. ?  Or do you think...

MongoDB-CHICAGO .Local

Continue to my interest on MongoDB Blog lastly on MongoDB 4.02, I attended MongoDB CHICOGO .local Sep 12 and learned so...

Data Types Word Search

Just for fun here is a word search with all of the data types available in SQL Server. Well, two...

Don’t believe the myth TRUNCATE TABLE isn’t logged

Remember the Bill Gates email hoax? The one that claims to be some sort of Microsoft beta test saying Gates is going to pay cash money to anyone who...

Know How to Import SQL Server database From One to Another

Looking to import SQL Server database from one server to another ? Confused how to copy from one to another or...

Moving SQL Server 2008 and 2008 R2 clusters to #Azure for Extended Support

Earlier this year Microsoft announced extended support for SQL Server 2008 and 2008 R2 at no additional cost. However, the...