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
Using DMVs to Find the Ports that SQL Server is Listening On
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
Certificate Based Application Roles
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
Using DMVs to Find the Ports that SQL Server is Listening On
The other day I was asked to provide the port number that a SQL Server instance was listening on. As...
2010-11-29
3,256 reads
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-11-24
6,915 reads
Careful with the New MCM Requirements
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
Want to Make Your SQL Server Run Faster for Free?
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
Get Drive Space Including Mount Points
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
Get Drive Space Including Mount Points
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,801 reads
Troubleshooting SQL Server Error: 18456, Severity: 14, State: 16
I recently had to track down a rogue process that was failing to log in on one of my servers....
2010-11-12
872 reads
Blogs
A DevOps Workshop Tomorrow in Atlanta
By Steve Jones
Tomorrow is the Redgate DevOps Day in Atlanta. You can still sign up, so...
Stop Wasting Time Rebuilding Indexes Every Night
By Kevin3NF
Too many IT teams run index rebuild jobs on autopilot. Every night. Every index....
SQL Data Type Conversions: Your Key to Clean Data & Sharp Queries
If you're a data analyst juggling varied datasets, mastering SQL data type conversions isn't...
Forums
Question on SQL Query with NOT condition
I have a record, in those the three columns where firstname / last name...
Execution Plan Operators
Comments posted to this topic are about the item Execution Plan Operators
Merge spans with Dates Logic
--for a given member if the startdate and endate is continous we need to...
Question of the Day
Execution Plan Operators
When looking at an execution plan in SSMS, what types of operators are shown?
See possible answers