The SSIS Script Task allows you to add functionality to your SSIS package that does not already exist with the other predefined tasks. In this article, Daniel Calbimonte looks at how to get started using the SSIS Script Task with a few examples.
2016-03-30
4,402 reads
Microsoft cloud platform allows you to provide resiliency for your on-premises SQL Server deployments. Marcin Policht describes this functionality, available as part of the Azure Site Recovery solution.
2016-03-29
4,191 reads
Redgate’s Arneh Eskandari and Microsoft SQL Server MVP, Steve Jones, will show you how Redgate’s DLM (Database Lifecycle Management) solution works to improve your database development and deployment processes. Today 12noon EDT
2016-03-29
5,329 reads
To be able to make full use of the system catalog to find out more about a database, you need to be familiar with the metadata functions. They save a great deal of time and typing when querying the metadata. Once you get the hang of these functions, the system catalog suddenly seems simple to use, as Robert Sheldon demonstrates in this article.
2016-03-28
6,652 reads
In this article, I’ll attempt to “convince” you that every SQL Server you put into production should be a SQL Server Failover Cluster Instance (FCI).
2016-03-25 (first published: 2014-04-15)
14,525 reads
When your SQL Server database is set to have its statistics automatically updated, you will probably conclude that, whenever the distribution statistics are out-of-date, they will be updated before the next query is executed against that index or table. Curiously, this isn't always the case. What actually happens is that the statistics only gets updated if needed by the query optimiser to determine an effective query plan.
2016-03-25
4,726 reads
This article shows you how to resolve SQL Server maintenance plan execution failure error
2016-03-24
16,728 reads
Oracle offers a number of security-related settings, but one could definitely create more harm than good. David Fitzjarrell looks at which parameter that is, and why.
2016-03-24
5,227 reads
2016-03-23
186 reads
Manvendra Singh gives a step-by-step guide to installing SQL Server 2014.
2016-03-23
4,097 reads
By James Serra
Microsoft shared a broad set of Fabric, Power BI, and SQL updates at FabCon...
By Steve Jones
No, I’m not quitting or retiring. Just going on vacation, but I leave tonight...
Comments posted to this topic are about the item Let's Talk Certifications, which is...
Title pretty much says it. I want to join to a table that has...
Comments posted to this topic are about the item Building a SQL Server Fleet...
I have this data in a table in a SQL Server 2025 database:
EmailAddressID EmailAddress 7 dylan0@ADVENTURE-WORKS.COM 8 Diane1@ADVENTURE-WORKS.COMIf I run this query, which row(s) are returned?
SELECT top 10 * FROM person.EmailAddress WHERE REGEXP_LIKE(EmailAddress, '^D', 'i') AND BusinessEntityID IN (7,8)See possible answers