Since we’re on a recent theme of revising long-held best practices that are not, here’s a timely one for you: Don’t change your default SQL Server port for security...
2022-03-02
204 reads
A short post this week. While I was helping some friends recently, we experienced a curious thing where as soon as an application was started up, it was immediately...
2022-02-23
22 reads
Last year I wrote a series of posts about accessibility as it relates to presentations, and one aspect which I didn’t cover is within the documents themselves. We create...
2022-02-16
66 reads
On Wednesday February 23rd, 2022, the Calgary Data User Group will be hosting our first user group session of the year, featuring Warwick Rudd. The topic is an introduction...
2022-02-09
14 reads
(This post was co-authored by Erik Darling.) The more things stay the same, the more they change… No, that’s not a mistake. In fact, it’s a reference to long-held...
2022-02-02
51 reads
I have been selected to speak at the DataGrillen conference later this year. I will be presenting my session How Does SQL Server Store That Data Type?, which I debuted during...
2022-01-26
14 reads
In 2012 when I originally founded Born SQL, I never imagined I would find myself a five-time recipient of the Microsoft Data Platform MVP award, let alone be offered...
2022-01-19
19 reads
Last month I wrote a blog post suggesting that it was not possible to get SQL Server 2019 running on Apple Silicon. I hedged my statement by saying you...
2022-01-12
143 reads
My good friend and talented singer Rob Volk reminded me recently that I had promised to write about my involvement with PASS at the end of its life, and I...
2022-01-05
11 reads
Recently my spouse and I travelled to South Africa (yes, I know there’s a pandemic on) to deal with a gloomy family matter that required in-person interaction. Being an...
2022-01-03 (first published: 2021-12-22)
186 reads
In today's data-driven world, SQL (Structured Query Language) is a blazing-hot skill. It's your...
By Steve Jones
I leave tonight for Australia. I was in London 3 days ago, so this...
By Brian Kelley
As I look at the state of information technology today, I see one constant:...
Hi, I have the following table: CREATE TABLE [dbo].[UnitProdFinal]( [YearMonth] [int] NULL, [SerialNumber] [varchar](50)...
Hello All, I have recently joined a project, where main, core tables with millions...
Long time listener, first time caller. I have a problem that my usual bag...
How many table hints can I include in a query?
See possible answers