Using 2008 Features in a 2000 Compatibility Database
I saw a note recently from someone asking if they could use CROSS APPLY on a SQL Server 2008 instance...
2012-04-10 (first published: 2012-04-04)
1,865 reads
Blog Posts
Why I can not connect sql server ???
Recently, I installed sql server 2012 on windows 7 laptop, today when I wanted to login sql server with TCP/IP, I got...
2012-04-10
6,409 reads
X on XMLA: iii. Basic DDL Functions in XMLA (Create, Alter, Delete)
XMLA can be used to manage the structure of your multidimensional databases. While many developers use Visual Studio (BIDS), to...
2012-04-10
708 reads
April #Meme15 Assignment
Before the advent of the modern “Social Network”, many of us were already connected through tools that had much less...
2012-04-09
822 reads
Enabling Contained Databases in SQL Server 2012
One of the new features in SQL Server 2012 is the Partially Contained Database feature. I gave a talk on...
2012-04-09
2,820 reads
Need a Blogging Nudge? Try Plinky
If you want to blog you need ideas, something to write about, and sometimes that leads to the blank stare...
2012-04-09
716 reads
Nifty queries using a Numbers helper table
(The complete usable code is in the very bottom of this blog post)
Some of you may have seen this “numbers...
2012-04-09 (first published: 2012-04-04)
4,633 reads
Onward and Upward!
As you may have heard by now, I am joining the wonderful team at SQLskills as a Principal Consultant starting...
2012-04-09
1,008 reads
Quick Reference: How Do I Read an Excel XSLM (Macro-Enabled) File in SSIS?
Excel 2010 (and presumably the next version of Excel) have taken some security precautions with regards to macros in Excel files. If a spreadsheet has macros in it, you...
2012-04-09
208 reads
SQL Azure Saturday, WIT NYC and other local events!
Good day! Just wanted to share some exciting upcoming local events in the NYC/NJ area.
Hosted by the NJ SQL User...
2012-04-09
1,228 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