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

SQL Server buffer pool

On 05 Nov, 2015
Articles, MS SQL DBA
By : Charith Silva
No Comments

SQL Server uses a buffer pool of memory to cache data pages, reducing I/O demand and improving overall performance. SQL Server buffer pool also called as buffer cache is a place in the SQL Server system memory that is used...

Read More

Log shipping Alerts failing to send emails

On 04 Nov, 2015
MS SQL DBA
By : Charith Silva
With 1 Comment

Recently I had to configure Database mail in one of the production SQL Server estate to send Log shipping Alerts. Database email has been configured and it was successfully sending test emails through the SQL Server. However when I try...

Read More

SQL Server Patching

On 09 Oct, 2015
MS SQL DBA
By : Charith Silva
No Comments

It’s important to install SQL Server service packs whenever they are available and keep database servers up-to-date. Service Packs contain important fixes and they are tested rigorously than incremental releases like cumulative updates, so they’re pretty important to install and...

Read More

Poorly performing queries in SQL Server

On 06 Oct, 2015
MS SQL DBA, T-SQL
By : Charith Silva
No Comments

Today junior Application Developer asked me what are the causes of poor performance queries in SQL Server?  This is a very open ended question and there could be a lot if reasons behind the poor performance of a query....

Read More

Monitoring Tools for SQL Server

On 17 Sep, 2015
MS SQL DBA
By : Charith Silva
No Comments

SQL Server provides a number of tools you can use to carry out performance monitoring and tuning. Each tool is useful in certain scenarios and you will often need to combine several of them to achieve the optimal results.  

Read More

WhoIsActive

On 13 Jun, 2015
MS SQL DBA
By : Dave Jenkins
No Comments

I thought that I would just share a little stored procedure that I've been using in my day job since becoming an accidental DBA! It's the WhoIsActive stored procedure by Adam Machanic. This stored procedure pulls together ALOT of information...

Read More

Index Rebuild or Index Reorganize

On 04 Jun, 2015
MS SQL DBA
By : Dave Jenkins
No Comments

You've just discovered that your indexes are fragmented, so you decid to do something about it. You know you need to do something to your indexes, but you're stuck wondering what the difference is between REBUILD and REORGANIZE.
...

Read More

Server and Database Roles in SQL Server

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

  SQL Server use role based security, which allows Database Administrators to assign particular permissions to users and groups. SQL server has a set of fixed roles at both the server and database levels and user-defined roles can also be created...

Read More

SQL Server 2014 Database Engine Permission Posters

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

Read More




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

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

    8772 views
  • Script to Check TempDB Speed

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

    4459 views
  • Log shipping Alerts failing to send emails

    4401 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