SQL Server Quickie #2 – Extents
Yesterday I have uploaded my 2nd SQL Server Quickie to YouTube. In this episode I’m talking about Extents, and how...
2012-08-04
638 reads
Blog Posts
Exporting Data Using BCP
BCP, or bulk copy program, has been around in SQL Server for a long time. It is a great way...
2012-08-03 (first published: 2012-07-31)
10,167 reads
Identity Insert and Table Variables – CONNECT issue
I was running some code the other day and was surprised by the result.
DECLARE @tmp TABLE (myID INT IDENTITY,MyChar VARCHAR(200))
INSERT...
2012-08-03
2,754 reads
SQL Saturday US Map
Apparently, SQL Saturday isn’t popular in the west. See for yourself. I wanted to see what cities frequently host SQL...
2012-08-03
1,554 reads
SQLSailor is exploring(Part5) – SQLDatabase Dashboard on Windows Azure
Well, that is one impressive dashboard of Audi RS4! It gives huge amount of flexibility for the driver to control...
2012-08-03
701 reads
SQLSailor is exploring(Part6) – Understanding firewall concepts for SQLDatabase on Windows Azure
Security is one of the most discussed topics for any cloud deployment plans and no organisation would like to compromise...
2012-08-03
684 reads
When Things That Are Supposed to Protect You Try to Kill You
This past week I was presented with a very unique issue. A call came in with a production issue on...
2012-08-03
758 reads
Who’s Responsible
This is really scary. Someone being sued for downloading a porn movie illegally. I have nothing against porn, and I...
2012-08-03
894 reads
Auto Shrink of all T-Log File on a SQL Instance - TSQL
This Script will shrink all the T-Log files of SQL instance if there is no active tracsaction on the database. The...
2012-08-02
2,650 reads
Creating and Managing User-Defined Roles in SQL Server 2012
SQL Server 2012 introduces user-defined server roles. These user-defined server roles are similar to fixed server roles with only difference...
2012-08-02
2,866 reads
Blogs
T-SQL Tuesday #198–Change Detection
By Steve Jones
This month we have a new host, Meagan Longoria, who graciously agreed to help...
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...
Forums
Permissions Removal When Changing Object Schema
When the schema of an object is changed, SQL Server wipes out the previous...
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
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