Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Guest Columnist: Solomon Rutzky

SQLServerCentral.com profile

   Items 1 to 15 of 15   
 

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.  Read more...
By Solomon Rutzky 2014/09/10 | Source: SQLServerCentral.com | Category: sqlclr
Rating: |  Discuss |   Briefcase | 1,714 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.  Read more...
By Solomon Rutzky 2014/05/28 | Source: SQLServerCentral.com | Category: sqlclr
Rating: |  Discuss |   Briefcase | 1,990 reads

Stairway to SQLCLR Level 2: Sample Stored Procedure and Function

In the second level of our Stairway to SQLCLR, we look at how to enable the SQLCLR in SQL Server. We then build an assembly, store procedure, and a function that can be called from your T-SQL code.  Read more...
By Solomon Rutzky 2014/02/19 | Source: SQLServerCentral.com | Category: sqlclr
Rating: |  Discuss |   Briefcase | 4,929 reads

Stairway to SQLCLR Level 1: What is SQLCLR?

The first step to using the SQLCLR begins with this overview of what is possible and what is not. Start your journey to decide if this is a tool you can use inside your SQL Server instance.  Read more...
By Solomon Rutzky 2014/01/09 | Source: SQLServerCentral.com | Category: sqlclr
Rating: |  Discuss |   Briefcase | 9,528 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.  Read more...
By Solomon Rutzky 2012/10/05 (first published: 2011/04/26) | Source: SQLServerCentral.com | Category: data modeling
Rating: |  Discuss |   Briefcase | 18,893 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.  Read more...
By Solomon Rutzky 2013/10/25 (first published: 2010/12/31) | Source: SQLServerCentral.com | Category: data-modeling
Rating: |  Discuss |   Briefcase | 13,357 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.  Read more...
By Solomon Rutzky 2010/05/04 | Source: SQLServerCentral.com | Category: partitioning
Rating: |  Discuss |   Briefcase | 5,727 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.  Read more...
By Solomon Rutzky 2009/12/23 | Source: SQLServerCentral.com | Category: sqlclr
Rating: |  Discuss |   Briefcase | 7,111 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.  Read more...
By Solomon Rutzky 2009/05/28 | Source: SQLServerCentral.com | Category: sql server 2008
Rating: |  Discuss |   Briefcase | 8,304 reads

Easy and Repeatable Testing of DB Code (Stored Procs, etc.) with DbFit

Testing DB code is not fun or easy so it usually gets ignored. But now there‚Äôs a super-easy way to test using DBFit.  Read more...
By Solomon Rutzky 2008/11/13 | Source: SQLServerCentral.com | Category: testing
Rating: |  Discuss |   Briefcase | 9,675 reads

Exporting and Versioning Lookup Data: A Real-World Use of the CLR

The CLR has not been well-received and most people use it for Regular Expressions and string functions. Here is an example that goes beyond trivial uses.  Read more...
By Solomon Rutzky 2008/06/24 | Source: SQLServerCentral.com | Category: sql server 2005
Rating: |  Discuss |   Briefcase | 5,114 reads

Searching Objects for Text

When searching meta-data to find an occurance of a particular string or pattern it is difficult to look everywhere. This procedure helps you find what you are looking for.  Read more...
By Solomon Rutzky 2008/05/28 | Source: SQLServerCentral.com | Category: stored procedures
Rating: |  Discuss |   Briefcase | 6,699 reads

A New (and Hopefully Better) Approach to Constants

A look at how constants are used in T-SQL and SQL Server in general along with some suggestions on how better to deal with them.  Read more...
By Solomon Rutzky 2007/10/16 | Category: t-sql
Rating: |  Discuss |   Briefcase | 6,875 reads

Getting The Most Out of SQL Server 2005 UDTs and UDAs

The CLR integration in SQL Server 2005 greatly expands on the capabilities of the SQL Server platform. One new area is the ability to build user-defined types and user-defined aggregates. Solomon Rutzky brings us a way to get around some of the limitations in this area with his SQL# toolkit.   Read more...
By Solomon Rutzky 2007/09/18 | Source: SQLServerCentral.com | Category: sql clr
Rating: |  Discuss |   Briefcase | 4,764 reads

Capturing Missing Information From SQL Profiler

While SQL Server's Profiler is a great tool, it can be hard to work with and we can easily miss information in the results. New author Solomon Rutzky brings us a short article that can help you to better configure your traces to get the information you need.   Read more...
By Solomon Rutzky 2007/09/06 | Source: SQLServerCentral.com | Category: monitoring
Rating: |  Discuss |   Briefcase | 9,382 reads
   Items 1 to 15 of 15