Speaking at IT/Dev Connections in October

I’m proud to be speaking at this year’s IT/Dev Connections conference in Las Vegas during the week of October 10th!...

Sql Server – Listing all tables Metadata (Table Size, row count, Index Size)

Sql Server – Listing all
tables Metadata (Table Size, row count, Index Size)

Suppose you need to find out Table size, row
count , index...

Sql Server - Top Slowest Queries or Resource Extensive Queries

Top
Slowest Queries or Resource Extensive Queries

Whenever your database is facing any performance issue or resource scarcity,
the first step should be...

SQL Server 2016 - Are you ready for upgrade?

SQL Server 2016 has been officially launched for a little more then three month, many people are feeling excited to...

SQLChat on Wednesday, Webinar on Thursday!

I’m participating in two community activities this week. One is a #SQLCchat on Twitter and the other is a webinar...

Team Purple

This is Down Tools Week at Redgate Software, and I’m visiting the office. I had hoped to dive into a...

Finding the Right Path

I have a fairly large backlog of articles that are in progress or that are planned for my series about...

October precon in Orlando: “The Lifecycle Approach: Maintenance Problems & Solutions”

On October 7 we will be presenting a full day of maintenance and backup learnin’! Register here: https://www.eventbrite.com/e/sql-saturday-564-the-lifecycle-approach-maintenance-problems-solutions-tickets-26867268724 And while you’re at...

SPACE

USE CASE: When we are working on TSQL or some text based scripting we may need some extra space in between...

STUFF

Use case when we are working on TSQL or Query ,some time we came such a situation when we need...