Scale-out SSRS (a brain dump)
So, I just got finished with a SQL Server Reporting Services (SSRS) scale-out deployment, based largely on this step-by-step guide. Things mostly went...
2018-02-06
405 reads
Jen McCown
Absolute computer fundamentals: the command line!
So I’ve spoken to more than one DBA who is not familiar with using the command prompt (aka command line)...
2018-01-02
373 reads
RegEx in SSMS: A gift for quick code
I had yet another example of how beautiful Regular Expressions can be in SQL coding today, and so I thought...
2017-12-28
713 reads
PowerShell for fun (and profit?)
Let's have a liltle fun with PowerShell. Along with, I suppose, a couple of useful things and links.
The post PowerShell...
2017-11-15
382 reads
Session: T-SQL’s Hidden Support Feature
Today I presented one of my favorite sessions - T-SQL's Hidden Support Feature - for the DBA Fundamentals group! They'll put up...
2017-11-14
348 reads
Five reasons to be a technology speaker
I don’t think everyone should be a technical speaker. But I wouldn’t object if everyone spent a season trying. Why be a...
2017-11-08
357 reads
Attend “T-SQL’s Hidden Support Feature” online September 11!
I’m presenting T-SQL’s Hidden Support Feature for the DBA Fundamentals virtual chapter on Monday, Sep 11 at 9:30 PM CDT! Session description: The most effective...
2017-09-06
375 reads
Tech news: Your phone screen is a dirty rotten spy
Great. Now you can't even trust your phone's screen, of all things, to not steal your data… https://t.co/KUyGjwsih2 — Adam Machanic...
2017-08-29
389 reads
That thing you want to do? Do the thing.
You're thinking of starting a blog, or teaching, or training videos. Will it pay off? Will it be worth it?...
2017-07-29
681 reads
Celebrate! Second Anniversay Giveaway (is now over)
Two years ago, we officially became MinionWare and launched the absolutely masterful SQL Server management solution, Minion Enterprise. For a...
2017-07-18
328 reads
Blogs
Using Cron in Postgres Flex
pg_cron is a simple cron-based job scheduler for PostgreSQL that runs inside the database...
Can I Change a Primary Key Value? #SQLNewBlogger
By Steve Jones
I heard someone say recently that you can’t change a primary key value in...
SQL Server Index Primer
By Kevin3NF
Indexes 101: What, Why, and When? “What Is an Index?” I get this question...
Forums
50 Years of Microsoft
Comments posted to this topic are about the item 50 Years of Microsoft
Multiple Collations
Comments posted to this topic are about the item Multiple Collations
Retrieving Data Using the REST API in Data API Builder
Comments posted to this topic are about the item Retrieving Data Using the REST...
Question of the Day
Multiple Collations
Can I have a collation expression like this in SQL Server 2022?
... WHERE ColumnA = ( 'abc' COLLATE French_CI_AS) COLLATE French_CS_AS ...See possible answers