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

SQL SERVER – Contest Post – Notes from the Field – Learning Performance Tuning and Database Health

February 24, 2014

One of the most appreciated and loved the series on SQLAuthority.com is Notes from the Field. I often received how did I come up with the idea behind it. Here is the story for the same. Inceptions of Notes from the Field There are two aspects of any technology 1)…

SQLAuthority News – Two Whitepapers from AzureCAT Team on SQL Database

February 23, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Recently I was reading about SQL Database on Azure. There are lots of confusion around SQL Database around SQL Azure and I have been looking for a good authentic documentation which I can refer as well as I can use that in my day job. After a quick research I…

SQLAuthority News – 4 Whitepapers on Windows Azure

February 22, 2014

Pinal Dave

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

SQL White Papers

Windows Azure is getting quite a lot of traction in the industry and I often get questions about if there is authentic learning on this subject. Microsoft has published following 4 white paper which covers many interesting topics related to SQL Server and Windows Azure. Application Patterns and Development Strategies…

SQL SERVER – Statistical Analysis in SQL Server – A Quick Introduction

February 21, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Scripts

SQL Server has very few statistical functions. Oracle has lots of them. XLeratorDB closes the gap. If you want to try out the example of this blog post, I suggest you download the 15-day free trial of XLeratorDB NOW. Most SQL Server users would never think of T-SQL as a…

SQL SERVER – Finding the Last Backup for All Databases – Notes from the Field #016

February 20, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Notes from the Field, SQL Backup and Restore

[Notes from Pinal]: During my presentation, I always ask developer a simple question – When did you take your last database backup? I get two different kinds of answers – 1) few replies with No Idea and 2) few replies with some date time. When I further ask if they…

MongoDB and MySQL – Comparing Scalability, Data Distribution & Query Model – Part 3

February 19, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

MongoDB, MySQL, ScaleBase

Note: This blog post part 3 of the series and you can download 30-day trial of ScaleBase to practice the concepts. In this article comparing MongoDB and MySQL scalability, I want to focus on query models. We’ve previously discussed how MongoDB and ScaleBase are both highly scalable distributed databases, where…

MongoDB and MySQL – Comparing Scalability, Data Distribution & Query Model – Part 2

February 18, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

MongoDB, MySQL, ScaleBase

Note: This blog post part 2 of the series and you can download 30-day trial of ScaleBase to practice the concepts. In a previous article comparing MongoDB and MySQL, we saw how MongoDB and MySQL with ScaleBase execute auto-sharding, a key technique to deliver database scalability. In MongoDB, any joins…