Author: Ben Taylor

Editorials

CLR Capability in SQL

SSWUGtv With Stephen Wynkoop In todays issue of SSWUGtv Steve interviews Dan Clark as he shares his thoughts bout self-service BI. Is PowerPivt the tool you should be using? Find the answers here on this edition of SSWUGtv. Watch the Show CLR Capability in SQL We have been discussing the value of the CLR in SQL Server for the last […]

Editorials

Should Programs be separated from Data?

SSWUGtv with Stephen Wynkoop Can your MySQL database scale? If not, what are your options? Do you need to purchase a bigger machine? Do you need to purchase a sharding wrapper, or write your own data broker allowing your databases to shard? Instead, you now have the option to take advantage of the Cloud Database As a Service from Xeround. […]

Uncategorized

Final CLR Response

Final CLR Response Today one of our readers digs into a topic I connect with every once in a while regarding the role of your database server. The key question is, “what kinds of roles do you want your database server performing?” As I work with larger and larger databases, my tendency is to put the least amount of extraneous […]

Editorials

Final CLR Response

Final CLR Response Today one of our readers digs into a topic I connect with every once in a while regarding the role of your database server. The key question is, “what kinds of roles do you want your database server performing?” As I work with larger and larger databases, my tendency is to put the least amount of extraneous […]

Uncategorized

Editorial Thoughts for Today

What to do with SQL CLR There are a lot of things much easier, or more efficient, when done in SQL Server using the CLR. Here are some of the ones I have done. Most of these were done before SQL Server 2008. Some are redundant with features available in SQL Server 2008, but only ship with the Enterprise or […]

Editorials

Editorial Thoughts for Today

What to do with SQL CLR There are a lot of things much easier, or more efficient, when done in SQL Server using the CLR. Here are some of the ones I have done. Most of these were done before SQL Server 2008. Some are redundant with features available in SQL Server 2008, but only ship with the Enterprise or […]

Editorials Encryption/Data Security

CLR in Azure

SSWUGtv With Stephen Wynkoop In this episode Steve takes on the difficult task of cleaning data. Do you clean it first and then bring it in? Do you bring it in and then cleanse it. How about transforming data to fit your schema. Watch as Steve interviews key players in the data cleansing world. Watch the Show CLR in Azure […]

Editorials

CLR in Azure

SSWUGtv With Stephen Wynkoop In this episode Steve takes on the difficult task of cleaning data. Do you clean it first and then bring it in? Do you bring it in and then cleanse it. How about transforming data to fit your schema. Watch as Steve interviews key players in the data cleansing world. Watch the Show CLR in Azure […]

Uncategorized

Should You Use CLR Capabilities?

Should You Use CLR Capabilities? My particular question about CLR capabilities is that I have enjoyed using them for years. Now, considering the utilization of Azure I find they are not available. The reason, you don’t have direct access to disk subsystems in the Azure world, and CLR assemblies require a path in order to work. Sounds like a broken […]