×

SQL Server Fullscan Statistics Being Overwritten with Sample Statistics

March 3, 2017

I observed this behavior only in the following version of SQL Server while using Always On Availability Group feature. Version: Microsoft SQL Server 2012 (SP3) (KB3072779) – 11.0.6020.0 (X64) Oct 20 2015 15:36:27 Copyright (c) Microsoft Corporation Enterprise Edition: Core-based Licensing (64-bit) on Windows NT 6.3 (Build 9600: ) In this article by David Barbarin […]

How to migrate a SQL database to Microsoft Azure SQL V12

March 2, 2017

This is a session about migrating on premise SQL database to Microsoft Azure SQL V12. I present the session to following user groups. North Boston Azure Cloud User Group on February 28, 2017. Capital Area SQL Server User Group, Albany, NY on May 9, 2017. Pass DBA Virtual Chapter on April 12, 2017 SQL Saturday […]

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 […]



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

RT: @DCACco: https://bit.ly/3QMQ3UF Are you a speaker in the #SQLServer community? Are you going to the #sqlpass ...summit? Time is running out to register for #SpeakerIdol. If you haven't registered already, get registered ASAP. There are only a few days… https://bit.ly/3Smx9VE

Fun, educational, and full of embarrassing stories! If you can make SQL Saturday Boston, then stop by this session for... laughs, groans, and some useful ways to keep the query optimizer working for you!

#SqlSaturday #SqlSatBoston

@SqlrUs will be talking about "Saving Yourself with Accelerated Database Recovery" at #sqlsatboston

Did you register?
...https://www.eventbrite.com/e/sql-saturday-boston-2022-tickets-380639893167

#sqlsaturday #database #sqlserver #ADR #MVPBuzz

@BryanCafferky will be talking about "Python & SQL Server: A Winning Combination" at #sqlsatboston

Did you ...register?
https://www.eventbrite.com/e/sql-saturday-boston-2022-tickets-380639893167

#sqlsaturday #python #SQLServer

@JohnMiner3 will be talking about "Security your delta lake with table access controls" at #sqlsatboston

Did you ...register?
https://www.eventbrite.com/e/sql-saturday-boston-2022-tickets-380639893167

#sqlsaturday #deltalake #security #encryption #MVPBuzz

Load More...