Not having TDE in all editions is stupid
Transparent Data Encryption is only available in Enterprise Edition and above. Steve Jones thinks that's a mistake.
2011-12-05
114 reads
Editorials
A Welcome Intruder
This Friday Steve Jones asked about penetration testing of your security. Have any of you ever tested your systems?
2011-12-02
115 reads
Fast Migrations
Virtualization is an important technology for anyone working with servers, and as vendors look to improve the performance of their hypervisors, this technology might be more important for data professionals to understand.
2011-12-01
127 reads
A Refreshing Break
Steve Jones talks about his recent vacation break and one change that made it a huge success.
2011-11-30
118 reads
Thinking Time
Do you get time to stop and think, without being pressured to solve a specific problem? Steve Jones notes that it's important to get that creative time to grow and produce better work.
2011-11-29
219 reads
Little Love Lost for SMO
SMO is a very useful way of automating a wide range of routine database jobs, but Phil Factor laments Microsoft's apparent ambivalence towards the technology, including a lack of anything remotely resembling adequate documentation.
2011-11-28
205 reads
Stress – It’s Not Fair
Today we have a guest editorial from Andy Warren that looks at stress and how it impacts your job. He offers a few ways that you might better deal with it as well.
2011-11-28
215 reads
Snack Attack
This editorial was originally published on Jan 11, 2007 and is being re-run as Steve is on vacation. A fun poll today asking what you like to eat at work.
2011-11-25
87 reads
Are You Easy To Work With?
Today we have a guest editorial from Andy Warren that looks at the relationships you have with your co-workers.
2011-11-23
464 reads
Power Tools at Work
This editorial was originally published on Jan 17, 2007. It is being republished as Steve is on vacation. This one deals with data security.
2011-11-22
114 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