PASS Summit 2016-Thursday Part II
The second half of the day was spent talking with various speakers and attendees. I got into a great conversation...
2016-10-28
806 reads
The Smiling DBA
PASS Summit 2016-Thursday Part 1
Today’s keynote was by David Dewitt. He did an excellent job explaining the architecture behind various Cloud Data Warehouse offerings....
2016-10-27
401 reads
PASS Summit 2016-Wednesday
As all Summits, the first Regular Session day in Seattle started with the Keynote. Well, really it starts with a...
2016-10-27
488 reads
PASS Summit 2016–Tuesday
For the first day at the Summit this year, I spent half my time in a Pre-Conference session with Idera...
2016-10-25
471 reads
VOTE!!! PASS Board of Director Elections
It is voting season again, and there is a great group of individuals running for the Board of Directors of...
2016-10-06
357 reads
Live! 360–Speaking at SQL Server Live Orlando 2016
If you are looking for a great conference to attend, please look at Live! 360. This event combines 6 different...
2016-09-10
606 reads
Using a Lookup Component in SSIS for Surrogate Keys in a Fact table
There are many suggestions for loading a data warehouse using SQL Server integration Services (SSIS). Once you get started, you...
2016-07-26 (first published: 2016-07-21)
5,311 reads
PASS Summit 2016 – Connect, Share, Learn
Please join me and about 4000+ other technology professionals for the annual PASS Summit in Seattle, WA October 24th – 28th....
2016-06-24
540 reads
Why use a Date Dimension Table in a Data Warehouse
In the Data Mart, or the Data Warehouse world, there is a date dimension table in all schemas if you...
2016-06-06 (first published: 2016-05-29)
7,124 reads
SQLSaturday Atlanta #521 May 19th & 20th 2016
SQLSaturday events are a pleasure to be a part of whether it involves speaking or volunteering. Volunteering definitely takes more...
2016-04-23
635 reads
Blogs
More fun with Git: git restore
The setup My day job involves babysitting a lot of Git repositories hosted on...
When the Internet Stumbles: Lessons from Cloudflare & Azure Front Door Outages
By John
Recently, the world was reminded of just how fragile the internet can be. Two...
Prepping for Certification, Part 4 of 4
By Brian Kelley
In Parts 1-3, I covered how I prepare for a certification exam. In this...
Forums
CAST datetimeoffset(7) as a datetime in UK format
I have a view where I am casting a datetimeoffset(7) field to smalldatetime or...
what are the downsides of TDE not running vs running?
hi for the 2 years i've been here I believe we've had "encryption" turned...
Help! MEMORY_ALLOCATION_EXT wait stalls
Hi I have an overnight process that moves allot of claims records Been working...
Question of the Day
Putting the Player with the Number
In SQL Server 2025, what does this return?
DECLARE @player varchar(20) = 'Bo Nix', @num VARCHAR = '10' SELECT @player || @numSee possible answers