Parv The IT Geek

Join me on my Geeky Adventure

  • Home
  • About Me
  • Contact

Powered by Genesis

How to change the collation of a database in SQL Server?

26/04/2015 by Parvinder Nijjar Leave a Comment

Have you ever wondered how to change the collation for a database in SQL Server? Well the other day I received a database from a third party supplier and the first step was to change the Collation of the database. My questioning about why they would supply the database in the incorrect collation setting was […]

Share this:

  • Click to print (Opens in new window)
  • Click to share on Facebook (Opens in new window)
  • Click to share on LinkedIn (Opens in new window)
  • Click to share on Reddit (Opens in new window)
  • Click to share on Twitter (Opens in new window)
  • Click to share on Tumblr (Opens in new window)
  • Click to share on Pinterest (Opens in new window)
  • Click to email this to a friend (Opens in new window)

Filed Under: Database Engine, T-SQL Tagged With: Database Administration, Database Engine, T-SQL

SQL Server Collations Find current collation and all supported collations

21/04/2015 by Parvinder Nijjar Leave a Comment

Have you ever needed to check your database or SQL instance to find out its collation? Have you ever wanted to check whether a collation is supported by Windows or SQL Server? Well I am going to show you how to find out the information quickly and easily. The below query will show the instance […]

Share this:

  • Click to print (Opens in new window)
  • Click to share on Facebook (Opens in new window)
  • Click to share on LinkedIn (Opens in new window)
  • Click to share on Reddit (Opens in new window)
  • Click to share on Twitter (Opens in new window)
  • Click to share on Tumblr (Opens in new window)
  • Click to share on Pinterest (Opens in new window)
  • Click to email this to a friend (Opens in new window)

Filed Under: Database Engine, T-SQL Tagged With: Database Administration, T-SQL, Windows Administration

SQL Cursor to Kill all connections to a database

27/03/2015 by Parvinder Nijjar Leave a Comment

Have you ever tried to restore over a database but found that all attempts are being blocked by an annoying SPID? Or had hundreds of orphaned SPIDs running crazy on your instance? Well I have the solution for you with the below script which uses a cursor to kill all connections to a database. Make sure […]

Share this:

  • Click to print (Opens in new window)
  • Click to share on Facebook (Opens in new window)
  • Click to share on LinkedIn (Opens in new window)
  • Click to share on Reddit (Opens in new window)
  • Click to share on Twitter (Opens in new window)
  • Click to share on Tumblr (Opens in new window)
  • Click to share on Pinterest (Opens in new window)
  • Click to email this to a friend (Opens in new window)

Filed Under: T-SQL Tagged With: Database Administration, Programming, T-SQL

  • 1
  • 2
  • 3
  • …
  • 6
  • Next Page »

Recent Posts

  • Quick introduction to SQL, databases and relational theory
  • My top tips for new programmers
  • Book Review: Learn Windows PowerShell in a Month of Lunches, Second Edition by Don Jones
  • Why you should learn programming
  • What would you like to learn or for me to talk about?

Categories

  • Analysis Services
  • C#
  • Database Engine
  • DMV
  • General
  • Integration Services
  • Personal Development
  • PowerShell
  • Replication
  • Reporting Services
  • T-SQL
  • Uncategorized

Tags

Attach database basics Business Intelligence C# Database Administration Database Design Database Engine DBCC CHECKDB DMV Export Data Intro Monthly Theme Personal Development PowerShell Programming Replication Script SSAS SSIS SSRS SSRS Administration T-SQL Windows Administration
loading Cancel
Post was not sent - check your email addresses!
Email check failed, please try again
Sorry, your blog cannot share posts by email.