sys.dm_exec_trigger_stats – Day 37 – One DMV a Day
Hello Geeks and welcome to the Day 37 of the long series of One DMV a day. In this series of blogs I will be exploring and explaining the most useful …
Read MoreTag: SQL
sys.dm_os_memory_pools – Day 22 – One DMV a Day
Hello Geeks and welcome to the Day 22 of the long series of One DMV a day. In this series of blogs I will be exploring and explaining the most useful …
Read Moresys.dm_os_memory_objects – Day 21 – One DMV a Day
Hello Geeks and welcome to the Day 21 of the long series of One DMV a day. In this series of blogs I will be exploring and explaining the most useful …
Read MoreSQL Server aggregate operator – Stream Aggregate Part1
Hi Friends, Today, we will have a look into SQL Server aggregate operator – Stream Aggregate. This operator used to group some rows by one or more columns and to calculate …
Read Moresys.dm_db_session_space_usage – Day 9 – One DMV a Day
Hello Geeks and welcome to the Day 9 of the long series of One DMV a day. In this series of blogs I will be exploring and explaining the most useful …
Read MoreSQL Server – SQL Agent Proxies
I have seen many DBAs arguing on xp_cmdshell as a security risk or a bad practice. And on a strong recommendation of a DBA Architect VENDOR your company has chosen to …
Read MoreSQL Server – Monitor SQL Server Services using Powershell
Last month on 26th June I delivered a webcastHow to Monitor SQL Servers using Powershell – Part 1 under Microsoft Lunch Time Banner. For those who don’t know about Lunch Time Series …
Read MoreGet comma separated list in SQL and MDX.
To get comma separated list in SQL as well as in MDX use below queries. 1 – SQL Select Name from Sales.SalesReason GO Select Name from Sales.SalesReason SELECT SUBSTRING ( ( …
Read MoreSQL Server: Master SQL Chef series: Implementing Availability feature #sql2k8r2cookbook
When we talk about availability the key step in providing the feature is to ensure such feature is available and easily implemented. High Availability is purely dependant on hardware and software that …
Read MoreSQL Server – Expiry date on SQL Server Certification Exams
Hi Friends, I know most of you will not like it, but Now SQL Server Certification Exams will also come along with an Expiry Date. Microsoft is changing a few Certification …
Read More