Using PowerShell to Manage SQLServer
This article provides a practical example of how Powershell can be used by DBAs.
ERDDUG - Introduction to Indexes with SQL Server MVP Gail Shaw
If you are in South Africa near East Rand, join the East Rand Developer and DBA group on April 9 for a presentation by SQL Server expert, MVP, and longtime SQLServerCentral author, Gail Shaw.
How To Fix Connect
Today Steve Jones asks for your ideas on Microsoft's Connect. It's a good way to submit bugs and suggestions, but it seems to suffer from a scale problem. What do you think would help?
Industrial-strength database documentation using Extended Properties
To finish this short series on extended properties a look at documenting sets of database objects
Change SQL Startup Parameters with PowerShell
Sometimes when we’re trying to track down a problem and looking through SQL’s Logs we have to dig...
SQL Saturday - #74 - Jacksonville
Come attend this free one day training event in Jacksonville, FL on Apr 30, 2011. Meet a number of SQL Server experts and learn about SQL Server at the University of North Florida.
TOP 10 SQL Server Requests That Should Be Automated
What DBA wouldn't want to make their job a little easier?
DBAs on ACID
Any DBA who has been bitten by these subtle data integrity issues, or reports that erratically produce the wrong results, will know how much careful testing is involved in mitigating them.
Real World Foreach Loop Container example
Describes different uses of the SSIS Foreach Loop container in one practical scenario.
The Value of Data
What value can you place on data? It can be hard to determine, especially when so many sites on the Internet want data to be free. However the New York Times is going to a subscription model, with the idea that there is some value to their data and people will pay for it.
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