Blog Home Page - Page 478 of 831 - SQL Authority with Pinal Dave

Apr21

SQLAuthority News – Women in SQL – Youngest SQL Speaker – Bangalore SQL User Group Event on April 20, 2013

SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News

It was a great day today as at a SQL Bangalore User Group we had an event “Women in SQL” day. This event was one of the milestone event as in India there was no UG in my knowledge had done an event where we appreciated “Women Power”. We had…

Apr20

SQL SERVER – Weekly Series – Memory Lane – #025

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Memory Lane

No Comments

Here is the list of selected articles of SQLAuthority.com across all these years. Instead of just listing all the articles I have selected a few of my most favorite articles and have listed them here with additional notes below it. Let me know which one of the following is your…

Apr19

SQL SERVER – How to Begin with VMware – Introduction to Virtualization

Pinal Dave

SQLAuthority News

SQL Training, Virtualization, VMWare

No Comments

Virtualization has slowly crept in and made its rightful place into enterprises of all sizes and segments today. More and more organizations are realizing the importance of virtualization and adopting this revolutionary technology in its entirety. However, for a beginner, it is pretty confusing. The market is flooded with various vendors offering a slice of this technology in various forms and features.

Apr18

SQL SERVER – Using SSIS to Import CSV File into Salesforce Online Database with dotConnect for Salesforce from Devart

Pinal Dave

SQL

CSV, Devart

I have previously written article how one can import a CSV file into a database table using SSIS package. This was a simple import operation when the CSV file structure corresponded to the table structure column-to-column. However SQL Server Integration Services is a very powerful tool that can be used for much more complex data import CSV operations.

Apr17

SQL SERVER – Remove Cached Login from SSMS Connect Dialog – SQL in Sixty Seconds #049

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks, SQL Video

Database, SQL in Sixty Seconds, SQL Scripts, SQL Server Management Studio, sqlcmd

One of the most annoying thing which I have personally come across is drop down list of Server Lists on Connect dialog in SQL Server Management Studio. Here are two of the cases when I want to delete something from SSMS Connect Screen: 1) Incorrect server name typed 2) Server…

Apr16

SQL SERVER – Get High Availability with SQL Server 2012

Pinal Dave

SQL Tips and Tricks

AlwaysOn, SQL High Availability, SQL Server

The SQL Server 2012 offers a plethora of solutions for high-availability that assures 99.999% server and database Availability. These solutions enhance database and server availability, hide the failures of software or hardware and maintain application availability to curtail user downtime. It simplifies management and deployment of high availability systems with incorporated monitoring and configuration tools. It also enhances performance and cost efficiency of IT utilizing up to four Active Secondary. An SQL Server 2012 High Availability course helps you develop capabilities that contribute in taking your career to new horizons. Some of the key capabilities are utilizing standby hardware to the fullest, implementing disaster recovery and high availability and raising the total application uptime significantly.

Apr15

SQLAuthority News – Excellent Experience at TechEd India 2013 Bangalore and Pune – Photo Journey

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News

SQLAuthority Author Visit

TechEd is the premier event from Microsoft and it is always pleasure to be part of the TechEd. This year I attended my fifth TechEd and I had presented at this event 4th time in the row. Presenting at TechEd is fun as there is a totally different level of…

Pinal Dave is an SQL Server Performance Tuning Expert and independent consultant with over 24 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 109 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.

Shaivi Pinalkumar Dave is a book author and a women’s artistic gymnast.

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.