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,293 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
7,027 reads
Ever since I first heard about the Microsoft Certified Master program I have been interested. The prestige of the certification...
2010-11-23
673 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,202 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,821 reads
I recently had to track down a rogue process that was failing to log in on one of my servers....
2010-11-12
877 reads
By Steve Jones
I needed to test a striped backup, so I decided to ask the AI’s...
By gbargsley
In SQL Server environments where transactional replication runs alongside Always On Availability Groups (AGs),...
Disable the sa login in SQL Server (and sleep better)If you run SQL Server...
Comments posted to this topic are about the item Create an HTML Report on...
The SQLPS.exe file has gone AWOL on 2 of my 4 SQL servers, ie,...
Comments posted to this topic are about the item Be Wary of Data
You have a table [dbo].[orders] without a Clustered Index (Heap). The table does not have any other nonclustered indexes! You rund the following command in Read Committed Isolation Level:
SELECTo_orderdate, o_orderkey, o_custkey, o_storekey FROMdbo.orders WHEREo_orderkey = 3877;