Modify Model Database Every once in a while I get an Email from Feodor Georgiev highlighting recent blogs he has posted on the web. Last week I received a new Email pointing out that you cannot change the file groups in the model database. His interest in making this change was based on a previous study he performed for scenarios […]

SSWUGtv – Security Tips With Stephen Wynkoop When you are protecting your software assets encryption is a common method. What types of things need to be encrypted? In today’s show and find valuable tips from Security Expert, Patrick Townsend. Watch the Show Eventually Consistent This is a term with increasing importance as companies move toward NoSQL data storage solutions. The […]

PowerShell is a Hit If the feedback from our readers today is representative of the PowerShell experience as a whole, I would say it has a great following from the SQL Server DBA crowd. Many of us work in shops where the high end monitoring tools are too expensive to cost justify. However, with a little learning, a great deal […]

PowerShell with SQL Server Over the years I have used so many different tools to support managing SQL Server on a Windows Server. We had command shell tools as old as ISQL along with the more recent SQLCMD. We had tools more closely related to SQL Server in the form of DTS and later SSIS. Microsoft also released management APIs […]

Partial Methods Yesterday we talked about Partial Classes; a technique where you can place a portion of a type definition in multiple locations, pulled together at compile time. Paulo reminds us that not only can you have different aspects of a type defined in multiple files, you can also split a method placing part of it in one file, and […]

SSWUGtv With Stephen Wynkoop The end of the year is coming soon. One of the many things that happens at the end of the year is a review of your peformance this past year. Many companies have their employees set goals for personal development. Acheiving these goals may have impact on promotions, salary, project assignments, etc. Watch the show today […]

SSWUGtv With Stephen Wynkoop Security is an area of change. The goals are still the same. How we implement our security continues to evolve along with our software platforms. On todays show, Patric Townsend continues his series on security with the question, What’s the difference between dual-control and separation of duties? Watch the Show DBA Role Clarification Not every business […]

The Changing Role of the DBA Another trend becoming the responsibility of the DBA is that of the Data Access Layer (DAL) in multi-tier software. I believe this may be due to the fact that the DBA is the most intimately in tune with the relational data structures, and may be best qualified to modify those structures, and make them […]

Changing Role of the DBA Continuing with this series I wanted to share some thoughts about how development of databases has changed over time. Prior to my transition to Agile software development I worked with DBA teams as a side group. This team worked with both operations and software development. Working with operations we were responsible to keep all systems […]

Changing DBA Roles Continuing with the series on the changing roles of a DBA I wanted to talk today about production Access Control. I mentioned that working on a fast paced Agile team the last 7 years resulted in a number of process changes. One change that has occurred, not due to an Agile process per se, but due to […]