2014-07-01
8,377 reads
Articles
Finding SQL Server objects that reference invalid objects
Since many environments haven't committed to using a source control system, identifying mismatched objects can offer a challenge. Tim Smith offers a solution.
2014-07-01
3,659 reads
Why Primary Keys can be important on large tables
I inherited a database that was getting large and not performing well. After adding primary keys life got better.
2014-06-30
14,707 reads
Developer Week - Nuremberg, Germany
It's Developer Week in Nuremberg July 14-17. There are a couple of great speakers at this event, like Constantin Small and Sascha Dittmann. Register while space is available
2014-06-30
2,023 reads
Experiments with NEO4J: Using a graph database as a SQL Server metadata hub
NEO4J, the graph database, can be used to provide answers that are very tricky for relational databases, including providing diagrams to show how SQL tables relate to each other, and the shortest chain of relationships between two tables, as David Poole demonstrates
2014-06-30
3,128 reads
Running SQL Server Databases in the Amazon Cloud (Part 1)
In this tip, Sadequl Hussain outlines what's involved in rolling out a SQL Server instance in RDS. In subsequent tips, he will explore what features it offers and what shortcomings it has.
2014-06-27
3,145 reads
Less and Less Visual
Phil Factor ponders the preponderance of text in current database tools, and asks what happened to our glorious graphical future?
2014-06-26
115 reads
Continuous Delivery and the Database
Continuous Delivery is fairly generally understood to be an effective way of tackling the problems of software delivery and deployment by making build, integration and delivery into a routine. Phil Factor explains why he's an enthusiast for databases being full participants in this story, and suggests practical ways of doing so.
2014-06-26
5,229 reads
What you need for a Multi Subnet Configuration for AlwaysOn in SQL Server 2012
You have a new project that requires a primary database server in one building and secondary database server in another building to be configured as a Failover Cluster. What are the important points to consider for this scenario?
2014-06-25
3,008 reads
How to Make Scalar UDFs Run Faster (SQL Spackle)
It's a well known fact that Scalar UDFs are the stuff of performance nightmares in T-SQL. But are they really as bad as they say? SQL Server MVP Jeff Moden shows us that they might not really be as big a problem as you might think and what you can do when they actually are.
2014-06-24 (first published: 2012-08-01)
27,750 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