Learning some DAX
I’ve not done much BI work in my career, other than simple aggregates in reports. I’ve wanted to tackle projects, but I’ve rarely had a chance to spend time...
2020-03-16
217 reads
The Voice of the DBA
T-SQL Tuesday #124–Query Store in Action
Today is T-SQL Tuesday #124 and I’m dropping a quick post as I’ve had lots of other stuff to do since returning from my sabbatical. Tracy Boggiano is the...
2020-03-10
118 reads
Women’s History Month and Being Better
This month is Women’s History Month, and it’s a chance to stop and think about the impact that women have had in history. After reading Monica Rathbun’s post on...
2020-03-13 (first published: 2020-03-03)
156 reads
Setting 2020 Learning Goals
I deliberately didn’t set any goals at the start of 2020 since I was taking six weeks off for a sabbatical. That’s done, and it’s time to look forward....
2020-03-06 (first published: 2020-03-02)
477 reads
Reviewing 2019 Career Goals
According to this post, I rate 2019 as a Failure. Of the books I planned to read, I read 2. I started 2 others, but they’re in progress, even...
2020-02-28
167 reads
Schema Filtering in SQL Prompt
I love SQL Prompt, and I’m regularly impressed by the enhancements our teams continue to make in the product. One item that I found interesting recently was schema filtering....
2020-03-04 (first published: 2020-02-27)
243 reads
The Cost of SQL Bits v the PASS Summit
UPDATE: This post originally priced Charlotte, NC, but the Summit is in Houston, TX. I have corrected costs and locations. The difference is about $300 less for a flight...
2020-01-22 (first published: 2020-01-13)
444 reads
Knocking Off for Six Weeks
This won’t be the last blog I write for six weeks, but it is the last one I’ll syndicate and in which write about technical stuff. Today is my...
2020-01-21 (first published: 2020-01-10)
384 reads
Running Powershell Scripts – #SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. When you install Windows, by default, the execution...
2020-01-08
144 reads
Installing PowerShell for SQL Server – #SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. PowerShell is the hot new scripting language for...
2020-01-09 (first published: 2019-12-27)
4,375 reads
Blogs
The Book of Redgate: Get the right stuff done
By Steve Jones
Another of our values: The facing page has this quote: “We admire people who...
Runing tSQLt Tests with Claude
By Ed Elliott
Running tSQLt unit tests is great from Visual Studio but my development workflow...
Getting Your Data GenAI-Ready: The Next Stage of Data Maturity
By James Serra
I remember a meeting where a client’s CEO leaned in and asked me, “So,...
Forums
Introduction of OPTIMIZE_FOR_SEQUENTIAL_KEY = ON
Hi, We have low latency high volume system. I have a table having 3...
The Long Name
Comments posted to this topic are about the item The Long Name
Eight Minutes
Comments posted to this topic are about the item Eight Minutes
Question of the Day
The Long Name
I run this code to create a table:
When I check the length, I get these results:
A table name is limited to 128 characters. How does this work?