How Do I Change SSRS Report Credentials with Powershell?
Today’s script took a long time to write. The concepts are fairly simple and the resulting script is quite trivial...
2010-12-03
3,056 reads
Today’s script took a long time to write. The concepts are fairly simple and the resulting script is quite trivial...
2010-12-03
3,056 reads
The other day I was asked to provide the port number that a SQL Server instance was listening on. As...
2010-12-01
1,744 reads
What if I told you that you could sign an assembly that your Windows application uses with a certificate, load...
2010-11-30
1,580 reads
The other day I was asked to provide the port number that a SQL Server instance was listening on. As...
2010-11-29
3,246 reads
Today’s script took a long time to write. The concepts are fairly simple and the resulting script is quite trivial...
2010-11-24
6,859 reads
Ever since I first heard about the Microsoft Certified Master program I have been interested. The prestige of the certification...
2010-11-23
671 reads
I know I do!
The trick is to properly manage your VLFs.
What are VLFs? The short anser is that VLF...
2010-11-19
2,201 reads
Today’s post is a quick one that came out of a conversation on Twitter. To make a long story short,...
2010-11-18
3,382 reads
Today’s post is a quick one that came out of a conversation on Twitter. To make a long story short,...
2010-11-15
2,795 reads
I recently had to track down a rogue process that was failing to log in on one of my servers....
2010-11-12
865 reads
By Steve Jones
This was an interesting thing I saw in a Question of the Day submission....
By Kevin3NF
Don’t Panic! It’s a vague but common complaint, frequently with no additional details. Before...
I thought I didn’t care about linting, and lately, I haven’t written a lot...
Comments posted to this topic are about the item Dynamic T-SQL Script Parameterization Using...
/* I'm trying to eliminate (write out) this function 'largest_date', but SQL Server 2016...
Hi everyone, I’ve been tasked with migrating a Standalone SQL Server instance to a...
What is returned when I run this code in SQL Server 2022?
CREATE TABLE CatIndex ( indexval VARCHAR(20) ) GO INSERT dbo.CatIndex (indexval) VALUES ('1'), ('2'), ('3') GO SELECT CHOOSE(indexval, cast('2025-01-01' AS DATE), CAST('2025-02-01' AS DATE), CAST('2025-03-01' AS DATE)) FROM dbo.CatIndex AS ciSee possible answers