Troubleshooting problems with SQL Server 2008 R2 Integration Services If you have problems with SQL Server 2008 R2 Integration Services (SSIS), review this troubleshooting checklist to find potential solutions. 1. Install the latest SQL Server 2008 R2 service pack. Because many SQL Server 2008 R2 Integration Services bugs were fixed in SQL Server service packs, you should install the latest...
Standard Members
Installing SQL Server Express 2012 and managing the LocalDB
Introduction Sql Server Express 2012 the latest free version of SQL Server from Microsoft has five options of download from a small foot print version (SQL Express 2012 LocalDB or simply LocalDB) to the full version with all bells and whistles. The product comes in both (32 bit) and (x64bit) versions in several European and Asian Languages. LocalDB, an embeddable...
Tips for using SQL Server 2008 R2 database settings
Tips for using SQL Server 2008 R2 database settings To change the database settings, you can use the sp_dboption system stored procedure or you can use the graphical user interface (GUI). To change the database settings using GUI, you can do the following: – In Object Explorer, connect to an instance of the SQL Server Database Engine, and then expand...
7 Tricks to Attending a Conference on Someone Else’s Dime
7 Tricks to Attending a Conference on Someone Else’s Dime Professional Development Series by Laura Lee Rose Hello, this is Laura Lee Rose – Corporate Exit Strategist for the Blooming Entrepreneur – and I am a business and life coach that specializes in time management, project management and work-life balance strategies. As a success and business coach, I encourage continuous...
Troubleshooting problems with SQL Server 2008 R2 Merge Replication
Troubleshooting problems with SQL Server 2008 R2 Merge Replication If you have problems with SQL Server 2008 R2 merge replication, review this troubleshooting checklist to find potential solutions. 1. Check that you use the latest SQL Server 2008 R2 service pack. Because many SQL Server 2008 R2 merge replication bugs were fixed in SQL Server service packs, you should install...
zData Perspectives – A Short History of DB2 for z/OS
zData Perspectives A Short History of DB2 for z/OS by Craig S. Mullins Let’s go back in time… almost three decades ago… back to the wild and woolly 1980s! And watch our favorite DBMS, DB2, grow up over time. Version 1 Release 1 was announced on June 7, 1983. And it became generally available on Tuesday, April 2, 1985. I...
How Do You Transition from a Consulting Job Back to Management?
How Do You Transition from a Consulting Job Back to Management? Hello, this is Laura Lee Rose – Corporate Exit Strategist for the Blooming Entrepreneur – and I am a business and life coach that specializes in time management, project management and work-life balance strategies. I recently received a question regarding “How do you transition from a consulting job back...
New Features of SQL Server 2012
New Features of SQL Server Denali By Kautuk Pandey We have just been greeted by another new version of SQL Server in the form of SQL Server 2012/Denali. This release comes with a number of new features. In this article I talk about a few of them. AlwaysON is definitely going to be one of the most exciting new things...
New Features in Visual Studio 11
Visual Studio 2011 is the next generation of development IDE from Microsoft (commonly known as vNext). Visual Studio 2011 is also referred to as Visual Studio 11. It provides an integrated development environment that simplifies the tasks of creating, managing, debugging, and deploying application software on Windows environments. That’s right here we are with the next version of Visual Studio...
Demystifying SQL Server Differential Database Backups
Demystifying SQL Server Differential Database Backups By Wes Brown, Founding member of the Idera ACE Program and DBA Consultant at Dell SQL Server has three backup types. Two you have heard of and used. One, while useful, isn’t very well understood. Let’s start with a technical recap of the three backup types for SQL Server. 1. Full Database Backup When...