Blog Home Page - Page 241 of 828 - SQL Authority with Pinal Dave

Aug26

SQL Server Management Studio (SSMS) – Unable to Connect to SSIS – The Specified Service Does Not Exist as an Installed Service

SQL Error Messages, SQL Scripts, SQL Server, SQL Server Management Studio, SSIS, SSMS

After installing the latest version of SSMS (17.2), I was not able to connect to SQL Server Integration Services SSIS on my local machine.

Aug25

SCOM – Alert: SQL Server Cannot Authenticate Using Kerberos Because the Service Principal Name (SPN) is Missing, Misplaced, or Duplicated

Pinal Dave

SQL

SQL Error Messages, SQL Server, SQL Server Security

This blog explains what needs to be done when there are tools which can monitor and report issue about SPNs. Once a client informed that SCOM (System Center Operations Manager) is connected to the databases on SQL Server and raising below warning regarding the SQL Server (Service Principal Name) SPNs:

Aug24

SQL SERVER – Puzzle – Write a Shortest Code to Produce Zero

Pinal Dave

SQL Puzzle

SQL Function, SQL Scripts, SQL Server

726

Puzzle: Write a Shortest Code to Produce Zero.

Aug23

SQL SERVER – Learning DATEDIFF_BIG Function in SQL Server 2016

Pinal Dave

SQL Tips and Tricks

SQL DateTime, SQL Function, SQL Scripts, SQL Server

One of the T-SQL functions introduced in SQL Server 2016 is DATEDIFF_BIG function.

Aug22

SQL Authority News – Community Hub by Redgate

It is not possible that readers of SQLAuthority.com is not aware of amazing tools built by Redgate. We all know that Redgate builds tool which makes SQL DBA and Developer’s life easier. We can eliminate human errors and improve our efficiency. Redgate software along with helpful tools also produces a very interesting content for DBA and Developers. I am excited to see that Redate has recently announced Community Hub.

Aug21

SQL Server Management Studio – New Feature – Object Explorer Query Tracking

Pinal Dave

SQL Tips and Tricks

SQL Scripts, SQL Server, SQL Server Management Studio, SSMS

A few days ago, I wrote a blog about a new feature in SSMS and I got few emails asking me to share such quick and fresh information. You can read my earlier blog here SQL Download – SQL Server Management Studio (SSMS) – Performance Dashboard. In this blog post we will learn about the brand new feature called Object Explorer Query Tracking.

Aug20

How to Allow Only Alphabets in Column? – Interview Question #136

Pinal Dave

SQL Interview Questions and Answers

SQL Constraint and Keys, SQL Function, SQL Scripts, SQL Server

Question: How to Allow Only Alphabets in Column? Answer: This was a real world scenario and I have mixed feeling about this kind of question.

Pinal Dave is an SQL Server Performance Tuning Expert and independent consultant with over 22 years of hands-on experience. He holds a Masters of Science degree and numerous database certifications.

Pinal has authored 14 SQL Server database books and 100 Pluralsight courses. To freely share his knowledge and help others build their expertise, Pinal has also written more than 5,800 database tech articles on his blog at https://blog.sqlauthority.com.

Pinal is an experienced and dedicated professional with a deep commitment to flawless customer service. If you need help with any SQL Server Performance Tuning Issues, please feel free to reach out at pinal@sqlauthority.com.

Pinal is also a CrossFit Level 1 Trainer (CF-L1) and CrossFit Level 2 Trainer (CF-L2).

Nupur Dave is a social media enthusiast and an independent consultant. She primarily focuses on the database domain, helping clients build short and long-term multi-channel campaigns to drive leads for their sales pipeline.

Is your SQL Server running slow and you want to speed it up without sharing server credentials? In my Comprehensive Database Performance Health Check, we can work together remotely and resolve your biggest performance troublemakers in less than 4 hours.

Once you learn my business secrets, you will fix the majority of problems in the future.

Have you ever opened any PowerPoint deck when you face SQL Server Performance Tuning emergencies? SQL Server Performance Tuning Practical Workshop is my MOST popular training with no PowerPoint presentations and 100% practical demonstrations.

Essentially I share my business secrets to optimize SQL Server performance.