SQL Repository
  • Home
  • Articles
    • MS SQL DBA
    • SSIS
    • SSRS
    • T-SQL
  • Code Snippets
    • MS SQL DBA
    • SSIS
    • SSRS
    • T-SQL
  • Interview Questions
    • MS SQL DBA
    • SSIS
    • SSRS
    • T-SQL
  • How To
    • MS SQL DBA
    • SSIS
    • SSRS
    • T-SQL
  • Contact


Posts in the [ MS SQL DBA ] Category

Retrieving a list of databases and basic configuration setting from SQL Serve instance.

On 19 May, 2015
MS SQL DBA
By : Charith Silva
No Comments

  If you want to get a list of SQL Server databases and their basic configuration details on your current SQL server instance, you could manually open database property windows on each and every database through SSMS and note down the...

Read More

Get a list of SQL Server Agent Jobs and their schedules

On 19 May, 2015
MS SQL DBA
By : Charith Silva
No Comments

  Sometime you might want to get a list of SQL Server Agent Jobs and their schedules on your current SQL server instance. You could manually open each and every Agent job through SSMS and note down the details you required,...

Read More

How to check whether SQL Server is in clustered environment?

On 18 May, 2015
MS SQL DBA
By : Charith Silva
No Comments

  Sometimes SQL Database administrators want to check whether given SQL Server instance is in clustered environment. The SERVERPROPERTY() built in metadata system function can be used to identify the clustered mode.  SERVERPROPERTY() function  with IsClustered Property will return “0” for...

Read More

How long has your SQL Server been running since startup?

On 02 May, 2015
MS SQL DBA
By : Charith Silva
No Comments

  Following simple script will help you to find out how long has your SQL Server been running since last startup. Please make note of that this script use tempdb information to calculate the server running time and tempdb system database is...

Read More

Get the Data and Log File location for every database on a SQL Server

On 02 May, 2015
MS SQL DBA
By : Charith Silva
No Comments

  Below SQL Script will help you to find current location of Data and Log File of the Database. It shows the file location of every database on a SQL Server...

Read More

How to get the IP Address of the connected SQL Server?

On 01 May, 2015
MS SQL DBA
By : Charith Silva
No Comments

  You might need to know the IP Address and the TCP Port of the currently connected SQL Server; this simple SQL Script will help you to find the Server IP Address. This script only works for connections that are using...

Read More

How to get a list of SMTP servers used by Database Mail?

On 01 May, 2015
MS SQL DBA
By : Charith Silva
No Comments

  Database Mail feature can be used to send e-mail messages from the SQL Server Database Engine. Database Mail use SMTP server to send emails. Assume you want to get a list of SMPT server used by Database Mail due to...

Read More

How to change Database Compatibility level in all the databases for a given SQL Server instance?

On 30 Apr, 2015
MS SQL DBA
By : Charith Silva
No Comments

  Presume there are several older versions of SQL Server databases exist in your current SQL Server instance and you want to change all of those Databases Compatibility level to higher version at once. Below script might be helpfully you to...

Read More

How to check SQL Server Database compatibility level?

On 30 Apr, 2015
MS SQL DBA
By : Charith Silva
No Comments

  Sometimes there can be certain older versions of SQL Server databases exist in your current SQL Server instance. If you want to check the compatibility level of all the databases in your current SQL Server instance following script might be...

Read More

Stopping SQL Agent Jobs through T-SQL

On 27 Apr, 2015
MS SQL DBA
By : Dave Jenkins
No Comments

Earlier today I was experiencing issues with my PC and the GUI for SQL Agent jobs wasn't appearing on screen. I really needed to stop a job that had become stuck over the weekend, so I turned to T-SQL and...

Read More

  • Page 3 of 6
  • 1
  • 2
  • 3
  • 4
  • 5
  • 6


  • Popular
  • Recent
  • Database stuck in “Restoring” state

    18360 views
  • Find the modified date of SQL Server Agents Jobs

    9119 views
  • Script to Check TempDB Speed

    4950 views
  • PING all the Linked Servers and get a status report

    4584 views
  • Log shipping Alerts failing to send emails

    4529 views
  • Moving the tempdb database

    27 Jan, 2016
  • Script to Check TempDB Speed

    14 Jan, 2016
  • SQL Server buffer pool

    05 Nov, 2015
  • Log shipping Alerts failing to send emails

    04 Nov, 2015
  • View queries waiting for memory grant

    21 Oct, 2015

Useful links

  • Books Online for SQL Server 2012
  • Developer Reference for SQL Server 2014
  • Download SQL Server
  • Installation for SQL Server 2012
  • Microsoft Virtual Academy
  • SQL Server Online Training
  • Transact-SQL Reference
  • Tutorials for SQL Server 2012

Tags

.CSV 70-461 AdventureWorks 2012 ALL ANY CAST Chinook Database Code Snippet CONVERT CTE dataset datasource Dates DATETIME divide by zero Duplicates Exam EXCEPT expressions FORMAT IF Import Indexes INTERSECT Jobs NULLIF REBUILD Recursive CTE REORGANIZE ROW_NUMBER() Schedules Sequence SOME sp_stop_job SQL Server 2012 SQL Server Agent SSIS SSRS T-SQL Tally Table T_SQL UAC Permissions Error UNION UNION ALL

Recent Comments

  • Rudnei Silva on Log shipping Alerts failing to send emails
  • johnson Welch on Database stuck in “Restoring” state
  • Neil on Database stuck in “Restoring” state
  • Mark Gribler on MS SQL Database Administrator Interview Questions – Part 4

Google Analytics Stats

Latest Tweets:

  • 6 years ago Attended @SQLSatMcr yesterday - it was amazing! Roll on @sqlsatcambs! Won some Beats Headphones courtesy of @SQLDBApros - thanks guys! :)
  • 6 years ago Looking forward to attending @SQLSatMcr - its too far off though!!!
  • 6 years ago Simple Post: WhoIsActive SPROC: http://t.co/LZvQUaeapK
  • 6 years ago POST: Index REBUILD or Index REORGANIZE: http://t.co/h3L0N37vw4
  • 6 years ago How to Ping all Linked Servers: http://t.co/Q2QxusrKjO
  • 6 years ago For beginners - T-SQL Divide by Zero Error: http://t.co/BBhgoH5hK9

© Copyright 2015 SQL Repository. All Rights Reserved by SQL Repository