This month's discount Comprehensive Database Performance Health Check · Testimonials
SQLAuthority with Pinal Dave
Home
  • Consulting
    • Health Check
  • Free Videos
  • All Articles
    • AI
    • SQL Performance
    • SQL Tips and Tricks
    • Interview Questions and Answers
    • SQL Puzzle
    • SQL Video
    • SQLAuthority News
    • Personal
  • Books
  • Consulting
Gouache painting: four notebooks fanned out on a wooden lectern, one notebook vermilion

Great Indian Developers Summit 2014: Four Sessions

May 9, 2014
Pinal Dave
SQLAuthority News
Conferences, GIDS, MySQL, SQL Performance, SQLAuthority Author Visit

I presented four sessions at the Great Indian Developers Summit 2014 in Bangalore, and the rooms were standing room only. This post has my photographs from the event and the abstract of each session.

Read More
communication

Developer’s Life – Attitude and Communication – They Can Cause Problems – Notes from the Field #027

May 8, 2014
Pinal Dave
SQL Tips and Tricks
Developer, Notes from the Field

Sometimes there are incidents when our attitude creates confusion in the communication and we end up creating a situation which is absolutely not warranted.

Read More
SQL SERVER - What is SSAS Tabular Data Model and Why to Use It - Part 2

SQL SERVER – What is SSAS Tabular Data Model and Why to Use It – Part 2

May 7, 2014
Pinal Dave
SQL Tips and Tricks
SQL Analysis Services

Part 2 of my SSAS Tabular Data Model series: define measures in your tabular project and then analyze the results in Excel, step by step.

Read More
SQL Server 2014 compatibility settings.

SQL SERVER – How to Change Compatibility of Database to SQL Server 2014

May 6, 2014
Pinal Dave
SQL Tips and Tricks

Attached an old database to SQL Server 2014 and cannot use the new features? Here is how to change compatibility of database to level 120, two ways.

Read More
A derailleur seats a chain on one sprocket while a loose chain has no defined engagement

Unambiguous Date Literals: When 2026-04-03 Becomes March 4

May 5, 2014
Pinal Dave
SQL Tips and Tricks
SQL Datatype, SQL DateTime, SQL Stored Procedure

A dashed date can change its mind with one session setting. Here is how to write dates that never do.

Read More
Four toolboxes of increasing size in a row on a workshop floor, lids open, each one holding more tools than the last.

Which SQL Server Edition Do You Need?

May 4, 2014
Pinal Dave
SQL Tips and Tricks
Best Practices, SQL Download, SQL Server, SQL Server Installation

Which SQL Server edition do you need? Express, Developer, Standard and Enterprise compared in plain terms, plus the licensing trap where a free Developer Edition quietly ends up running the business.

Read More
Steel boules scattered around a small red jack on a gravel square, some close, some far

Unstable Queries: Finding Wide Duration Swings in Query Store

May 3, 2014
Pinal Dave
SQL Performance
Execution Plan, Query Store, SQL DMV, SQL Server

Find unstable queries with Query Store duration spread, weight averages, and separate plan changes from waits and parameter effects.

Read More
Previous 1 … 432 433 434 435 436 437 438 … 845 Next
  • Books
  • Testimonials
  • Privacy Policy

© 2006 – 2026 All rights reserved. pinal @ SQLAuthority.com