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. […]
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. […]
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 […]
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 […]
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 […]
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 […]
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 […]
What?s the Fastest Disk?
SSWUGtv With Stephen Wynkoop Don’t miss this episode of SSWUGtv where Stephen interviews Josef Richberg, talking about SSIS. Joseph covers common mistakes, things to know and tips – all for SSIS and SQL Server. Watch the Show Scheduling Tools for Windows Chron Jobs Richard writes: We’ve been using SQL Sentry for five years (or more). It’s one of the best […]
Scheduling Tools
Scheduling Tools I wrote about scheduling in Azure yesterday as a place where some of the tools we have become accustom are not available. My primary tool of choice for scheduling has been SQL Server Agent, being primarily a DBA for decades. One reader, Shannon, reminds us that there are a lot of capabilities built into Azure allowing for tasks […]
Scheduling Tools
Scheduling Tools I wrote about scheduling in Azure yesterday as a place where some of the tools we have become accustom are not available. My primary tool of choice for scheduling has been SQL Server Agent, being primarily a DBA for decades. One reader, Shannon, reminds us that there are a lot of capabilities built into Azure allowing for tasks […]