Find todays date and time in SQL Server — Parv The IT Geek

Have you ever wondered how to get the current time and date within SQL Server? Well I am going to show you two easy methods of getting this information. The first method is my preferred method as it’s slightly shorter than the second method. SELECT CURRENT_TIMESTAMP Originally published at https://parvtheitgeek.com on February 9, 2014.

Length of LOB data (95563) to be replicated exceeds configured maximum 65536 — Parv The IT Geek

Have you ever had the above error message? Wondered how to sort it out? Well I am going to show you how. Today I was confronted by the above error when a test migration database which was setup with replication was loaded with simulated data. The migration source environment was not replicated so I didContinue reading “Length of LOB data (95563) to be replicated exceeds configured maximum 65536 — Parv The IT Geek”

Search PowerShell help using wildcards — Parv The IT Geek

Have you ever wanted to search for new commands or have difficulty remember syntax? Well I recently found the wildcard search function within the help system and I am going to show you how to use it. You could use the commands feature which is below and can be accessed via Add-ons > Commands OrContinue reading “Search PowerShell help using wildcards — Parv The IT Geek”

Clearing the screen in PowerShell — Parv The IT Geek

A quick snippet for some newbie PowerShell developers whilst they start getting their teeth into the ISE is there are two easy ways of clearing the screen. I ahdnt thought about sharing this information but I saw a developer simply closing the ISE so that he could start afresh. I asked him why and heContinue reading “Clearing the screen in PowerShell — Parv The IT Geek”

Opening PowerShell Help in a window — Parv The IT Geek

Have you ever wanted to be able to easily read through the help system in PowerShell? Wanted to take advantage of your second screen whilst developing in PowerShell? Well I am going to show you how. Whenever I have used PowerShell I had a love-hate relationship with the help system. Whilst it helps me outContinue reading “Opening PowerShell Help in a window — Parv The IT Geek”

Update the PowerShell Help System — Parv The IT Geek

Have you ever wondered how to update the PowerShell help system? Wondered how to update it more than once in a 24 hour period? Needed to update the help file of a system not connected to the internet? Well I am going to show you how. Whenever I jump onto any new server the firstContinue reading “Update the PowerShell Help System — Parv The IT Geek”

Find what version of PowerShell is installed. — Parv The IT Geek

Have you ever wondered what PowerShell version your machine was running? Needed to quickly check the PowerShell version to see whether it had successfully upgraded? Well I am going to show you how. Today I was on one of my creaky old SQL Servers when I started doing some inventory checks to see what levelContinue reading “Find what version of PowerShell is installed. — Parv The IT Geek”

Find a column in a database with INFORMATION_SCHEMA.COLUMNS — Parv The IT Geek

Have you ever just been given a column name and not known which table it was in? Needed to check whether a column existed within a database?… Well today I was just given a column name and told the information I needed was in there but alas they didn’t know which table it was in.Continue reading “Find a column in a database with INFORMATION_SCHEMA.COLUMNS — Parv The IT Geek”

SQL JOINS — INNER,OUTER( FULL,LEFT,Right) ,CROSS, SELF — Parv The IT Geek

Have you ever been baffled when people talk about SQL joins? Mystified when you hear inner, outer, cross or self? Ran away in fear at the thought of joining two tables? Well I am about to help you out and face down those fears and explain to you what joins are, the different types andContinue reading “SQL JOINS — INNER,OUTER( FULL,LEFT,Right) ,CROSS, SELF — Parv The IT Geek”

How to list all SQL DMVs (Dynamic management views) s and DMFs (Dynamic management functions ) in…

Have you ever wondered how many DMVs are in SQL? Wondered whether a DMV exists which help diagnose your problems? Well I am going to show you how to list all the DMVs and DMFs so that you can do a deeper dive into them or await my series where I will be exploring eachContinue reading “How to list all SQL DMVs (Dynamic management views) s and DMFs (Dynamic management functions ) in…”