TDE and SQL Server Databases

The article discusses and demonstrates TDE for SQL Server databases

SQL Server 2012 Integration Services - Using dtexec.exe to Run File System-based Packages

Marcin Policht explores a method of running SSIS packages that relies on the dtexec.exe utility.

Learning C

As we use computers more and more, and more people must develop algorithms or simple programs, Steve Jones says everyone should learn C. Perhaps they should learn SQL as well.

Red Gate’s new custom metrics site - with a little help from our friends

With contributions from MVPs and the SQL Server community, the SQL Monitor team at Red Gate has put together a custom metrics site, SQL Monitor Metrics, to accompany the release of SQL Monitor 3.2. The site hosts T-SQL scripts which can be imported directly to SQL Monitor for custom metric monitoring.

Implement Continuous Integration In Your Software Project

Continuous integration, or CI, brings developers closer to delivering error-free software flawlessly. Find out how to implement it.

PASS Data Architecture VC presents Louis Davidson on Designing for Common Problems in SQL Server

On Thursday August 16th 12PM noon Central, Louis Davidson will do a design and code review of several common patterns of solving problems that a typical programmer will come up against in SQL Server.

11 Tips to Backup databases with SMO, VB, C# Powershell, Command lines

Sometimes we need to create backups using code. Sometimes we need to do it manually or automatically, programmatically using C#, VB, Powershell.

Milk

Genome research into producing the best cows for milk has Steve Jones thinking about the implications for other industries. There could be new opportunities for data professionals.

Getting Started with Master Data Services (MDS) In SQL Server 2012

MDS allows you to create a centralized hub for creating and managing enterprise master data. Arshad Ali discusses how to install and configure Master Data Services in SQL Server 2012, and a method to deploy sample models.

Utilize SQL Server Storage Effectively

With the increased use of databases and the need to have more and more data online, database storage is an area DBAs need to manage effectively. If you plan your database and data management correctly you can build and manage a cost effective, high performing SQL Server solution. If not, you risk potential storage issues as well as performance degradation. This session will cover best practices and options focused on helping you manage your SQL Server storage. We will dive into the tools you can use to manage database storage, some of the latest trends, database design implications, data archiving and alternatives such as compression, BLOB data storage, filtered indexes and more. We’ll also introduce a tool that allows you to reduce the storage footprint of your live SQL Server databases.

Join us for this free event and learn how to utilize your SQL Server storage effectively.