Sometimes when working with SSIS you need to add or change settings in the .NET application configuration file, which can be a bit confusing when you are building a SSIS package not an application. First of all lets review a couple of examples where you may need to do this.
Read a sample chapter from this new book about C# and LINQ from Murach.
The post snapshot script in replication allows you to make changes to the subscriber after you complete a snapshot. Unaware of this feature? Watch this episode of SQL School.
Phil reflects on the problem-solving power of SQLServerCentral at its best, and mentions some of the impressive contributions to the Summer SQL Stumpers competition
Rick Heiges has put together an interesting event coming up on Sep 2, 2009 called 24 Hours of PASS. As...
The data compression feature in SQL Server 2008 helps compress the data inside a database, and it can help reduce the size of the database. Apart from the space savings, data compression provides another benefit: Because compressed data is stored in fewer pages, queries need to read fewer pages from the disk, thereby improving the performance of I/O intensive workloads. However, extra CPU resources are required on the database server to compress and decompress the data, while data is exchanged with the application. Therefore, it is important to understand the workload characteristics when deciding which tables to compress.
In SQL Server 2000 and onwards there are INSTEAD OF triggers that can be used to carry out such tasks. Although these types of triggers can be used in a number of scenarios their primary function is to perform DML operations through such views. This tip shows how to use INSTEAD OF triggers to handle these DML operations on views.
With the proliferation of high availability & specialist online Backup companies, do we really have any excuses left to NOT have an offsite backup location, even if it is in the Cloud? Brad things not...
Longtime author David Poole has written an excellent article about using SQLDoc, from Red Gate Software. Learn how you can document your own databases in this sponsored article.
Every PostgreSQL migration eventually hits the same fork in the road. The database is...
By Steve Jones
I’m off on vacation today. Which is a little weird as I just got...
By Arun Sirpal
Every DBA has a box like this. Sitting untouched for months. Nobody’s proud of...
Comments posted to this topic are about the item Have you done a Mid...
Comments posted to this topic are about the item From SQL Server On-Premises to...
Comments posted to this topic are about the item Independence Day 2026
In the original Independence Day movie (1996), what type of computer did Jeff Goldblum use to connect to the alien mainframe? Take a guess, don't look it up or ask AI.
See possible answers