×

Which Node SQL Cluster was Running

February 20, 2015

While troubleshooting unplanned SQL cluster failover few questions are asked commonly. When did the last failover occur? How frequently you failover (planned and unplanned)? Did this happen recently? All these questions can be answered by this query.  Your output will depend on how frequently you recycle error log and retention of the error log. You […]

Optimize SQL Backup

January 13, 2015

Database backup is one of the regular tasks DBA’s perform but few explore all the options that are built in the product. Instead of exploring and using built in switches I noticed DBA’s try writing custom scripts or buying third party tools. I explored some of the options and was able to do a full […]

Find Transactional Replication Details

November 21, 2014

This will be a quick post about a script to find replication metadata in detail.  You need to run this in your distributor (where distribution database resides) server and filter in various ways depending on your needs.  Also, modify the order based on what you are looking for. Run where distribution database resides

Monitoring Transaction Replication Latency in Real Time

November 21, 2014

This post will give a practical solution with complete code to monitor SQL server transactional replication latency in real-time.  My solution assumes you are using a common distribution agent.  With the minor change, you can also implement this for independent distribution agents. This solution is an implementation of Kendra Little’s blog post. The concept is […]

WMI issue with SQL Server 2014

November 21, 2014

Issue: I installed sql2014 enterprise edition with cu3 in the following machine.  Just as a disclaimer I have been running a SQL 2012 edition on the same host without any issue with WMI counters. I could not see any WMI counters for sql2014.  I tried perfmon.exe and also querying: Then I snipped through SQL server […]


profile for SqlWorldWide on Stack Exchange, a network of free, community-driven Q&A sites

Kubernetes Learning Path

50-days from zero to
hero with Kubernetes

Download eBook

T - 7 days
@zippy1981
will be talking about: "Git for DBA"
Registration details:
... https://meetup.com/dbavug/events/279220662/

Wednesday, September 22, 2021
Pacific Noon
3 PM EST
7 PM GMT

#Git #GitHub #sourcecontrol
#database #sqlserver

Hey #AzureDataCommunity leaders, the info went out today for our Leader Summit in October. Check your inbox & add an... hour to your calendar that works best for your schedule. We're looking forward to connecting, networking and learning!

#DPS2021 Updates:
Starting now: Sessions by @dbanuggets, @tommartens68, Paul Ou Yang, @feaselkl, @pookamath, @blakhani
... Data+AI Gurukul by @jamesbroome_ , @chanmm
Join us for FREE: https://bit.ly/dps_2021
Thanks for RT
#Azure #analytics #AzureSQL #sql #SQLServer #PowerBI #DPS10

Surbhi Pokharna presents Applying a Security Mindset to Lock Down Azure SQL DB at #PASSDataCommunitySummit Register ... today! @PASSDataSummit #AzureSQL #Azure

Search the list of sessions here: http://ow.ly/NnUq50G2q6r and register for FREE today: http://ow.ly/J3YZ50G2pgu

Load More...
/* (function () { var s = document.createElement('script'); s.type = 'text/javascript'; s.async = true; s.src = 'https://app.termly.io/embed.min.js'; s.id = '4f4146f3-eaa6-4e46-8f46-3fc9f2223b5f'; s.setAttribute("data-name", "termly-embed-banner"); var x = document.getElementsByTagName('script')[0]; x.parentNode.insertBefore(s, x); })(); */