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

SQL SERVER – Basic Calculation and PEMDAS Order of Operation

September 25, 2012

Personal, SQL, SQL Server, SQL Tips and Tricks

After thinking a long time, I have decided to write about this blog post. I had no plan to create a blog post about this subject but the amount of conversation this one has created on my Facebook page, I decided to bring up a few of the question and…

SQLAuthority News – Download SQL Server 2012 SP1 CTP4

September 23, 2012

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

There are few trends I often see in the industry, for example i) running servers on n-1 version ii) wait till SP1 to released to adopt the product. Microsoft has recently released SQL Server 2012 SP1 CTP4. CTP stands for Community Technology Preview and it is not the final version yet. The…

SQL SERVER – 2 T-SQL Puzzles and Win USD 50 worth Amazon Gift Card and 25 Other Prizes

September 20, 2012

Pinal Dave

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

NuoDB

We all love brain teasers and interesting puzzles. Today I decided to come up with 2 interesting puzzles and winner of the contest will get USD 50 worth Amazon Gift Card. The puzzles are sponsored by NuoDB. Additionally, The first 25 individuals who download NuoDB Beta 8 by midnight Friday, Sept.…

SQL SERVER – Effect of Collation on Resultset – SQL in Sixty Seconds #026 – Video

September 19, 2012

Pinal Dave

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

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

Collation is a very important concept but often ignored. I have often seen developers either not understanding this or ignored it – this is plain wrong. In simple word we can say Collation is the language or interpreting done by SQL Server. Well, in today’s SQL in Sixty Seconds we…

SQL SERVER – SSMS Automatically Generates TOP (100) PERCENT in Query Designer

September 18, 2012

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Server Management Studio, SQL View

Earlier this week, I was surfing various SQL forums to see what kind of help developer need in the SQL Server world. One of the question indeed caught my attention. I am here regenerating complete question as well scenario to illustrate the point in a precise manner. Additionally, I have…

SQLAuthority News – Download Whitepaper – Power View Infrastructure Configuration and Installation: Step-by-Step and Scripts

September 16, 2012

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Business Intelligence, Data Warehousing, SQL Download, SQL White Papers

Power View, a feature of SQL Server 2012 Reporting Services Add-in for Microsoft SharePoint Server 2010 Enterprise Edition, is an interactive data exploration, visualization, and presentation experience. It provides intuitive ad-hoc reporting for business users such as data analysts, business decision makers, and information workers. Microsoft has recently released very…

SQL SERVER – Core Concepts – Elasticity, Scalability and ACID Properties – Exploring NuoDB an Elastically Scalable Database System

September 13, 2012

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

NuoDB

I have been recently exploring Elasticity and Scalability attributes of databases. You can see that in my earlier blog posts about NuoDB where I wanted to look at Elasticity and Scalability concepts. The concepts are very interesting, and intriguing as well. I have discussed these concepts with my friend Joyti M and together we have come…