(David Dye) My last post looked at a simplistic example of using an SSIS variable in a row count transformation and then using the variable in a precedence constraint expression to direct the flow of the package. This post will focus on the unique object variable data type. The object data type i

(Edward Elliott) To access SQL Server from the client, you use TDS protocol over TCP. This is fine over reliable LANs but over the internet these connections are relatively slow and fragile, TDS is still used to connect to databases in the cloud, but you need to use a combination of the new feature

(Pinal Dave) Earlier I have written three articles on the concept of Delayed Durability. You can read them over here.

(Marcin Policht) In our recent articles published on this forum, we have been exploring the ability to administer Azure SQL Database by leveraging REST APIs invoked from PowerShell-based scripts.

(Ray Barley) I use the SQL Server Database Project for developing, maintaining, and publishing/deploying my databases. I need to implement Change Tracking in one of my databases. How can I do that in the SQL Server Database Project?

(David Dye) Variables have been available in SSIS since first introduced in 2005. So what exactly are they for and what can you do with variables? Glad you asked!! Variables can be used for a number of different purposes:

(Michael K. Campbell) AlwaysOn is a marketing term used to describe two different high-availability (HA) and disaster recovery (DR) solutions from Microsoft: AlwaysOn Failover Cluster Instances (FCIs) or raditional clusters and AlwaysOn Availability Groups (AGs) which are a lot like Database Mirrori

(Greg Larsen) If you are an application programmer then you will more than likely need to write TSQL code to update your SQL Server database tables. In order to update a row in a SQL Server table you will use the UDPATE statement. In this article I will show you a number of different ways to use t

(Jeff Levinson) I was recently asked if it was possible to do some smoke testing on new deployments of SQL Server Analysis Services cubes. My initial answer was “yes, of course” – then someone asked me to actually do it. It turns out to be as easy as I thought it was but I wasn’t able to find any pa

(Andy Novick) Testing T-SQL application code that has time dependencies can be a very difficult and error prone task. By borrowing a technique from Test-Driven-Development and using a mock-time instead of the real time it becomes easy to test how a stored procedure or function would behave at some o