I/O I/O - It's why my server's slow.....Examing I\O Statistics
I/O I/O - It's why my server's slow.....
Often I've been curious about ways to measure the performance of SQL Server, and...
Database Mirroring Using T-SQL
Part three of this series illustrates how to use a T-SQL script to create database mirroring between a principal and mirrored server.
Flat File Imports with SQL Server Integration Services 2008
A main function of SQL Server Integration Service is to move data into and out of SQL Server. The external data source can exist in almost any format, including a plain text file. This article focuses on importing a text file into a standard SQL Server database table.
New Databases
There are new types of databases being deployed in the world. Steve Jones says that DBAs need to be aware of the changing technologies.
New Databases
There are new types of databases being deployed in the world. Steve Jones says that DBAs need to be aware of the changing technologies.
New Databases
There are new types of databases being deployed in the world. Steve Jones says that DBAs need to be aware of the changing technologies.
Storing IPv4 Addresses for Performance
An in-depth analysis on how to store IPv4 addresses to achieve maximum efficiency and performance in both storage and queries
Test Drive
Hiring a new employee can be a hit or miss proposition. We often don't learn much about how someone will work from an interview. Steve Jones talks about an alternative way to hire someone by taking them for a test drive.
The 2009 SQLServerCentral Opening Night Party
SQLServerCentral is hosting an opening night party at the 2009 PASS Summit. Read more about this and learn how to get a ticket.
How to create SQL Server virtual appliances for Hyper-V
Creating a private SQL Server VAP will reduce the time it takes to deploy additional SQL Server machines in your environment.
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