Blogs about: Sql Server Dba
Featured Blog
Microsoft in-memory avathar of BI–SSAS Tabular modelling
SQL 2012 comes with more feature for flexibility ,security and scalability, tabular model or multidimensional model to choose from. Queries and logics using DAX or MDX Storage options – cached and pas… more →
Bineesh Thomas
Microsoft in-memory avathar of BI–SSAS Tabular modelling
wrote 1 month ago: SQL 2012 comes with more feature for flexibility ,security and scalability, tabular model or multidi … more →
T-SQL – Finding SQL Server Service Restart Date-Time
— 2 comments
wrote 1 month ago: T-SQL – Finding SQL Server Service Restart Date-Time There are many ways to find out the date & … more →
T-SQL – To Get Graphical Execution Plan for Active Sessions
wrote 1 month ago: T-SQL – To Get Graphical Execution Plan for Active Sessions If you want to get the graphical executi … more →
T-SQL – To Check if Database are configured for Mirroring
wrote 1 month ago: T-SQL – To Check if Database are configured for Mirroring If you want to check whether the databases … more →
T-SQL – Checking Database Recovery Model
— 1 comment
wrote 1 month ago: T-SQL – Checking Database Recovery Model If you want to check current Database Recovery Model, then … more →
T-SQL – Monitoring Database Backup Status
wrote 1 month ago: T-SQL – Monitoring Database Backup Status Being an SQL Server DBA, it is very important to retrieve … more →
T-SQL – Finding Database Restore History
wrote 1 month ago: T-SQL – Finding Database Restore History Being an SQL Server DBA, it is very important to retrieve D … more →
T-SQL – Checking Database and Log file Location
wrote 1 month ago: T-SQL – Checking Database and Log file Location Using the below script you can easily find location … more →
T-SQL – Checking SQL Server Uptime
wrote 1 month ago: T-SQL – Checking SQL Server Uptime Microsoft SQL Server keeps tracks of all the processes, when they … more →
T-SQL – Checking SQL Server Version and Service Packs
wrote 1 month ago: T-SQL – Checking SQL Server Version and Service Packs Often, you will need to check for SQL Server v … more →
T-SQL – Checking Users and Processes Details
wrote 1 month ago: T-SQL – Checking Users and Processes Details If you want to check quickly what all processes are bei … more →
T-SQL – Monitor All Database Logs
wrote 1 month ago: T-SQL – Monitor All Database Logs One of the critical DBA’s job is to monitor the logs of the … more →
T-SQL – Reading SQL Error Logs
wrote 1 month ago: T-SQL – Reading SQL Error Logs sp_readerrorlog or xp_readerrorlog is a very handy system stored proc … more →
T-SQL – Finding Database Name and Size
wrote 1 month ago: T-SQL – Finding Database Name and Size sp_databases is a very handy system stored procedure to get d … more →
T-SQL – SQL Server Free Space Details
wrote 1 month ago: T-SQL – SQL Server Free Space Details xp_fixeddrives will list all the drives in the SQL Server. xp_ … more →
T-SQL – Finding Memory Utilization Information
wrote 1 month ago: T-SQL – Finding Memory Utilization Information Memory is one the most important factor affecting SQL … more →
T-SQL – Finding Database and Status Information
wrote 1 month ago: T-SQL – Finding Database and their Status Information sp_help is a very handy system stored procedur … more →
T-SQL: Finding SQL Server Information
wrote 1 month ago: T-SQL – Finding SQL Server Information sp_server_info is a very handy system stored procedure to get … more →
Microsoft-SQL Server SE/SSE/TL & Microsoft-SQL Server DBA SSE, 2-8 Years Exp, Walk-ins @ Hyderabad
wrote 1 month ago: Greetings of the Day! Dear Candidates, This is Metasoft Solutions, We have a job opportunity on Micr … more →
