Featured Article(s) System Health Session Dashboard – Error Summary Report In the first post of this series, I had talked about displaying the events reported by the system health session extended session on SQL Server 2008 versions and higher. The next set of reports will show the errors which by the error_reported extended event. Featured White Paper(s) Encryption & Key […]

JavaScript Comes of Age Yesterday I introduced patterns in JavaScript. While looking further into JavaScript I came across node.js. Node.js is a “Platform built on Chrome’s JavaScript RunTime”. The thing that caught my attention about Node.js is the ability to write code that may run on the server or in the client browser in the same language. Now there are […]

JavaScript Patterns What, how can there be patterns in a scripting language? That was what I asked myself when I came across the book titled “JavaScript Patterns.” So, I had to look into it. Here are a few bullets from the back cover: Create objects that go beyond the basic patterns of using object literals and constructor functions Learn the […]

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 […]

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 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 […]

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 […]

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? 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 […]

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 […]