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 instanceContinue reading “SQL Server Collations Find current collation and all supported collations — Parv The IT Geek”
Tag Archives: Database Administration
SQL Cursor to Kill all connections to a database — Parv The IT Geek
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. DECLAREContinue reading “SQL Cursor to Kill all connections to a database — Parv The IT Geek”
How to attach AdventureWorks 2012 to SQL Server — Parv The IT Geek
Have you ever wanted to install the sample database (AdventureWorks )provided by Microsoft which a lot of the tutorials and books refer to? Well one of my colleagues has started to learn SQL Server so I thought I would knock up a quick guide for him. The correct classical way is to use T-SQL wouldContinue reading “How to attach AdventureWorks 2012 to SQL Server — Parv The IT Geek”
List of DBCC commands in SQL Server — Parv The IT Geek
Have you wanted a list of DBCC commands to enable you to do a deep dive? Well I am going to list them out for you. Below is a list which complied after a discussion with a fellow DBA who said there were only about twenty whilst I was sure there were way more. WeContinue reading “List of DBCC commands in SQL Server — Parv The IT Geek”
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”
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…”
Intro to SQL Server Reporting Services 2008 : Report Builder 2.0 — Parv The IT Geek
This shipped after SQL Server Reporting Services 2008 and is available as a separate download. I have always run a search to download the latest installation file. Report Builder 2.0 is a too design to allow the easy and quick development of Reporting Services Reports and was created with the non-developer in mind. This isContinue reading “Intro to SQL Server Reporting Services 2008 : Report Builder 2.0 — Parv The IT Geek”
SQL Server Reporting Services 2008 (SSRS) Databases- ReportServer & ReportServerTempDB.
When reporting service is set up there are two default databases created which are 1. ReportServer 2. ReportServerTempDB. Reportserver database contains a wide range of information which is briefly listed below. 1. Subscriptions 2. Schedules 3. Data sources 4. Folder 5. Keys 6. History 7. Notifications and much much more. I would suggest looking atContinue reading “SQL Server Reporting Services 2008 (SSRS) Databases- ReportServer & ReportServerTempDB.”
Easily Check Database Integrity (DBCC CHECKDB) For All Databases On A Server — Parv The IT Geek
Today I was doing my daily checks on one of my biggest SQL instances which has over 1,000 databases and noticed that SQL Agent was stopped. I couldn’t see any errors and was able to simply start it without any problems but I was concerned that the daily integrity check jobs had not run andContinue reading “Easily Check Database Integrity (DBCC CHECKDB) For All Databases On A Server — Parv The IT Geek”
How can I find out what SQL Server version is running? — Parv The IT Geek
I was asked by someone which SQL Server version a server was running and was surprised when my DBA colleague said to run a stored procedure I had never heard of. I had not thought that there would be more than one way as the usual method I used below was so simple I didn’tContinue reading “How can I find out what SQL Server version is running? — Parv The IT Geek”
