(Kenneth Fisher) Every now and again you realize that the primary key for a table does not uniquely describe a row. Not really a big deal right? Just add an additional column in order to make it unique and move on.
Other News
SQL SERVER – FIX: ERROR : Msg 3023, Level 16, State 2 – Backup, file manipulation operations (such as ALTER DATABASE ADD FILE) and encryption changes on a database must be serialized
(Pinal Dave) Errors are the best way to learn how SQL Server works and as DBA’s we are bound to see many of them from time to time. One of the primary functions of a DBA would include creating backups and most importantly trying to automate the same using jobs and maintenance plans.
Building a Real-time Mobile Solution with IBM MessageSight and MQTT
(Rahul Gupta) IBM MessageSight is an appliance that is designed for the Internet of Things (IoT) and mobile environments. It provides a secure, DMZ-ready channel for lightweight, rapid, bidirectional messaging. MessageSight offers mobile application support, handles massive scaling of concurrent dev
Type compatibility and Parameter compatibility of delegates in C#
(Krishna Vamshi Goud) C# is an Object-oriented programming language. C# comes with simplicity, expressiveness and great performance to meet the programmer productivity.
Tuning Elapsed Times: More Resource Balancing and Summary
(Lockwood Lyon) The DBA can take advantage of the availability of CPU cycles by two database design concepts called partitioning and parallelism.
WPF Data Display Controls – DataGrid – Row Details
(Richard Carr) The one hundred and sixteenth part of the Windows Presentation Foundation Fundamentals tutorial is the last one that describes features of the DataGrid control. This article looks at the row details feature.
Using Multiple Predicates In The Same Part Of An XPath Query In ColdFusion
(Ben Nadel) The other day, Will Belden asked me a question about XPath expressions in ColdFusion. Specifically, how to select an XML node based on the existence of multiple child nodes.
Visual Studio 2015 Preview – Enhanced Debugging
(Pravinkumar Dabade) The Debugging enhancements in Visual Studio 2015 Preview is worth checking out. This article provides an overview of the same.
Are Names Important Anymore
Today I’m circling back around to an old conversation about naming conventions. I’m going to focus on SQL objects, but the concept still applies to any other application that names objects or variables. Over that last few months I’ve come across some interesting naming conventions for SQL Objects. Some are old school and others are new to me. For example, […]
Using the SSIS Merge Join to Synchronize Tables – Part 1
November 2014 Using the SSIS Merge Join to Synchronize Tables – Part 1 By Rocco Mastrangelo This article is Part 1 of a two-part series which describes how to keep two database tables synchronized using the Merge Join transform within Microsoft SQL Server Integration Services (SSIS). This solution is particularly useful for any ETL process that requires refreshing a target...
This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Register
Already a member? Log in here