SQLSailor is exploring(Part4) – Basic DML,DDL operations with SQL Databases on Windows Azure
In this post we will review some basic DML,DDL capabilities of SQL Database on windows Azure.
This post is in continuation with my...
2012-08-01
804 reads
Blog Posts
Two New Cumulative Updates for SQL Server 2008
On July 17, Microsoft released two new Cumulative Updates for SQL Server 2008. The first cumulative update is SQL Server...
2012-08-01
952 reads
Bad business practices damage your company, KRG Technology
I just composed and sent this message to eleven members of a single California-based recruitment company. I’ll let the email...
2012-07-31
1,735 reads
Improve DBA Operation Productivity – Part Two
As a DBA, we have to take various actions based on huge amount of information received. In one perspective, our...
2012-07-31
1,894 reads
OLAP PivotTable Extensions Update
OLAP PivotTable Extensions is a really cool free add-in for Excel that’s been around for quite a while now. It...
2012-07-31
1,908 reads
Password Resets
I read this piece from Troy Hunt, which is a long look at the password reset process for a web...
2012-07-31
1,679 reads
Reading Excel into SSIS via OpenXML Scripting
Reading Excel data isn't easy. It should be, but there's a lot of unfortunate barriers in the way that I've discussed before. They boil down to one main reason:...
2012-07-31
1,722 reads
SCRIPT: Basic Information About Indexes
I’m having a little fun with documenting basic information about indexes in my current project. I’m posting the scripts here...
2012-07-31
2,086 reads
SQL Server 2012 AlwaysOn Availability Groups – Part 4: Adding new Replicas
In the last 2 blog postings you have learned how to setup your first Availability
Group with SQL Server 2012. Today...
2012-07-31 (first published: 2012-07-26)
4,733 reads
#GetHawt – The Summer 2012 Edition
Jen McCown started a #GetHawt set of posts last year and I think it went well. It must have, so...
2012-07-30
1,753 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