×

TSQL Tuesday #79 -JSON Support in SQL 2016

June 14, 2016

I thank Michael J Swart (b|t) for hosting TSQL Tuesday #79. Topic for this month is to write about SQL Server 2016. This is my first time joining in TSQL Tuesday and I am excited about it. In my workplace, we use MongoDB besides SQL Server. MongoDB saves documents in the binary form of  JSON […]

Schedule SQL Agent Job With Availability Group

January 28, 2016

There was a tweet that came last night from Lohit about “need guidance on how to enable a set of jobs on secondary AG as soon as failover happens from primary to secondary AG”.  I have implemented a solution for most (I am using “most”  literally because I have not done this for all jobs) of […]

Allocation Pages In SQL Server

January 20, 2016

In order to understand how page/extent allocation works with in SQL Server for entities (objects) I was reading Paul Randal’s (B|T) blog. While reading different articles I thought of summarizing few critical information into a table. Which will help me consuming the information better and review easily when I need to. With Paul’s written consent […]

SQL Agent Jobs With Notification Enabled

January 8, 2016

DBA team that I worked with manage 170+ SQL Servers. We do not enable notification on any SQL Agent job. We centrally monitor all jobs and send a notification based on the tier (Business-critical). Last night on-call DBA got paged for a job failed in the server we are doing proof of concept. By looking […]

What Is Consuming My Log Space

October 2, 2015

Often times DBA’s (including myself at the beginning of my DBA career) struggle to find out what is causing the log files to grow. Or what is consuming all the space in my log files. I understand there are many factors that can impact the log file size besides all the active transactions. Such as: […]


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

I will be speaking at @PASSCloudVC in 3 hours.
10 am PST
1 pm EST
17:00 UTC

Azure SQL Database - Where is my SQL ... Agent?
Registration: https://cloud.pass.org/
#sqlpass #MVPBuzz

#SQLFriday is free Microsoft Data Platform training, delivered by top speakers from the Data Platform community every ... Friday lunch (12:00 CEST), to your computer. Join meetup group at https://meetup.com/Sql-Friday and check out the full schedule at https://sqlfriday.net/schedule

Call for Speakers has reopened! In light of #PASSsummit 2020 becoming a virtual event, we want to give you another ... chance to share your #data knowledge with the #sqlpass community, from anywhere in the world!

Apply Today: http://ow.ly/iuiX50zVWQ0

Load More...