This month's discount Comprehensive Database Performance Health Check · Testimonials
SQLAuthority with Pinal Dave
Home
  • Consulting
    • Health Check
  • Free Videos
  • All Articles
    • AI
    • SQL Performance
    • SQL Tips and Tricks
    • Interview Questions and Answers
    • SQL Puzzle
    • SQL Video
    • SQLAuthority News
    • Personal
  • Books
  • Consulting
Different column structures are cataloged in a single orderly stone rack

How to List All ColumnStore Indexes with Table Name in SQL Server? – Interview Question of the Week #153

December 24, 2017
Pinal Dave
SQL Interview Questions and Answers
Clustered Index, ColumnStore Index, SQL DMV, SQL Index, SQL Scripts, SQL Server

Question: How to List All ColumnStore Indexes with Table Name in SQL Server? As ColumnStore Indexes are getting more and more popular.

Read More
SQL SERVER - Fix: Error - VS Shell Installation Has Failed with Exit Code 1638

SQL SERVER – Fix: Error – VS Shell Installation Has Failed with Exit Code 1638

December 21, 2017
Pinal Dave
SQL Tips and Tricks
SQL Download, SQL Error Messages, SQL Scripts, SQL Server, SQL Server Installation

A customer’s SQL Server 2017 install kept failing with “VS Shell installation has failed with exit code 1638”. Here is what caused it and how we fixed it.

Read More
SQL SERVER - List Users with System Admin (sysadmin) Rights - Part 2

SQL SERVER – List Users with System Admin (sysadmin) Rights – Part 2

December 20, 2017
Pinal Dave
SQL Tips and Tricks
SQL DMV, SQL Login, SQL Scripts, SQL Server, SQL Server Security

After my post on listing users with System Admin (sysadmin) rights, Chris Mangrum shared a better script that also covers CONTROL SERVER. Here it is.

Read More
Distinct keys and a master key are inspected beside several different cabinet locks.

SQL SERVER – List Users with System Admin (sysadmin) Rights

December 18, 2017
Pinal Dave
SQL Tips and Tricks
SQL Login, SQL Scripts, SQL Server, SQL Server Security

I List Users with System Admin membership before agreeing on the permissions for a health check. This query inspects visible principals.

Read More
A still weaving loom continues to hold unfinished fabric under tension

How to Kill Processes Idle for X Hours? – Interview Question of the Week #152

December 17, 2017
Pinal Dave
SQL Interview Questions and Answers
SQL Connection, SQL Cursor, SQL Scripts, SQL Server, System Object

Interview question: how to kill processes idle for X hours in SQL Server? Here is a script that finds idle sessions and kills them.

Read More
Enable FILESTREAM for Transact-SQL access.

SQL SERVER – Always On Availability Group Failover Generating Dump. Error: 17066: SQL Server Assertion: HadrFstrVnnUtils.cpp:479

December 14, 2017
Pinal Dave
SQL Tips and Tricks
AlwaysOn, Disk, SQL High Availability, SQL Scripts, SQL Server

A client’s availability group failover across subnets got stuck in Resolving and generated dumps with Error 17066. Here is what we found and how we fixed it.

Read More
Error dialog box.

SQL SERVER – FIX: Msg 15150 – Cannot Alter The User ‘dbo’.

December 12, 2017
Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Login, SQL Scripts, SQL Server, SQL Server Security

Deploying SharePoint, a client tried to change the dbo mapping and got Msg 15150: Cannot alter the user ‘dbo’. Here is why it happens and how to fix it.

Read More
Previous 1 … 109 110 111 112 113 114 115 … 363 Next
  • Books
  • Testimonials
  • Privacy Policy

© 2006 – 2026 All rights reserved. pinal @ SQLAuthority.com