SSWUGtv – SQL Server 2012 With Stephen Wynkoop In todays edition Steve interviews Gareth Swanepoel. Gareth talks about SQL Server 2012, extended events wizard and interface – how to performance tune, and more. Watch the Show Metro – What Is Behind It All? I’d like to wrap up my concerns about the Metro design principles with another epistle from David […]

Windows Metro – The Lowest Common Denominator The title is to get your attention. The fact is that Windows Metro will not necessarily be the Lowest Common Denominator anymore than other devices supporting tablet/smart phone style manipulations, primarily touch screens. Many good hardware devices are designed around the Android OS, which the Metro look and feel appears to emulate in […]

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

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

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

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