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
A small field easel in a meadow with a palette and three brushes

A Minimal BI Stack on SQL Server

September 19, 2009
Pinal Dave
SQL Tips and Tricks
Business Intelligence, Data Warehousing, SQL Reports, SQL Server, SQL Server Agent

A minimal BI stack can start with SQL Server tables, stable views, one scheduled load, and one reporting tool that a small team can run.

Read More
SQL SERVER - What is Data Mining - A Simple Introductory Note

SQL SERVER – What is Data Mining – A Simple Introductory Note

September 3, 2009
Pinal Dave
SQL Tips and Tricks
Business Intelligence, Data Warehousing

What is data mining? A simple introductory note on finding hidden patterns in large data, with a supermarket example and who takes part in the work.

Read More
SQLAuthority Author Visit - Ahmedabad SQL Server User Group Meeting - November 2008 - Meeting Report

SQLAuthority Author Visit – Ahmedabad SQL Server User Group Meeting – November 2008 – Meeting Report

December 5, 2008
Pinal Dave
SQLAuthority News
Best Practices, Data Warehousing, Database, DBA, MVP, SQL Backup and Restore, SQL Download, SQL Scripts, SQL User Group, SQLAuthority Author Visit

Recap of the November 29, 2008 Ahmedabad SQL Server User Group Meeting: my Backup and Compression session, with Jacob Sebastian live from New York.

Read More
SQL SERVER - Guidelines and Coding Standards Complete List Download

SQL SERVER – Guidelines and Coding Standards Complete List Download

September 25, 2008
Pinal Dave
SQL Tips and Tricks
Best Practices, Data Warehousing, Database, DBA, SQL Coding Standards, SQL Constraint and Keys, SQL Cursor, SQL Data Storage, SQL Download, SQL Function, SQL Index, SQL Joins, SQL Scripts, SQL Server Security, SQL Stored Procedure, SQL Trigger, SQL Utility

My coding standards complete list for SQL Server, cut to what people follow: naming, formatting, and the rules that prevent real bugs.

Read More
SQL SERVER - 2008 - Interview Questions and Answers - Part 8

SQL SERVER – 2008 – Interview Questions and Answers Part 8

September 19, 2008
Pinal Dave
SQL Interview Questions and Answers
Data Warehousing, Database, SQL Data Storage, SQL Function, SQL Index, SQL Scripts, SQL Server DBCC, SQL Utility

SQL Server 2008 Interview Questions and Answers Part 8 starts with Data Compression: how row compression and page compression work and save space.

Read More
Title card: SQL Interview Questions and Answers: Part 2

SQL SERVER – Interview Questions and Answers – Part 2

September 13, 2008
Pinal Dave
SQL Interview Questions and Answers
Data Warehousing, SQL Constraint and Keys, SQL Cursor, SQL Function, SQL Index, SQL Joins, SQL Scripts, SQL Server, SQL Stored Procedure

This is the second part of the blog post series Interview Questions and Answers.Click here to get free chapters (PDF) in the mailbox

Read More
SQLAuthority News - Microsoft SQL Server 2008 Report Builder 2.0

SQLAuthority News – Microsoft SQL Server 2008 Report Builder 2.0

August 27, 2008
Pinal Dave
SQL Tips and Tricks
Data Warehousing, Database, DBA, SQL Download, SQL Server, SQL Utility

Download Report Builder 2.0 for SQL Server 2008 Reporting Services, with table, matrix and chart wizards, plus a note on SQL Server 2008 R2 Report Builder 3.0.

Read More
Previous 1 … 5 6 7 8 9 10 Next
  • Books
  • Testimonials
  • Privacy Policy

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