Want a Sean-made Precon? You got it!
Sean’s giving a precon at SQL Satrurday 163 this October! Oh yeah, and so are Tim Mitchell and David Stein....
2012-07-02
765 reads
Blog Posts
Why Isn’t Everyone Accountable? A Work Conundrum
A pattern I’ve seen over and over again at many different jobs is that some people are not held accountable...
2012-07-02
765 reads
Database Interview questions
I decided to expand the collection of SQL Server Interview questions and this time focus on database objects related questions.
2012-07-01
963 reads
Determine space used for each table in a SQL Server database
I have written following Microsoft SQL Server T-SQL scirpt to quickly determine space used for each table in a SQL...
2012-07-01
4,422 reads
Lost in Translation – Deprecated System Tables – Introduction
When SQL Server 2005 launched, it included a slew of dynamic management objects (DMOs) that were meant to replace the...
2012-07-01
1,104 reads
Lost in Translation – Deprecated System Tables – sysaltfiles
This post is part of a blog series which focuses on translating compatibility views in SQL Server to their respective...
2012-07-01
1,631 reads
New in SQL 2012 (1)
Learning new is a interesting thing. Today I read several posts regarding the SQL Server 2012 new feature:
1. Indirect Checkpoint
Prior to...
2012-07-01
2,143 reads
SQL Server Performance Tuning Overview
In this blog article I will give an overview of performance tuning based on common situation that occur on small...
2012-07-01
470 reads
Is SELECT Identity() … INTO Minimally Logged in Simple Recovery?
Is SELECT Identity() … INTO Minimally Logged in Simple Recovery?
Extreme Logging
I was having a discussion with Idera (@idera_software) dev lead Vicky...
2012-06-30
2,206 reads
Rebuild indexes based on fragmentation – sp_RebuildIndex
In my previous post here, I’ve discussed how we can detect fragmentation in SQL Server databases indexes using dynamic management...
2012-06-30
5,342 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