Why I am Excited about SQL Server on Linux
Read why Solomon Rutzky is excited about SQL Server running on Linux.
2017-03-02
560 reads
Solomon Rutzky
- Interests: Computers (duh ;-), religion, sarcasm, chocolate covered raisins
- Website: https://SqlQuantumLeap.com/
- LinkedIn: https://www.linkedin.com/in/srutzky/
Stairway to SQLCLR Level 7: Development and Security
Learn about some Visual Studio features that help with automation, and use them to create an Asymmetric Key and Login.
2016-03-02
5,747 reads
Stairway to SQLCLR Level 5: Development (Using .NET within SQL Server)
This time we take a look at various aspects and limitations of working with SQL Server's CLR that affect what can be done and how to do certain things.
2015-03-11
16,116 reads
Stairway to SQLCLR Level 4: Security (EXTERNAL and UNSAFE Assemblies)
In the fourth level of our Stairway to SQLCLR series we take a detailed look at the EXTERNAL_ACCESS and UNSAFE permission sets. We also explore some differences between using TRUSTWORTHY or an Asymmetric Key.
2014-09-10
13,772 reads
Stairway to SQLCLR Level 3: Security (General and SAFE Assemblies)
In the third level of our Stairway to SQLCLR, we look at the various mechanisms in place to help us control Security. In this Level we will focus on SAFE mode and see how secure SQLCLR is by default.
2014-05-28
8,030 reads
Disk Is Cheap! ORLY?
People often conclude that the cheap price of storage is a license to use as much as possible, but there is a cost.
2013-10-30 (first published: 2010-12-31)
17,983 reads
Restructure 100 Million Row (or more) Tables in Seconds. SRSLY!
Changing the structure of a very large table doesn't need to require a maintenance window.
2012-10-05 (first published: 2011-04-26)
22,213 reads
Improving Performance of Cross-Partition Queries
Table partitioning was added in SQL Server 2005 and increases performance in most cases but decreases it in others.
2010-05-04
7,381 reads
CLR Table-Valued Function Example with Full Streaming (STVF / TVF)
SQL CLR Table-Valued Functions can stream data back, but there aren't many examples of the quick and easy method. Solomon Rutzky brings us an article that givse you an example you can extend to your environment.
2009-12-23
13,472 reads
Streaming Data Into SQL Server 2008 From an Application
Reduce both time and memory utilization when uploading bulk data to SQL Server 2008 by combining Table-Valued Parameters (TVPs) and the .Net IEnumerable interface.
2009-05-28
14,407 reads
Blogs
Claude Code Helps Analyze Test Data Manager Log Files
By Steve Jones
I had a customer ask about analyzing their Test Data Manager (TDM) usage to...
PowerPoint to HTML with Claude AI
By Steve Jones
I had an idea for an animated view of a sales tool, and started...
Don’t Miss Out – SQL Server Query Tuning Fundamentals Starts Next Monday!
Next Monday, February 9, 2026, my one-day live online training SQL Server Query Tuning...
Forums
SQL Server 2025 Query Performance Tuning: Troubleshoot and Optimize Query Performance
Comments posted to this topic are about the item SQL Server 2025 Query Performance...
Is it uncommon for Dev's to have a data model of the source data
This is a generic question. To the moderators, I wasn't sure where to place...
ROLLUP to calculate Month total for all Categories
Good Afternoon, I have built a table with four columns: Period(Month), Category, Numerator, Denominator....
Question of the Day
Creating JSON I
On SQL Server 2025, what happens when I run this code:
SELECT JSON_OBJECTAGG( 'City':'Denver') GOSee possible answers