All Articles - SQL Authority with Pinal Dave

SQL SERVER – 7 Essential Tools to Support Core Database Administration – SQL DBA Bundle

January 13, 2014

The biggest fear of any DBA is that something will happen to the server he is monitoring after of hours and he will have to run back in the middle of the night to fix it. There are two main sources of anxiety for the DBA 1) Users who make…

MySQL – Change the Limit of Row Retrieved in MySQL Workbench

January 12, 2014

Pinal Dave

SQL, SQL Tips and Tricks

MySQL, SQL Server

MySQL Workbench is default IDE for MySQL. It can be installed on Windows, Linux or Mac OSX. Here is the one question which new users of MySQL Workbench often ask –

“When I execute my SQL Query from my application, it retrieves correct numbers of the row, but when I execute the same query in MySQL Workbench it retrieves only 1000 records. What is the reason behind it?”

SQL SERVER – Create Unique Constraint on Table Column on Existing Table

January 11, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Constraint and Keys

Here is the question I received on twitter. “Can we create a unique constraint on table column on Existing Table?” Of course Yes! Here is how you can create a unique constraint on the table which already exist in our system. USE tempdb GO -- Create Table CREATE TABLE Table1…

MySQL – Learn MySQL Online – 8 MySQL Courses at Pluralsight

January 10, 2014

Pinal Dave

SQL Tips and Tricks

MySQL, Pluralsight

At the beginning of the year 2013, I had decided to widen my focus with related to database. I have been writing a lot about SQL Server throughout this day, but the reality is that I have been equally focused on MySQL as well. A few years ago, MySQL was…

SQL SERVER – Auditors, Passwords and Exceptions – Notes from the Field #010

January 9, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Notes from the Field, SQL Backup and Restore, SQL Server Security

[Note from Pinal]: This is a 10th episode of Notes from the Field series. Every other day, I read online about various security breach happening worldwide – some have lost passwords, some have lost phone numbers and some have lost credit card information. Security is the most important aspect of…

SQL SERVER – How to Survive on Free Tools for Month – Enjoy Refactoring – ApexSQL Refactor

January 8, 2014

Pinal Dave

SQL

ApexSQL

ApexSQL Refactor is a free SQL Server Management Studio and Visual Studio add-in for database refactoring and SQL code formatting. ApexSQL Refactor has 11 databases and SQL code refactors including:

MySQL – Locate the Configuration File – my.ini or my.cnf on Windows Platform

January 7, 2014

Pinal Dave

SQL, SQL Tips and Tricks

MySQL

Since the release of my MySQL course on Performance Tuning and Optimization, I have received quite a few questions on MySQL. The top most questions which I have received is how to find my.ini or my.cnf file on Windows Platform. This is a fantastic question and I can understand the…

SQL SERVER – Start Services or Stop Services with PowerShell – Answer to Question

January 6, 2014

Pinal Dave

SQL Tips and Tricks

Powershell, SQL Server Services

You can check out the original post here: SQL SERVER – Start Services or Stop Services with PowerShell – Question to Readers?.

All Articles powershell-shutdown-600x200

SQL SERVER – Start Services or Stop Services with PowerShell – Question to Readers?

January 5, 2014

Pinal Dave

SQL, SQL Puzzle, SQL Server, SQL Tips and Tricks

Powershell, SQL Server

Recently I received a very interesting question- I have no idea about its answer so I will request your help to answer this question.
Question:
“I am using a Powershell script to shutdown SQL Services. Here is the command I use.

Developers – Seven Foods Developers Love

January 4, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Humor

I am a developer and I have certain food choices. When I look around, I see many more developers and interestingly enough, I have noticed their eating habits very closely. It seems that all the developer has similar taste in food. Here is a quick list of the food which…