sys.sql_modules vs. INFORMATION_SCHEMA.Routines
Consider the following two queries meant to search for a keyword in SQL programmability objects.
select s.name +'.' + o.name, o.type_desc, m.definition
from sys.sql_modules...
2012-04-18
1,975 reads
Blog Posts
Urgent BIOS Update for Dell PowerEdge R810, R910 and M910 Servers
If you have an 11th generation Dell PowerEdge R810 , PowerEdge R910 server, or a PowerEdge M910 blade server, there is...
2012-04-18
2,172 reads
Visualize Wait stats with Microsoft Excel
In our blog post last week: Instance Wide Wait Stats we promised to show You how to visualize the collected...
2012-04-18
1,179 reads
Welcome IIF() to SQL Server Family
IIF() function is new to SQL Server family of functions. It is a brand new logical function being introduced with...
2012-04-18
232 reads
Backup Database Object
I saw this question in one of forums on backing up i.e. scripting out a database object. The problem is...
2012-04-17
1,816 reads
Better Living Thru Powershell: Update Statistics in Parallel
As part of a project I’m currently involved with, we’re migrating a database to SQL Server 2008 and performing some...
2012-04-17 (first published: 2012-04-12)
2,837 reads
Book Review: American Icon: Alan Mulally and the Fight to Save Ford Motor Company
American Icon: Alan Mulally and the Fight to Save Ford Motor Company ($18 at Amazon) was a good read, with...
2012-04-17
768 reads
Choosing the Right Microsoft Reporting Technology Part 5: Power View
In part five of this on going series about choosing the right reporting tool we will discuss the newest of...
2012-04-17
1,622 reads
ColoradoSQL–April 2012
All ColoradoSQL user group meetings start at 5:30 p.m. and provide food and refreshments. There is no cost to attend...
2012-04-17
838 reads
Execute T-SQL Statement Task
I spotted a new task in SSIS 2012 – Execute T-SQL Statement Task. It executes T-SQL statements, only Transact-SQL statements against...
2012-04-17
1,182 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