SQL Server 2019 Feature Power Rankings
Watch this week's video on YouTube
With the release of SQL Server 2019 imminent, I thought it'd be fun to rank which features I am most looking forward to in...
2019-10-29
6 reads
Bert Wagner
SQL Server Stored Procedures vs Functions vs Views
Watch this week’s episode on YouTube. SQL Server has several ways to store queries for later executions. This makes developers happy because it allows them to follow DRY principles: Don’t Repeat Yourself....
2019-11-04 (first published: 2019-10-22)
3,039 reads
SQL Server Stored Procedures vs Functions vs Views
Watch this week's video on YouTube
SQL Server has several ways to store queries for later executions.
This makes developers happy because it allows them to follow DRY principles: Don't Repeat Yourself. The more...
2019-10-22
10 reads
SQL Server Stored Procedures vs Functions vs Views
Watch this week's video on YouTube
SQL Server has several ways to store queries for later executions.
This makes developers happy because it allows them to follow DRY principles: Don't Repeat Yourself. The more...
2019-10-22
15 reads
Are Stored Procedures Faster Than Stand-Alone Queries?
Watch this week’s episode on YouTube. A few months ago I was presenting for a user group when someone asked the following question: Does a query embedded in a...
2019-10-24 (first published: 2019-10-15)
1,688 reads
Are Stored Procedures Faster Than Stand-Alone Queries?
Watch this week's video on YouTube
A few months ago I was presenting for a user group when someone asked the following question:
Does a query embedded in a stored procedure...
2019-10-15
12 reads
Are Stored Procedures Faster Than Stand-Alone Queries?
Watch this week's video on YouTube
A few months ago I was presenting for a user group when someone asked the following question:
Does a query embedded in a stored procedure...
2019-10-15
6 reads
Communicating Effectively at the Workplace
This post is a response to this month’s T-SQL Tuesday #119 prompt by Alex Yates. T-SQL Tuesday is a way for the SQL Server community to share ideas about different database...
2019-10-10 (first published: 2019-10-08)
420 reads
Communicating Effectively at the Workplace
This post is a response to this month's T-SQL Tuesday #119 prompt by Alex Yates. T-SQL Tuesday is a way for the SQL Server community to share ideas about different database...
2019-10-08
3 reads
Communicating Effectively at the Workplace
This post is a response to this month's T-SQL Tuesday #119 prompt by Alex Yates. T-SQL Tuesday is a way for the SQL Server community to share ideas about different database...
2019-10-08
4 reads
Blogs
Blog a Day – Day 1: History of AI
By Vinay Thakur
it has been a year since i have not written much on the blog...
A New Word: on tenderhooks
By Steve Jones
on tenderhooks – adj. feeling the primal satisfaction of being needed by someone, which...
Ramblings about data communities and your contributions, no excuses
By DataOnWheels
I have been active in the data community throughout my career. I have met...
Forums
Ola Hallengren Index Optimize Maintenance can we have data compression = page
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
how do i map the "current" object entry in for each to one variable
hi, in an ssis for each loop over an object variable called MyListVariable, i...
Simulating Mercury’s Orbital Motion Using Pure T-SQL (NASA 2025 Dataset)
SQL Server is typically viewed as a transactional or analytical database engine. However, it...
Question of the Day
String Similarity I
On SQL Server 2025, when I run this, what is returned?
SELECT EDIT_DISTANCE_SIMILARITY('SQL Server', 'MySQL') See possible answers