Books for Learning Transact SQL
I got asked a question recently about what books I would recommend for learning T-SQL. I posted a couple months...
2012-05-29
1,118 reads
Blog Posts
Denali – Day 29: Resource Governor Enhancements (Database Engine)
Denali – Day 29: Resource Governor Enhancements (Database Engine) Introduction to Resource Governor: Resource Governor is a feature introduced in sql...
2012-05-29
1,654 reads
Oracle Date issues with PowerPivot
This week I was building power pivot models for a client pulling data from Oracle. One table kept giving the...
2012-05-29
1,275 reads
SQL Saturday in Rochester Exceeds Expectations
After being forced to deliver sour grapes in my last few columns – thanks to some unexpectedly negative experiences with Oracle...
2012-05-29
1,761 reads
SSRS Performance in SharePoint Integrated Mode
I’m working with a client to help them move all reports in their company from native mode (Reporting Services not...
2012-05-29 (first published: 2012-05-24)
4,907 reads
The Rules of Gibbs
It’s been interesting to watch the characters evolve on NCIS over the years, something that can only happen with time...
2012-05-29
846 reads
The Standing Desk Experiment
I’ve had a few friends using standing desks for sometime. I first heard about Greg Gonzalez (sqlSentry | Blog | @SQLSensei), fellow...
2012-05-29
1,959 reads
Always restore with NORECOVERY
Always, always, ALWAYS restore a SQL Server database with the NORECOVERY option.
It’s trivial to switch the database online.
Not...
2012-05-28 (first published: 2012-05-24)
7,063 reads
Denali – Day 28: CDC for ORACLE
Denali – Day 28: CDC for ORACLE Sql server has provided a great features for changes monitoring as Change data Capture...
2012-05-28
1,355 reads
NVARCHAR(n) Vrs NVARCHAR(max)
These datatypes particularly NVARCHAR(n), have been with us for some time now but having seen some of the confusion around...
2012-05-28
7,938 reads
Blogs
Redgate and Rome
By Steve Jones
I’m at the UK Redgate office today, meeting with senior leaders in all areas...
Quick Tip: Check Most DTU Expensive Queries in Azure SQL Database
Optimizing Azure SQL Database performance often begins with identifying the most resource-intensive queries. Understanding...
PowerShell Newbie – Variables
By gbargsley
This is Week 2 of PowerShell Strikes Back – a four-week May series for...
Forums
SSRS Is Dead. Here Are Your Real Options
Comments posted to this topic are about the item SSRS Is Dead. Here Are...
The Distance Metric
Comments posted to this topic are about the item The Distance Metric
The New Wave of Security Threats
Comments posted to this topic are about the item The New Wave of Security...
Question of the Day
The Distance Metric
In the new VECTOR_DISTANCE() function in SQL Server 2025, the first parameter is the distance_metric. What is this?
See possible answers