Latest Video Programs

SSWUGtv: How introverts can break into a manager role even though they aren\'t the most aggressive/outspoken?

SSWUGtv: How introverts can break into a manager role even though they aren\'t the most aggressive/outspoken?

SSWUGtv Security Edition: Encrypting data for higher education institutions with Steve and Patrick Townsend.   SSWUGtv: Today, Steve discusses making checklists for your systems.   SSWUGtv Security Edition: Key management vs. key storage with Steve and Patrick Townsend.  

From the Editor's Desk...

Another Approach to Applying Open/Closed to TSQL  -  Maurice submits an interesting technique for implementing the Open/Closed principle to TSQL through the use of Views and View Triggers.

An Open/Closed TSQL Approach  -  Today Aaron shares his approach to implementing the open/closed principle in TSQL programming.

Is SSIS Right For You?  -  I love SSIS. It is an awesome ETL tool with lots of bells and whistles. Interestingly, I have found myself moving away from a pure SSIS implementation as I introduced testing to my work. I haven't stopped using SSIS; but it is not my only solution either.

Can You Implement the Open/Closed Principle in SQL?  -  The Open/Closed principle is easy to apply in an object oriented language. Does it make sense to attempt to follow open/closed in SQL Code?

Sharding With a Purpose  -  Today we take a brief look at sharding techniques. See if Sharding is right for you.

Sharding for Scale, Cost and Performance  -  Some systems are sharded placing data on multiple servers to reduce cost, increase performance and increase scalability. With the many options maturing what should you consider now?

Where Do You Put Your Unstructured Data?  -  Many engines have been competing for storage of unstructured data. SQL Server introduced the XML data type. Many NoSql engines target unstructured data. What tools are you finding useful currently?

What Do You Think of Hybrid Environments?  -  Combining on-premise solution with the cloud-based solutions just became a bit trickier. Have you seen the latest court ruling regarding storage and your rights? How does this impact your own planning?

Processing Sets in a Remote SQL Instance  -  Some architectures require you to manipulate your SQL data locally and in a remote SQL data store. When that happens your options are limited. What methods do you find effective?

Developing Report Models - (Part 1)

In this article, we will identify the components of a report model and then learn how best to use the Report Services tools to develop a report model. We will a...

Guidelines for Multilingual Web Design

Globalization and multiculturalism have redefined online marketing. Consequently, Web design as such must also keep up with the requirements of the present-day ...

Community Content - News, Articles, How-To Information and More from Around the World