Creating a Symmetric Key in SQL Server
Symmetric keys in SQL Server are recommended for encrypting data in columns. They are a good balance of security and...
2012-04-25
12,401 reads
Blog Posts
Enterprise Data Warehouse Architecture Options
Enterprise Data Warehouse Architecture Options
Of course, your architecture depends on your business requirements along with technical, historical, and political factors....
2012-04-25
4,266 reads
Setup database mirroring and log shipping together
SQL Server has multiple high availability solutions. Comparing with cluster, database mirroring and logshipping are easier to setup, and they...
2012-04-25 (first published: 2012-04-21)
12,418 reads
SQL Azure Federation
What is Federation?
Federation is a database object like other objects such as tables, views, stored procedures or triggers.It is also known as...
2012-04-25
838 reads
SQL Azure Federation
What is Federation?
Federation is a database object like other objects such as tables, views, stored procedures or triggers.
It is also known as Sharding.
There can be multiple federations in a database.
It is...
2012-04-25
385 reads
Change Package Properties Using Parameters–SSIS 2012
In DTS, changing package properties was close to impossible (the less we talk about DTS, the better). Package configurations introduced...
2012-04-24
14,275 reads
List of Sharepoint Blogs
I ran across this list of Sharepoint blogs by Rene Modery while doing some Sharepoint reading. He has an OPML...
2012-04-24
678 reads
OPASS April Meeting Recap
Last Thursday I had the pleasure of speaking in Orlando, FL at the OPASS monthly meeting. I spoke on Extending...
2012-04-24
1,137 reads
Oracle Tips for MSBI Devs #3: Choosing Drivers
When working with Oracle, drivers are truly a pain to get working correctly. I will discuss my preferred choice and...
2012-04-24
908 reads
SQL Backup 7
What more could you add to a SQL Server backup product? It seems that many software products, including Red Gate’s...
2012-04-24
1,248 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