SQL Archives - Page 189 of 519 - SQL Authority with Pinal Dave

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

January 11, 2014

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…

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 – 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…

SQL SERVER – Tools for Proactive DBAs – Central Management Server – Notes from the Field #009

January 2, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Notes from the Field, SQL Backup and Restore

[Note from Pinal]: This is a ninth episode of Notes from the Fields series. If you are DBA and Developer there is always a situation when you want to execute the same query on multiple servers. This can work out very well if you have a servers in single digit,…