Db/Data

DATABASE
Design Trends
Michael Stonebraker (Podcast)
Kevin Kline (Podcast)
Andrew Brust (Podcast)
Performance
Glen Berry (Diagnostic Queries
PlanExplorer
SqlPerformance.com Questions
Answers.SqlPerformance.Com
SqlPerformance.com
StatisticsParser.Com
SQLID Tutorial : Disk Performance
Data Auditing
What, When and who? Auditing 101
Unit Testing
Database unit testing, are we all doing it wrong?
Database Connectivity
ADO.Net Team Blog
SQL Server 2008 Table-Valued Parameters and C# Custom Iterators: A Match Made In Heaven!

The Connection Strings Reference
Sql Server
Transact-Sql
Transact-Sql Reference
Catalog Views Reference
Sql Server 2014 Data Types
Sql Server Built-in Functions
Sql Server 2014 Analytic Functions
Sql Server 2014 Ranking Functions
T-SQL String Manipulation Tips and Techniques, Part 1
Sql Server 2014 Configuration Functions
SERVERPROPERTY
Hierarchyid Data Type Method Reference
5 TSql Features You’re Missing Out On
SQL Server with Windows PowerShell Cmdlets
Database JSON
Frequently Asked Questions about JSON in SQL Server
JSON in SQL Server 2016: Part 1 of 4
Importing JSON files into SQL Server using OPENROWSET (BULK)
User/Session Functions
SUSER_SNAME()
SUSER_NAME()
USER_NAME()
CURRENT_USER()
IS_MEMBER()
IS_ROLEMEMBER()
IS_SRVROLEMEMBER
SESSION_USER
SYSTEM_USER()
ORIGINAL_LOGIN()
Sql Server Security
Schema-Based Access Control for Sql Server Databases
Ownership Chaining Good and Evil
Giving Permissions through Stored Procedures
Powershell with Sql Server
Import the SQLPS Module
Sql Server Extended Events
Extended Events
Understanding T-SQL Expression Short-Circuiting
Identity Functions
@@IDENTITY
IDENT_CURRENT
SCOPE_IDENTITY
Service Broker
Service Broker
Service Broker Sample –
Performance (Service Broker)
Service Broker Sample: Asynchronous Triggers
Reusing Conversations
Recycling Conversations
Resending Messages
Writing Service Broker Procedures
How to Troubleshoot Service Broker Problems
SQL Server DENALI: Service Broker Troubleshooting made easy
Troubleshooting Tools (Service Broker)
Removing Poison Messages
Track Data Changes
Track Data Changes
Change Data Capture
Errors
THROW/RAISERROR
Tuning
Tuning SQL Server Stored Procedures with Kim Tripp (Podcast)
Prepared Statements and Caching (Kimberly Tripp/SqlSkills)
SET Options That Affect Results
sys.dm_exec_procedure_stats
sys.dm_exec_sessions
Testing
TSql-T
Introducing Unit Testing for Sql Server Database Projects (webcast)
Test Data Generation
XACT_ABORT
Use Caution with Explicit Transactions in Stored Procedures
Filestream, FileTables and Fulltext
Filestream Directory Structure
FileStream and FileTable Resources Semantic Search
Administration
Accidental DBA
Ola Hallengren
Jason Strate (\Sql Plan Cache Resources)
Sql Server Indexing Strategy – Kimberly Tripp (Podcast)
sp_whoisactive
Extended Events
Understanding the sql_text Action in Extended Events
Gotchas (alleged)
UPDATE statement
MERGE statement
Expertise
SqlSkills.com
SqlPass
Data Idol
Miscellaneous
Myth: Most Selective First

NOSQL
MongoDb
MongoDb
MongoDb Ecosystem
Install MongoDB Community Edition on Windows
Redis
MSOpenTech/redis (forked from antirez/redis)
Redis Quick Start
Redis Documentation
Data Types – Redis
StackExchange.Redis (.NET driver)
How to Use Azure Redis Cache
Graph Databases
Using Graph databases for data lineage
Transactions/Consistency
Transactions in Raven Db

BIG DATA
Azure Big Data Blog
Sharding IDs at Instagram
HighScalability.com

DATA WAREHOUSING/BI
Bill Inmon
Vincent Rainardi
MSBI Academy (not many updates lately?)
Technet Integration Services Page
ETL
1TB in 30 minutes
Simon Sabin on Sql Down Under
MDX/DAX
Chris Webb on Sql Down Under (Podcast)
Bill Pearson articles on MDX/DAX
Microsoft BI
Power BI – Get Started for Free

SSIS
Simple Talk (SSIS)
SSIS 2012 – Advanced Functionality of Dtexec.exe
SSIS Addins (2009 article)
Top 10 SSIS Best Practices

SSAS/BI
Business Intelligence
SqlBI
SSAS
Analysis Services Resource Hub
Multidimentionsal/Tabular
DMX
Chris Webb
DAX
DAX Reference
DAX Formatter
DaxPatterns
Data Mining
Sql Server Analysis Services Data Mining

DATA SECURITY
Simon Sabin

DATA MODELLING
Database Answers

DATA VISUALISATION
The Work of Edward Tufte

DATA
Yahoo Query Language
Introduction to OData
OData Libraries
World Bank Data
Reference Data
UK Bank Holidays
Datasets
Information (Government Data)
Global Open Data Index
AWS Public Datasets
Azure Data Market
Google Public Data
United Kingdom
Ordnance Survey
Data.Gov.UK
ONS UK
Land Registry Transaction Data
United States
Data.Gov
NASDAQ Historical Data
US Department of Commerce Bureau of Econonmic Affairs
Canada
Canada Mortgage and Housing Corporation
Statistics Canada
International
World Bank
World Bank Commodity Prices
Miscellaneous
KDNuggets
WikiData

DATABASE CONSISTENCY
Kyle Kingsbury on Consensus in Distributed Systems (Podcast: SE-Radio Episode 241)
Sean Cribbs – Eventually Consistent Data Structures

BLOGS/COLUMNS
Brent Ozar
Joe Celko (Red Gate)
Darwen/Date
Erin Stellato
Oracle
Oracle Magazine
Jonathan Lewis
Sql Server
Phil Factor
SQL Server Data Tools Team Blog
Blog Aggregations
Sql Blog
Sql Server Central
Michelle Ufford (sqlfool.com)

GLOSSARY (Data Warehouse/Business Intelligence)
Drilling Down, Up and Across
Drillthrough
Jumbo Frame
NewOLTP (see NewSql)
NUMA
OLAP
ROLAP
Type 0 Slowly Changing Dimension

GLOSSARY (Database etc.)
ACID
Application Database
BASE/Eventual Consistency
CAP Theorem
CDC
CRDT
Blue-Green Deployment
Data Lake
Data Vault Modeling
DMV (Sql Server)
Document Database (NoSql)
Integration Database
MARS (Sql Server)
Micro-ORMs
MOLAP
NewSql
ODS
OTLT
RCSI
Sargable
Sharding