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,983 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,546 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
932 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
608 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,535 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,105 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
467 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
564 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
911 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
608 reads
Blogs
Don’t Fear the Technology
By Brian Kelley
The concern that a particular technology is going to destroy the world seems to...
Creating a Custom SQL Server Security Checklist Using the DoD STIG
The STIG is detailed, which is a good thing, but I found myself wanting...
Creating a Local Model Chatbot on Windows
By Steve Jones
After my session at VSLive last week, I had a few questions from the...
Forums
RegEx Functions III
Comments posted to this topic are about the item RegEx Functions III
Optimized Locking in SQL Server 2025: Fewer Locks, Less Blocking, and the Cases It Cannot Fix
Comments posted to this topic are about the item Optimized Locking in SQL Server...
Finely Tuned Models
Comments posted to this topic are about the item Finely Tuned Models
Question of the Day
RegEx Functions III
If I run the REGEXP_LIKE() function, does it match values in a case-sensitive fashion, or a case-insensitive fashion by default.
See possible answers