Doing DevOPs for your Database? You need to start here…
I’ve been doing that thing called DevOPs for about 17 years – you know – before it had a name…
In fact it...
2018-02-28
1,256 reads
Blog Posts
New Built-in Function STRING_AGG() – SQL Server 2017
SQL Server 2017 introduces a set of useful functions like STRING_AGG(), STRING_SPLIT(), TRIM()… and many more. In this tip, I am...
2018-02-28
9,368 reads
Offline installation of SQL Server 2017 on Linux
SQL Server is now compatible with different Linux distributions, and there is a lot of excitement about it.How ever one...
2018-02-28
4,179 reads
PASS Summit 2018 – Call for Speakers
It is that time again. PASS has opened the Call for Speakers. I have submitted for the past 10 years,...
2018-02-28
477 reads
Safely and Easily Use High-Level Permissions Without Granting Them to Anyone: Server-level
Part of having good security is giving users the fewest / least permissions possible in order to execute the code. However,...
2018-02-28 (first published: 2018-02-15)
2,637 reads
SQL in the City is Live
You can watch on YouTube now: https://www.youtube.com/watch?v=0qyMutBkZsg
If you want slides and notifications, register on the Redgate hub.
We’re recording the sessions...
2018-02-28
845 reads
Using the Full Screen Mode in SSMS (Day 33)
Do you ever find yourself working on a query and realize that you need just a bit more real estate...
2018-02-28
546 reads
Adaptive Joins
I was surprised to find out that a lot people hadn’t heard about the new join type, Adaptive join. So,...
2018-02-27
1,140 reads
How to make a Database Request
You need something from the database admin. Maybe it’s permissions, maybe it’s code troubleshooting, or maybe it’s just that the database is...
2018-02-27
494 reads
Planning to Increase Cost Threshold for Parallelism – Like a Smart Person!
Planning to Increase Cost Threshold for Parallelism
When administrating a SQL Server instance with multiple CPU cores and heavy workload, it’s...
2018-02-27
1,135 reads
Blogs
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...
SQL Server Journey till 2025 (brief)
By Vinay Thakur
Quick Summary for Microsoft SQL Server till 2025, I am fortunate to be part...
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