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 MoreSQL 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 …
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 …
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 …
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 …
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 …
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 …
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 …
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 ( ( …
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 …
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 …
Read More