Jan Theme for Learn SQL Free – Programming / Control of flow elements of T-SQL

After a short amount of thought about what would a be a cool theme for January I decided that a series of posts on the Programming / Control of flow elements of T-SQL. I will try and cover all of the below commands this month which cover almost all the programming elements of T-SQL. CASE [...]

My plans for 2015

Hi to all my readers. I must confess that my Blogging has suffered during the latter half of my wife's pregnancy and the first five months of my newborn baby girl's life. I have had grand plans about Blogging about Powershell, C#, SQL Server and Python each and everyday but my own unrealistic expectations have [...]

ABC The best trait of a SQL DBA

Have you ever wondered what the best trait all super SQL DBAs possess? Well I will tell what the best trait is and an easy acronym to remember it. I had a conversation with one of my colleagues we talked about the different DBAs and System Admins in the company both past and present and [...]

Output results from PowerShell to CSV or XML

Have you wanted to output results from PowerShell to CSV or XML? Well I am going to show you how. I have previously explained how to export results of PowerShell queries but did not include how to export the results to CSV or XML. The reason for that is that when you become familiar with [...]

Open files using PowerShell Get-Content

Have you ever wanted to open a file and view its contents using PowerShell? Well I am going to show you how. I frequently output the results of PowerShell queries into files for later review but rarely used PowerShell to view the contents. This has been because I always had other programs readily available to [...]

Simple way to output results to a file using PowerShell

Have you ever wanted to send the output of a PowerShell command to a file? Well I am going to show you how. When you run a PowerShell command like Get-Process, Get-Host…. It will return useful information but sometimes you want to save that information for future reference. You could cut and paste or take [...]

List active process running using PowerShell

Have you ever wanted to quickly find the processes running using Powershell? Wanted an alternate to Task Manager? Well I am going to show you how. Whenever I get a call from someone about a performance issue on any of our SQL Servers I always usually have a quick glance of Task Manager so that [...]

Hello World in C#

Have you ever wanted to reach the first milestone in programming by writing a Hello World application in C#? Well I am going to show you the script to produce the program. I was asked by a member of our helpdesk team how he could become a programmer. I answered that he should start with [...]

Get the Operating System Properties via PowerShell

Have you ever wanted to get all the operating system properties of a computer? Well I am going to show you a short PowerShell script which can get loads of information about the operating system. One of my colleagues was googling around for information about how to find the windows directory, number of users, last [...]

Change a database state in SQL

Have you ever wanted to change a databases state from read only to read write or vice versa? Well I am going to show you how using some easy to remember T-SQL which you will be using repeatedly over time.   We received a database from a client the other day and noticed one of [...]

%d bloggers like this: