T-SQL Tuesday #95: Big Data

T-SQL Tuesday is a monthly blog party started by Adam Machanic (t|b). This month’s T-SQL Tuesday is being hosted by Derek Hammer (t|b).  Everyone is invited to this party. Participation is easy. Each month, members of the community write a blog post about the topic presented and post it on the second Tuesday of the month. …

Continue reading T-SQL Tuesday #95: Big Data

Advertisements

TSQL Tuesday #85 Backup, Restore, Repeat

This month’s T-SQL Tuesday is being hosted by Kenneth Fisher (t | b). T-SQL Tuesday (#TSQL2SDAY) is a blog party founded by Adam Machanic (t | b). Each month a member of the community hosts the party and selects the topic for us to write about. This month’s topic is backup and recovery. Backups are …

Continue reading TSQL Tuesday #85 Backup, Restore, Repeat

VMware vSphere 6.5 breaks your SQL Server vNUMA settings — Convergence of Data and Infrastructure

VMware’s latest release of the vSphere virtualization suite, version 6.5, changes how they handle vNUMA presentation to a virtual machine, and there’s a high likelihood that it will break your virtualized SQL Server vNUMA configuration and lead to unexpected changes in behavior. It might even slow down your SQL Servers. Here’s what you need to… via …

Continue reading VMware vSphere 6.5 breaks your SQL Server vNUMA settings — Convergence of Data and Infrastructure

SQL SERVER – Best Practices About SQL Server Service Account and Password Management — Journey to SQL Authority with Pinal Dave

This is a great read...especially for the new DBA.  There have been discussions in our office between DBAs and the Windows team on the best way to change the service account password.  See guys...you should listen to the DBA.  They always know the best! via SQL SERVER – Best Practices About SQL Server Service Account …

Continue reading SQL SERVER – Best Practices About SQL Server Service Account and Password Management — Journey to SQL Authority with Pinal Dave

How to Find Size of All the Indexes on the Database – Interview Question of the Week #097 — Journey to SQL Authority with Pinal Dave

Question: How to Find Size of All the Indexes on the Database? Answer: Just another day while I was doing SQL Server Performance Tuning for a leading organization, I was asked by if I have a query which brings out all the indexes on the table with its size. I love this kind of questions… via …

Continue reading How to Find Size of All the Indexes on the Database – Interview Question of the Week #097 — Journey to SQL Authority with Pinal Dave