Real World Common Table Expressions Maurice writes our newsletter today with some gold nuggets wrapped around different uses for Common Table Expresssions CTE are a great way to express business logic into SQL, by breaking querying elements into more meaningful part. I usually give them long names that express the meaning of each step into SQL. CTE makes rewriting of […]

Common Table Expressions Common Table Expressions are a feature of the SQL language that has grown on me over time. They are mandatory for some forms of query recursion, at least in SQL Server. However, I don’t have a lot of need for recursive queries. I find I use them most often for simplifying complicated queries. If you ever do […]

SSWUGtv With Stephen Wynkoop In this episode watch this informative interview with Devin Knight – SQL Server 2012 BI Guru. Steve and Devin talk about the concept of Self-Service Business Intelligence – including the Microsoft approach to self help in the form of a new product, PowerView. Watch the Show JavaScript Wrap Up Today we wrap up the topic of […]

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