Compressed Microsoft SQL Server Backups by Default
Learn how to create default database compression for your SQL Server databases.
2019-04-30
SQL Server
Introduction to SQL Server Security — Part 4
The sa account is the most powerful account in a SQL Server instance, and most DBAs disable it. There are several other built-in accounts that you may not think about that often. Robert Sheldon continues his SQL Server security series with an article about built-in accounts.
2019-04-08
Shrinking SQL Server Backup Files and Speeding Up Backups
With backup compression you can speed up our backups, while making your backups smaller.
2019-03-19
3,656 reads
SQL Server Referential Integrity Across Databases Using Triggers
In this tip we cover how you can implement SQL Server cross database referential integrity using triggers.
2019-03-13
2,377 reads
Isolation Levels in SQL Server
Details discussion on the different isolation levels available in SQL Server
2019-03-12
184,034 reads
Introduction to SQL Server Security — Part 2
In this article, the second in the series, Robert Sheldon demonstrates how to manage the SQL Server security with granting permissions to users, logins, and groups.
2019-02-25
2,336 reads
Which Version of SQL Server Should You Use?
Wait! Before you install that next SQL Server, hold up. Are you sure you’re using the right version?
2019-02-08
4,012 reads
Working with SQL Server Stored Procedures and .NET
Learn how to build a simple .NET application that uses SQL Server stored procedures to retrieve and update data from a database.
2019-01-03
3,952 reads
SQL Server Auditing for HIPAA and SOX – Part 4
Regulations may require that you audit exactly who does what in your databases. Robert Sheldon explains how SQL Server can help you meet those requirements with its built-in auditing capabilities.
2018-11-27
2,290 reads
Generate documents from SQL Server
Automating population of SQL Server data into Word and PDF document templates for contracts, invoices,letters etc. creation saves thousands of hours for businesses. This article explores various approaches and offers few suggestions on how to choose the best approach for your requirements.
2018-10-08
8,867 reads
Blogs
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...
dataMinds Saturday 2026 – Slides
At Saturday the 21st of February I’m presenting an introduction to dimensional modelling at...
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