Why I am Excited about SQL Server on Linux
Read why Solomon Rutzky is excited about SQL Server running on Linux.
2017-03-02
470 reads
Read why Solomon Rutzky is excited about SQL Server running on Linux.
2017-03-02
470 reads
Learn about some Visual Studio features that help with automation, and use them to create an Asymmetric Key and Login.
2016-03-02
5,078 reads
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
14,579 reads
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
12,215 reads
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
7,218 reads
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,427 reads
Changing the structure of a very large table doesn't need to require a maintenance window.
2012-10-05 (first published: 2011-04-26)
21,831 reads
Table partitioning was added in SQL Server 2005 and increases performance in most cases but decreases it in others.
2010-05-04
7,188 reads
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
12,661 reads
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
13,739 reads
Today I was having a nice discussion with some colleagues about Fabric and pricing/licensing...
By Steve Jones
As I’ve been working with SQL Saturday and managing changes to events, I’ve accumulated...
By James Serra
Starting last week is a rollout of the public preview of a new and...
By Stewart "Arturius" Campbell
Comments posted to this topic are about the item Read Only Replica in SQL...
Comments posted to this topic are about the item Identifying Customer Buying Pattern in...
I've had some backups of my encrypted databases failing with the error "BACKUP 'DBName'...
Our environment runs using SQL Server Standard. We are implementing Availability groups. Our database has been experiencing high read volumes, so I want to let the application read the Synchronized Secondary replica, as I read that HADR does this. Can we implement this?
See possible answers