The Encryption Primer
SQL Server has a number of encryption features that allow you to better secure your data. This session will examine...
2012-03-28
1,441 reads
Blog Posts
TinyInt problem in SSAS
If you have a source table that has a Tinyint primary key column defined as IDENTITY and you create a...
2012-03-28
1,611 reads
Transforming Event Log Data
Several months ago I described a solution for Delegated SQL Server Administration with Powershell. In the solution, the SqlProxy module...
2012-03-28 (first published: 2012-03-23)
6,050 reads
Unstructured Data in SQL Server
More and more of our data does not fit neatly into a structured, relational model of rows and columns of...
2012-03-28
1,745 reads
Why I am excited about SQL Server 2012 (Part 2)
Earlier this month I published a blog entry on this same subject. In honor of the local Minneapolis launch event,...
2012-03-28
697 reads
Exporting data to CSV file using SQLCMD/BCP
When it comes to exporting data there are different options available in SQL Server, such as SQL Server Integration Services,...
2012-03-27
4,816 reads
FILESTREAM and Snapshot Isolation Mode in SQL 2008
FILESTREAM and Snapshot Isolation mode are incompatible in SQL 2008.
In SQL 2008 R2 however...
http://msdn.microsoft.com/en-us/library/ms173763.aspx
In SQL Server 2008 R2, snapshot...
2012-03-27 (first published: 2012-03-20)
2,182 reads
Inserting UniCode / Special characters in tables
Consider the situation where one needs to store multilingual data / Special characters into a table. For example Chinese characters or...
2012-03-27
7,823 reads
Powershell – Adding accounts to Local Security Policy
One of the challenges I’ve had over the years is figuring out a way to add the SQL Service accounts...
2012-03-27
10,528 reads
SQL in the City: Free SQL Server Event in London
Red Gate Software has announced “SQL in the City: London,” to be held on Friday, July 13, 2012, at the...
2012-03-27 (first published: 2012-03-19)
1,595 reads
Blogs
PlanTrace Now Supports PostgreSQL
PlanTrace Now Supports PostgreSQL The same plan analysis you know from...
A New Word: the Kinder Surprise
By Steve Jones
the kinder surprise – . the point in your early adolescence when you realize...
Crash-Consistent Snapshot Cloning - Hyper-V Edition
If you’ve been following my T-SQL Snapshot Backup series, most of what I’ve covered...
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