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

SQL SERVER – What is a Technology Evangelist?

January 27, 2011

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

When you hear that someone is an “evangelist” the first thing that might pop into your mind is the Christian church. In fact, the term did come from Christianity, and basically means someone who spreads the news about their faith. In the technology world, the same definition is true. Technology…

SQL SERVER – Denali – Clipboard Ring – CTRL+SHIFT+V

January 25, 2011

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Server Management Studio

While I was writing my earlier post SQL SERVER – 2011 – Multi-Monitor SSMS Windows, I found out that there is one more similar feature which existed in Visual Studio is also now part of SQL Server 2011 (Denali). The feature is called clipboard ring feature. This is how it works.…

SQL SERVER – Denali – Multi-Monitor SSMS Windows

January 24, 2011

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Scripts, SQL Server Management Studio

I have a dual screen arrangement at my home system. I love it because it’s very convenient. When I am working with SQL Server 2008 R2 or any earlier versions, I would want to use both of the Monitor so I open two separate SQL Server Management Studio and work along…

SQLAuthority News – Download Whitepaper – Enabling and Securing Data Entry with Analysis Services Writeback

January 23, 2011

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Documentation, SQL Download, SQL White Papers

SQL Server Analysis Service have many features which are commonly requested and many already exists in the system. Security Data Entry is very important feature and SSAS supports writeback feature. Analysis Services is a tool for aggregating information and providing business users with the ability to analyze and support decision…

SQL SERVER- Differences Between Left Join and Left Outer Join

January 22, 2011

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Joins, SQL Scripts

There are a few questions that I had decided not to discuss on this blog because I think they are very simple and many of us know it. Many times, I even receive not-so positive notes from several readers when I am writing something simple. However, assuming that we know…

SQLAuthority News – 1600 Blog Post Articles – A Milestone

January 21, 2011

Pinal Dave

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

It was really a very interesting moment for me when I was writing my 1600th milestone blog post. Now it`s a lot more exciting because this time it`s my 1600th blog post. Every time I write a milestone blog post such as this, I have the same excitement as when…

SQLAuthority News – Scaling Up Your Data Warehouse with SQL Server 2008 R2

January 20, 2011

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Documentation, SQL Download

Data Warehouses are suppose to be containing huge amount of the data from the beginning. However, there are cases when too big is not enough. Every Data Warehouse Admin will agree that they have faced situation where they will need to scale up their data warehouse. Microsoft has released white…