Tim Mitchell

Tim Mitchell is a business intelligence consultant, author, trainer, and Microsoft Data Platform MVP with over fifteen years of data architecture experience. He is the founder and principal of Tyleris Data Solutions.

Tim has spoken at international and local events including the SQL PASS Summit, SQLBits, SQL Connections, along with dozens of tech fests, code camps, and SQL Saturday events. He is author of the book The SSIS Catalog, coauthor of the book SSIS Design Patterns, and is a contributing author on MVP Deep Dives 2.

You can visit his website and blog at TimMitchell.net or follow him on Twitter at @Tim_Mitchell.
  • Interests: SQL Server, Data Warehousing, ETL, .NET development

Blog Post

My Office Setup

At the PASS Summit a few weeks ago, I had a great chat with some folks about our home office setups. More and more of us are working from...

2022-12-16 (first published: )

282 reads

Blog Post

Returning to PASS Summit

In just a couple of weeks, the PASS Summit will return to Seattle, Washington. This one will be extra special, since it’s going to be the first in-person Summit...

2022-10-31

6 reads

Blog Post

Creating a Generic SSRS Report

Creating useful reports is part art and part science. On one end of the spectrum, you have visually appealing and highly customized reports and dashboards that are truly works...

2022-04-13 (first published: )

422 reads

Blog Post

Connecting to SharePoint Lists with SSIS

SharePoint lists are popular and simple tools for storing modestly-sized discrete sets of data. SQL Server Integration Services (SSIS) includes a source component to allow reading data from SharePoint...

2021-01-15 (first published: )

2,539 reads

Blogs

Elevate Your Data Leadership: A Unique Intensive Learning Experience

By

I’ve collaborated with two industry experts to design a transformative course for data leaders:...

A New Word:Maugry

By

maugry – adj. afraid that you’ve been mentally deranged all your life and everybody...

Friday Flyway Tips–Capture the Filegroup for Tables

By

A customer asked recently why Flyway doesn’t detect the filegroup for some changes. I...

Read the latest Blogs

Forums

ssas memory issues even after switching over to table level refreshes

By stan

Hi, we just moved to 2019 std from 2016 std.   We comingle the engine,...

Using R and Python with SQL Server 2022 not possible

By kunigunde.kurzweil

I want to use R and Python with SQL Server 2022, but I get...

is process add available in standard ssas

By stan

Hi, i cant tell from these 2 articles if incremental processing is available in...

Visit the forum

Question of the Day

Daylight Saving Time

I have a Sql Server 2022 instance setup with '(UTC-05:00) Eastern Time (US & Canada)' as timezone and a PostgreSQL 16 cluster setup with 'America/New_York' as timezone; both of them have -05:00 as UTC offset. Given that in New York, in 2024 Daylight Saving Time will begin on Sunday, March 10, at 2 AM, what happens if I execute the following statements in their own environment? Sql Server:

select dateadd(HOUR, 1, cast('20240310 01:00:00-05:00' as datetimeoffset(0)));
PostgreSQL:
select date_add('20240310 01:00:00-05:00'::timestamptz, '1 hour'::interval);

See possible answers