Pluralsight Free April
It’s a few days into April, but not too late I hope to mention that Pluralsight is offering their entire library, free to new accounts, for the month of...
2020-04-16 (first published: 2020-04-07)
448 reads
Gail Shaw
- Interests: Computer Graphics, Aikido, Roleplaying
The Scientific Method: a call to action
Gail Shaw issues a rallying call for the SQL Community to adopt the Scientific Method when investigating and reporting on SQL Server behavior.
2019-09-09 (first published: 2015-05-25)
536 reads
The Number that shouldn't be a number
Gail Shaw is often left bewildered by the weird and wonderful data types people choose for their tables, when storing something as simple as a telephone number or a date.
2018-12-13 (first published: 2015-02-02)
473 reads
A rant about presentations
My company’s internal conference is in a couple of weeks, so this seems like a good time to have a...
2018-05-04 (first published: 2018-04-24)
2,330 reads
Revisiting catch-all queries
I originally wrote about catch-all queries early in 2009, just as something that I’d seen several times in client code....
2018-03-26 (first published: 2018-03-13)
3,289 reads
Obsessing over query operator costs
A common problem when looking at execution plans is attributing too much meaning and value of the costs of operators.
The...
2018-02-22 (first published: 2018-02-13)
2,116 reads
Query Performance Tuning – A Methodical Approach
Learn how to approach performance tuning in this piece from SQL Server MCM and MVP, Gail Shaw.
2017-02-10 (first published: 2015-06-08)
16,178 reads
Books of 2016
I set myself a reading goal of 75 books for last year, and managed 73. I’m not overly happy about...
2017-01-03
487 reads
Books of 2016
I set myself a reading goal of 75 books for last year, and managed 73. I’m not overly happy about...
2017-01-03
150 reads
What is a SARGable predicate?
‘SARGable’ is a weird term. It gets bandied around a lot when talking about indexes and whether queries can seek...
2016-09-13
1,039 reads
Blogs
Migrating SQL Server container images to the Github Container Registry
A couple of months ago Docker announced that they would be implementing a 6...
Daily Coping 29 Oct 2020
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
What do they want to hear?
I was helping my 16yo write his first college essay the other day. He’s...
Forums
Looking for good beginner Data Base Administration book for advanced developer
Hello SSC, I have been a SQL developer for close to 20 years. I...
Import a PBIX file into Azure Analysis Services
I want to import a Power BI PBIX file into Azure Analysis Services. I...
Using ADF Data Flow Derived Column transform against nested Delta structures
I'm trying (without success) to use a derived column transform within an ADF Data...
Ask SSC