Disabled Indexes Can Hurt You – Badly Recently I read a white paper put together by Brent Ozar entitled “Six Scary SQL Surprises” at http://www.red-gate.com/products/dba/dba-bundle/entrypage/hard-earned-lessons-3. If you support any database it is worth your time to read. I have been working with databases for decades (more than I want to admit) and I still found ideas I hadn’t considered. I […]

SSWUGtv With Stephen Wynkoop Why is it so important to pay attention to the security of your data and services? Risk-management! Check out the security tips Townsend shares with Steve today! Watch the Show The Holy Grail of Software Development “Write Once/Run anywhere” has been a dream of software developers for decades. It’s like a Holy Grail or Eldorado…something really […]

Automating Database Change In order to efficiently make incremental database changes you need to have a few things in place. One of the requirements is a continuous integration and deployment capability. Today I present a link to a well-designed framework by Alexander Karmanov which he has published on the internet for your review at www.simple-talk.com/sql/database-administration/an-incremental-database-development-and-deployment-framework.. We talked about this topic […]

Windows and SQL Server Updates If we don’t apply Automatic Updates for Windows or SQL Server, what becomes a good practice. Our recent series on Automatic Updates was overwhelming to disable the engine. Robert wants to know what practices are being followed instead? Some companies don’t apply updates, or apply them haphazardly. I helped a company fix a bug that […]

SSWUGtv – Are Interns for You? With Stephen Wynkoop In today?s economy, many companies are investing in interns. This is a cost-effective way to temporarily solve their resource needs as well as get in an early bid on the upcoming talent. But what type of tasks and preparation is needed? Watch the Show Is SQL Injection Still an Issue? As […]

$$SWYNK$$ Immutable Objects Immutable objects are a technique in object oriented programming where the properties of an object are read only. If they need to be changed, this is done through the creation of a new object of the same type, having the desired changes. Perhaps some of the original values are retained and only a few are modified. Perhaps […]

$$SWYNK$$ SSWUGtv – Deployment Projects With Stephen Wynkoop What is the process of a typical deployment project, and how do you make it successful? Today Steve interviews Patrick Townsend sharing some great ideas. Watch the Show Server Techniques for Applying Windows Updates Many have written in regarding policies for Continuous Release (Automatic Windows Updates) for server environments. All have consistently […]

Automatic Windows Update Practices Raising the topic of Windows Updates could be considered fishing for input, because it is such a controversial issue. It’s easy to get people to provide feedback because many of us have been saved or crushed by the capability. It seems to me that there may be different policies or practices for the use of Automatic […]

Automatic Updates Yesterday, as I was writing about Continuous Release, I was trying to think of examples that would be common to you. One I suggested would be the Google Chrome Browser. You may well have known that. But, did you know that Adobe Flash, as encapsulated in the Google Chrome Browser, automatically uploads the latest release to your computer […]

$$SWYNK$$ SSWUGtv – Close the Inteview With Stephen Wynkoop How do you successfully close an interview? Find out, with Laura Rose’s professional development tips. Watch the Show The Difference Between Continuous Integration and Continuous Release Continuous Integration and Continuous Release are two of the more modern software development practices. However, they are quite different in concept. Continuous Integration, as I […]