SQL Tips and Tricks Archives - Page 140 of 536 - SQL Authority with Pinal Dave

SQL SERVER – How to Add User Across Databases

March 9, 2015

In this era of standards, many organizations want to be using some of the cutting edge technologies in their organizations. In many of these interactions I was lucky enough to meet few DBA’s who give me interesting challenges to meet within their organizations. I still vividly remember sharing a script…

Interview Question of the Week #010 – What is the Difference Between Primary Key Constraints and Unique Key Constraints?

March 8, 2015

Pinal Dave

SQL, SQL Interview Questions and Answers, SQL Server, SQL Tips and Tricks

I often see people getting confused between Primary Key and Unique Key. I see where people get confused about the same. Let us discuss. Question: “What is the Difference Between Primary Key Constraints and Unique Key Constraints?” Answer: “Primary Key (PK) Constraints enforce uniqueness just like Unique Key (UK) Constraints,…

SQL SERVER – Using Buffer Pool Extension with In-Memory OLTP?

March 7, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

In-Memory OLTP

I am always amazed to see the questions asked by my blog reader which lead me to learn more about SQL Server. Here is the question which took me little time to figure out the answer. If you are new to SQL Server 2014 new features which I have in…

SQL SERVER – ReadOnly Databases with ReadOnly File Attribute

March 6, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Backup and Restore

As part of continued series of ReadOny databases, the earlier blog had an interesting comment that read as some people were getting errors of 5120 and others. This got me curious and was in the pending list of solutions in some way. One of the readers had mailed me saying,…

SQL SERVER – Using Raw Files in SSIS – Notes from the Field #070

March 5, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Notes from the Field, SSIS

[Notes from Pinal]: SSIS is very well explored subject, however, there are so many interesting elements when we read, we learn something new. A similar concept has been Using Raw Files in SSIS. Linchpin People are database coaches and wellness experts for a data driven world. In this 70th episode…

SQL SERVER – Database Stuck in “In Recovery” Mode After Restart

March 4, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Backup and Restore

Read this blog and I am sure it will bring some instances in your environments. This is one of the common issues I have observed while working with SQL Server from long time now. In this blog we will discuss little details about the issue and possible action you might…

SQL SERVER – Security Conversations and Notes with a DBA

March 3, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Server Security

One of the great things about working in Pluralsight is that I get to meet a lot of people (trust me on this). I am lost for words when it comes to how my day job helps me in achieving some of the coolest things presentations at a number of…