Free Training: Videos from Tim Mitchell
I’m always on the looking our excellent training, especially free training. Tim Mitchell, Microsoft Data Platform MVP, (twitter | website) has...
2018-10-29
281 reads
Blogger Questions: What if I get a mean/rude comment?
There is a fear that almost every blogger has to overcome. I’ll be honest, it pops up almost every time...
2018-10-29
328 reads
T-SQL Tuesday 108 Invitation- Non SQL Server Technologies
I am proud and honored to be hosting T-SQL Tuesday again. This monthly blog party started by SQL Guru Adam...
2018-10-29
334 reads
PASS Summit 2018 - Let's Hang Out! Where to Find Me
In addition to being an amazing opportunity for both technical and professional development, PASS Summit is a #sqlfamily reunion and a huge networking event. Catching up with old friends,...
2018-10-29
39 reads
A lack of foreign keys – a bad culture example.
G’day,
One of the things that I’ve been seeing more often than I would like to lately is large databases with...
2018-11-06 (first published: 2018-10-28)
3,208 reads
Step-by-Step: How to Trigger an Email Alert from a Windows Event that Includes the Event Details using Windows Server 2016
Introduction
Setting up an email alert is as simple as creating a Windows Task that is triggered by an Event. You...
2018-10-28
1,872 reads
Here Comes the New Blog. Same as the Old Blog.
Welcome to the new home of my blog! I’ve had this domain for over a year but with PASS Summit 2018 coming up soon I decided it was time...
2018-10-28
21 reads
Overview of the SQL Insert statement
This article on the SQL Insert statement is part of a series on string manipulation functions, operators and techniques. The...
2018-10-26
390 reads
I have a broken leg
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the...
2018-10-25
430 reads
Protected: TSQL Tuesday 108 – Community Rituals
This post is password protected. You must visit the website and enter the password to continue reading.
Advertisements
2018-10-25
235 reads
Blogs
Why AI isn’t paying off yet, and what to invest in first
Why isn’t AI paying off yet? Drawing on lessons from digital transformation, Joyful Craftsmen...
Flyway Tips: Analytics Platforms (Snowflake and Databricks)
By Steve Jones
I’m really excited about some growth in Flyway support. I’ve been asking about this...
Paginated Reporting at Scale: Choosing the Right Microsoft Platform
By Rayis Imayev
"I've seen things you people wouldn't believe..."— Roy Batty, Nexus-6 Replicant, Blade Runner (1982)(2026-Nov-08) Yep,...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Too Many Choices
Comments posted to this topic are about the item Too Many Choices
Table Partitioning in SQL Server: A Practical Guide to Managing Very Large Tables (VLDBs)
Comments posted to this topic are about the item Table Partitioning in SQL Server:...
Question of the Day
Too Many Choices
I have a table, dbo.MasterBrands, with this data:
BrandID OfficialName 1 Samsung 2 Apple 3 Microsoft 4 Adidas 5 Coca-ColaI run this query. What is returned for Coca-Cola?
SELECT CHOOSE(BrandID, 'Conglomerate', 'Tech and Design', 'Desktop', 'Apparel') FROM dbo.MasterBrands;See possible answers