SQL Azure
SQL Azure is a cloud-based service from Microsoft that uses a special version of SQL Server as its backend. SQL Azure...
2012-02-10
2,431 reads
Blog Posts
Thanks to Brian Kelly for a Great Presentation on Auditing for SQL Server - Please Find the Notes Below
For those interested in following a great MVP who contributes regularly on Infrastructure and Security, here are notes I took...
2012-02-10
1,036 reads
A Script A Day - Day 9 - Index Compression Estimations
Today's script provides amongst other information Index compression estimates based on existing index information. All you need to do is...
2012-02-09
1,312 reads
An open letter to anyone with “SQL Server” on their resume
Dear Sir or Madam,
I have your resume here in my hand and couldn’t help but notice that you have listed...
2012-02-09
2,903 reads
Data Page math : 96 + 8060 + 36 = 8192. is this correct?
I have come accross interesting puzzle yesterday on numbers 96 and 36.
Everyone knows that header size is 96 and maximum...
2012-02-09
1,711 reads
February #Meme15 Assignment
It’s been a couple months now since a number of us got together to share how we use social networks...
2012-02-09
575 reads
SQL Server 2012 (“Denali”): Data Quality Services
Data Quality Services (DQS) is a brand new feature in SQL Server 2012. In short, DQS enables you to build a...
2012-02-09 (first published: 2012-02-06)
2,705 reads
SQL Server Product Life Cycle
Part of managing the SQL Server environment , is maintaining the latest Service Packs remain within the Product Support data range.
The...
2012-02-09
1,134 reads
SSAS: Currency Conversion in MDX Script
In my prior blog post, I provided some details regarding currency conversion via measure expressions in SSAS. I recently attempted...
2012-02-09
1,004 reads
Stages of the Game?
Saw this post by Seth Godin on Stages of the Game. Interesting, I identified with it – I’m competitive, and competing...
2012-02-09
827 reads
Blogs
A bespoke reporting solution doesn’t have to cost the earth
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
Presenting with Visual Studio Code
A while back I wrote a quick post on setting up key mappings in...
Advice I Like: In 100 Years
By Steve Jones
In 100 years a lot of what we take to be true now will...
Forums
AllocationType as ROW_OVERFLOW_DATA
Hello, I inherited a number of tables with like 20-30 column using nvarchar(256) in...
is it true we cant debug c# scripts in ssis anymore under vs
Hi, i'm running vs2022. I'm trying out a c# script that i'd like to...
Question of the Day
Missing the Jaro Winkler Distance
I upgraded a SQL Server 2019 instance to SQL Server 2025. I wanted to test the fuzzy string search functions. I run this code:
SELECT JARO_WINKLER_DISTANCE('tim', 'tom')
I get this error message:Msg 195, Level 15, State 10, Line 1 'JARO_WINKLER_DISTANCE' is not a recognized built-in function name.What is wrong? See possible answers