Archive for the ‘SQL’ Category

Grant a MS SQL login Read Only access to ALL databases

 Here is a SQL code snippet I used today that loops through all the databases on a server and creates a SQL script that will give a user Read Only access to all databases (including system databases).  

Simple script to backup all databases at once

Script to backup all non system databases To backup all your MS SQL databases quickly on a SQL instance use the following script in a new query window. You must change the “SET @path” string to a suitable location.

Setting SQL Server to accept date in DD/MM/YYYY format

I’ve been working on a web based database project for the wifes business and during development I realised that half of the dates where being saved in M-D-Y format. As I live in the UK we use the correct date format which is D-M-Y obviously ;). The problem turned out to be a single settings […]

Cannot shrink transaction log SQL 2005

If you ever come across a MS SQL 2005 transaction log that refuses to shrink, this little bit of code might help you out.

T-SQL Example code: Select, Insert, Update, Delete

Various examples and snippets of Select, Insert, Update, Delete T-SQL

T-SQL Example code: Table Management

T-SQL table management tips, tricks and code snippets

T-SQL Example code: useful stores procedures and snippets

Here are some useful one liners that I find very useful

T-SQL Example code: User Management

Some useful commands for dealing with users (in a non violent way), and a very useful couple of lines for finding and then fixing orphaned users which often happens after moving a database to a differnet SQL server.

T-SQL Example code: Database Management

Here is some code that Iv’e found useful for managing databases:

T-SQL Example code: SQL Fixes

Here are a few lines of code that have got me out of troubel in the past:

• Recent Posts

  • How to pre-configure a headless Pi-OS Lite MicroSD card
  • How to unregister an ESXi VM using the CLI
  • How to mount an iSCSI datastore in ESXI CLI
  • Replace the SSL Certificate on a Ubiquiti Edge Router Lite
  • Remove Administrator or a user password in Windows 10 using Kali
  • Converting AWS .PEM keys to .PPK for use in Putty
  • Command prompt from mspaint
  • Add a static IP to Linux (updated 2017)
  • Create a hardware network monitor with a Pi and a Blinkt
  • Pseudo Command Prompt

• Tag Cloud

  linux sql PowerShell Ubuntu database update dbcc T-SQL table delete dsquery vmware insert select AD ip address drop truncate exec Exchange 2010 Exchange

• Categories

  • Tech (53)
    • AD (3)
    • ASP.NET (1)
    • Excel (2)
    • Exchange 2010 (4)
    • Hardware (4)
    • Linux (13)
    • PFsense (1)
    • Power Shell (5)
    • Python (1)
    • Raspberry Pi (3)
    • Security (5)
    • SQL (12)
    • Vmware (6)
    • Windows (4)