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

SQL SERVER – Find Anything in Object Explorer in SSMS

February 26, 2014

This blog post is a follow up post of an excellent write up by my friend Vinod Kumar. I suggest you read his blog post here SSMS Tips–Object Explorer Details. After reading his blog post, I called him up and had an interesting conversation with him. Here is our conversation:…

MySQL – Profiler : A Simple and Convenient Tool for Profiling SQL Queries

February 25, 2014

Pinal Dave

SQL

Devart, MySQL, SQL Utility

In terms of working with highly loaded databases, any badly-designed request can cause significant performance degradation. Depending on the used DBMS features, various methods are used for query optimization. However, a general rule can be pointed out for all types of DBMS: the fewer server resources are expended when executing…

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

February 24, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Notes from the Field

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…