Tags » Microsoft SQL Server

Speaking at 24 Hours of PASS

On May 3, 2017, at 2 PM EDT (6 PM GMT) I’ll be speaking as part of the 24 Hours of PASS. Here’s what I’ll be speaking on: 178 more words


SSMS Tips: Copy Full Path

When you right click on a tab you’ll see a number of different options. You can set up new horizontal or vertical tab groups, … 53 more words

SQLServerPedia Syndication

SQL 2016 Temporal Tables.

Here is the situation for SQL DBA/Developer.

  1. A new startup company started with 5 employees, after an year no of employees grows to 100, subsequently 3-5 employees leaving in every month.
  2. 1,024 more words
Microsoft SQL Server

SQL 2016 Automatic Seeding of Availability Groups

–By Lori Brown

I came across something today that I did not know existed in AG’s, Automatic Seeding. This allows SQL to automatically create the secondary replicas for all databases in an AG. 325 more words

SQL Server

Thoughts about the Microsoft Data Amp Announcements

Microsoft conducted a live event called Microsoft Data Amp to announce a number of key features and releases for SQL Server on premises and data platforms in Azure (such as Azure SQL DB and Azure Data Lake). 411 more words

Microsoft SQL Server

When should I add an index?

We all know indexes are good and I’m hoping everyone knows you can have too many indexes. That means we should be careful when adding new indexes right? 754 more words

SQLServerPedia Syndication