SQL Server Education (by the geeks, for the geeks)
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 …
sys.dm_exec_trigger_stats – Day 37 – One DMV a Day Read MoreHello 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 …
sys.dm_os_memory_pools – Day 22 – One DMV a Day Read MoreHello 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 …
sys.dm_os_memory_objects – Day 21 – One DMV a Day Read MoreHi 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 …
SQL Server aggregate operator – Stream Aggregate Part1 Read MoreHello 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 …
sys.dm_db_session_space_usage – Day 9 – One DMV a Day Read MoreI 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 …
SQL Server – SQL Agent Proxies Read MoreLast 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 …
SQL Server – Monitor SQL Server Services using Powershell Read MoreTo 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 ( ( …
Get comma separated list in SQL and MDX. Read MoreWhen 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 …
SQL Server: Master SQL Chef series: Implementing Availability feature #sql2k8r2cookbook Read MoreHi 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 …
SQL Server – Expiry date on SQL Server Certification Exams Read More