Powershell is the new management interface for scripting and working with SQL Server that is integrated into Windows 2008 and SQL Server 2008. The author of a Codeplex project introduces some extensions that try to make it easier to use Powershell with SQL Server.
Steve Jones looks back at some of the news from the week ending Oct 6, 2008.
How much different can a database engine make to a platform? MySpace was recently mentioned along with database technology from Sun Microsystems that might make them more profitable.
How much different can a database engine make to a platform? MySpace was recently mentioned along with database technology from Sun Microsystems that might make them more profitable.
How much different can a database engine make to a platform? MySpace was recently mentioned along with database technology from Sun Microsystems that might make them more profitable.
A great summary from MVP Brad McGehee on the new TDE feature in SQL Server 2008
Part 19 digs deep into two of SQL 2005's ranking functions: RANK() and DENSE_RANK(). It includes performance considerations and using CTEs to avoid table variables.
We try to keep control of the data in our databases, but as the world becomes more connected, it's harder to ensure integrity. Steve Jones talks about some of the issues in this new Web 2.0 world.
We try to keep control of the data in our databases, but as the world becomes more connected, it's harder to ensure integrity. Steve Jones talks about some of the issues in this new Web 2.0 world.
We try to keep control of the data in our databases, but as the world becomes more connected, it's harder to ensure integrity. Steve Jones talks about some of the issues in this new Web 2.0 world.
A while back I wrote a quick post on setting up key mappings in...
By Steve Jones
In 100 years a lot of what we take to be true now will...
At Saturday the 21st of February I’m presenting an introduction to dimensional modelling at...
Hello, I inherited a number of tables with like 20-30 column using nvarchar(256) in...
Hi, i'm running vs2022. I'm trying out a c# script that i'd like to...
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