Cost Savings and Backup Compression
Let me set the scene, one of our internal IT SQL Servers which stores a whole host of performance metrics...
2012-08-08
1,840 reads
Blog Posts
How many SQL Servers you run within your environment ? – MAP could be your best bet to answer this question !
A blog post about Microsoft Assessment Planning Toolkit was in my list for quite a while and today I decided to write...
2012-08-08
915 reads
How to Data Compress Varchar(MAX)
I talk a lot about compression. I’ve blogged a pretty decent amount on it as well. One of the things...
2012-08-08
7,995 reads
More Suggestions for SQLSaturday Admin Tools
I just finished the draft schedule for SQLSaturday #151 in Orlando and wanted to write some notes about the process....
2012-08-08
465 reads
SQLSaturday #160, Kalamazoo
Date: September 22, 2012
Title: So I started this blog…now what?
Abstract:
Ever thought about trying your hand at blogging? Or maybe you’ve...
2012-08-08
598 reads
SSIS: Transfer SQL Server Object using SMO
we often face a situation to move SQL server object beween servers or databases, when you have constant table list...
2012-08-08
5,576 reads
Startup Jobs
Are there things you need to make sure are running when your SQL Agent starts? Did you know that you...
2012-08-08 (first published: 2012-08-02)
3,335 reads
Visio 2010 Forward Engineer Add-in
Somehow I missed this gem that’s been around for quite a while so I thought I would share it in...
2012-08-08
2,405 reads
Book Review: On Writing A Memoir of the Craft by Stephen King
I just finished this book. Literally. Sitting on an airplane in route from Orlando to Charlotte NC. I got up...
2012-08-07
1,010 reads
Can I still buy per socket licenses for installing SQL2008 R2 ?
Many times I have seen this question coming from users - Can I still buy per socket licenses for installing SQL2008...
2012-08-07
736 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