SSRS – Creating a Reporting Services Web Farm
Reporting Services performance problems can often be narrowed down to report design or resource constraints and sometimes a combination of...
2012-02-20
3,985 reads
SQL Server 2012 (“Denali”): PowerPivot
Version 2 of PowerPivot (download) is being made available with SQL Server 2012. There are many new features, and my top 5 are:
Diagram...
2012-02-20
1,550 reads
A Script A Day - Day 12 - Granting Role Membership to All Principals
Today's script will grant membership in the db_owner fixed database role in all online read/writable user databases to all principals not...
2012-02-20
934 reads
Speaking at PASS DBA Virtual Chapter
I will be speaking for the PASS DBA Virtual Chapter on February 22nd, 2012. I will be delivering my presentation on...
2012-02-20
612 reads
Reconciling SPNs
As part of troubleshooting Kerberos authentication for SQL Server I had to verify SPNs so I thought I’d blog about...
2012-02-20
2,541 reads
A Script A Day - Day 11 - User Permissions By Database
Today's script will return you permissions granted to a user for every online database. The script uses EXECUTE AS so...
2012-02-20
1,106 reads
Sorry...
I've been offline for a week to take some annual leave and recharge my batteries. To make up for the...
2012-02-20
468 reads
Will You Sponsor the #SQLPlunge?
At the beginning of next month, a few hearty souls have decided that they’d like to do a little to...
2012-02-20
565 reads
SQL Rally: Don't Vote for my Sessions
So I found out on Friday that I am going to be a speaker at the Dallas SQL Rally, which...
2012-02-20
912 reads
Selected to Speak at SQLRally 2012
I was excited to receive the email on Friday that I’d been selected to present at SQLRally #2 in Dallas...
2012-02-20
609 reads
Blogs
T-SQL Tuesday #203: Risk and Reward
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
dataMinds Connect 2026 – Slides & Scripts
You can find the slides and SQL scripts for my session “Spice up your...
How to Clear the SSMS Cache (SSMS 21 and Later)
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
Forums
Risk Vs Reward, The never ending ROI discussion.
Comments posted to this topic are about the item Risk Vs Reward, The never...
Hyperscale Replicas IV
Comments posted to this topic are about the item Hyperscale Replicas IV
The SQL Server Date Magic: When CAST and CONVERT Keep Your Index Seek
Comments posted to this topic are about the item The SQL Server Date Magic:...
Question of the Day
Hyperscale Replicas IV
In Azure SQL Database Hyperscale Edition, how many geo-replicas can be created?
See possible answers