Lookup Tables Design Question Today Robert Asks, “How would you store categories from various tables? Assume 50 tables with a category column, such as PurchaseOrderCategoryID, BuildingCategoryID, etc. There are about 20 categories per table, or about 1,000 distinct categories in the entire database. Would you store each table’s categories in individual tables, such as PurchaseOrderCateogroy and BuildingCategory, or would you […]

SSWUGtv With Stephen Wynkoop In today’s episode: keeping the end in mind: Laura Rose teaches you how to take stock of your business and make good goals. Watch the Show Hidden Rounding Many versions of SQL support a Decimal data type. Microsoft SQL Server, in particular, allows the user to specify the total number of digits as well as the […]

SSWUGtv With Stephen Wynkoop What does a solid contract look like that is fair to all parties? As you contract with customers, (or consultants) what are the key things to look for? Help is here….with Coach Laura Rose. Watch the Show Views Out Of Control Views have been a core feature of SQL Engines for many years. For all I […]

The Future of the Mainframe Today we have some feedback from readers regardign they experience working with the Mainfame computer for the last couple fo decades… Alexander writes: I started as a mainframe developer back in 1994 when COBOL was still taught in universities in the US. However, after Y2K and the resulting advent of outsourcing I haven’t worked on […]

SSWUGtv With Stephen Wynkoop In this episode: SQL Server tip of the day – working with your indexes – some tips and approaches. Watch the Show Readers Responses Today we have responses from our readers regarding the Editorial from yesterday, considering the position of the mainframe computer, and dealing with advancing age in the workplace. James gives us more background […]

Is the MainFrame Computer Obsolete? There is no single machine that can push bits around like a mainframe computer. They also have decades of tools that make batch processing incredibly powerful and fast. For chunking lots of data, they rock. Over the last decade different systems have begun to intrude into this once dominated workhorse territory using different techniques. AS/400 […]

SSWUGtv News With Stephen Wynkoop LinkedIn, eHarmony what it means for DBAs, interview tips, Google and more news from the week. Watch the Show A Little Humility Helps Friday I responded to a question from an individual preparing to graduate from training in computer science, asking what is important to build a career. In my response I emphasized the need […]

SSWUGtv With Stephen Wynkoop In today’s edition of SSWUGtv, Steve interviews Paul Zikopoulos. Wach as Steve discusses Querying big data stores and declaritive languages for working with big data. Hear IBM’s new approaches and ideas… Watch the Show Skills You are Going to Need Today, in response to an Email from Srini I am brainstorming on skills that are necessary […]

SSWUGtv With Stephen Wynkoop Watch or listen (pod casts are available too) as Steve interviews Laura Rose on the show today talking about micro-managing… and specifically how and why to avoid it. Watch the Show Slow Drain Devices This is not a term I dreamt up. While surfing the web for causes of high SQL Server disk queue wait times […]

SSWUGtv With Stephen Wynkoop SQL Server Tip of the Day – handling big data… quantities. Tips and food for thought Watch the Show Interviewing Ideas Today I share thoughts from you, our readers, in response to yesterday’s editorial on "What is Important When Interviewing Software Developers?" Kerry: The first question I always ask is "do you enjoy coding". There are […]