SOLID Followup Today one of our readers, David, who contributes regularly to our editorial, submits three points we should consider when using SOLID principles. David Writes: It’s always good to take a “refresher course” on basic principles and practices now and then. And discussing basic principles often takes a back seat to the mechanics of basic skills or how to […]

SSWUGtv With Stephen Wynkoop In todays edition Steve meets with Laura Rose asking the question "What is the place of socializing (texting, IM, etc) in the workplace?" You may be surprised at some of the answers. Watch the Show SOLID – Dependency Inversion Principle This is the last in the series of SOLID principles, covering the topic of Dependency Inversion. […]

SSWUGtv With Stephen Wynkoop In this edition Laura Rose shares tips about how to work with people who take more than they give? Watch the Show Join Tables Ali writes in asking, “Would you please share some example about Join Tables in Ms. SQL Server 2005- 2008?” Ali, Today is the day. If I understand your question correctly a join […]

SSWUGtv With Stephen Wynkoop In this edition Steve talks with Laura Rose about "How do you maintain confidence in your job when your boss leaves the company". Watch the Show Dot Net ThreadPool and Timers I have been playing with the System.Threading.Timer object in Dot Net for a couple days now. Historically I have used timers in forms, so I […]

SSWUGtv With Stephen Wynkoop Laura Rose is back again in this edition of SSWUG tv with some great advice on "What do you do when your peer is promoted – how do you shift your relationship?" Watch the Show Max Degrees of Parallelism and Query Optimization In response to the editorial from last Friday regarding SQL Server Parallel Queries, Derek […]

SQL Server Running on Windows Server Core Windows Server Core is a Microsoft Windows Server deployment option reducing the overhead of the Windows Server operating system in a targeted fashion by installing and enabling only the minimum required components for the server to perform necessary tasks. For a machine dedicated to the single purpose of hosting SQL Server, this would […]

Hands-On Busines Intelligence workshop with Brian Knight Taught by the master, this seriously hands-on workshop will take you from start to finish with practical creation of a data warehouse solution. You’ll learn the real-world things you need to know, and you’ll be learning them from the master of BI, Brian Knight. The workshop will be held in the SSWUG.ORG offices, […]

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