Get the lowdown on SP-1's added features, including fully supported database mirroring, bug fixes, and add-ons for SQL Express. What's more, SP1 not only contains bug fixes, but also delivers ...

Last time, we showed how to take advantage of a built-in stored to run a command against multiple tables. This time, we look at another for working against a bunch of databases. In my last post, I ...

All,<BR><BR>First, apologies for the ugliness of the below.. I'm no expert!<BR><BR>To summarize, I'm trying to build a query I can run that I can run from the SQL Agent to email me daily reports..

A monthly overview of things you need to know as an architect or aspiring architect. Unlock the full InfoQ experience by logging in! Stay updated with your favorite authors and topics, engage with ...

However, while I would ordinarily print it for you here, I’ve got another special surprise. I’ve got a pretty decent fix list for SSIS that’s already included in the SP. I don’t think you’ll find this ...

SQL Server 2014 Service Pack 3 (SP3) was announced on Wednesday, about two years after the release of SP2. SP3 is a cumulative update, which means that it'll upgrade "all editions and service levels ...

SQL Server 2008 Release 2 Service Pack 3, the last update for the aging SQL Server version, has been released by Microsoft. According to the SQL Server Releases blog, its "primarily a roll up of ...

Microsoft republished Service Pack 1 for SQL Server 2014 on Thursday. The service pack originally got released last month, but Microsoft pulled it on that same month because of an installation problem ...

Microsoft makes good on commitment to continue improving older solutions, but the support will eventually end for this version as a newer, cloudified version 2014 takes over. In what is a commitment ...