SQL Server Integration Services - Delay Validation
Using delay validation the designer can control the response of default behaviour of package validation which happens at design time and also at run time.
2012-03-08
5,351 reads
Articles
Come to see the SQL Server 2012 Launch at DevConnections
On Mar 26-29 in Las Vegas, the DevConnections conference is hosting a launch of SQL Server 2012. Come to the conference and learn more at the SQLServerCentral track.
2012-03-08 (first published: 2012-01-18)
4,386 reads
How to use RunAs command for SSMS if option does not exist
In order to use your normal Windows login and your admin login to connect to SQL Server using SSMS you need to use the "Run as" feature. What do you do in the case of Windows 7 or Windows Vista where you can’t find the Run As Different User option?
2012-03-08
2,888 reads
Win an Amazon Kindle! Complete our Data Compression Survey
We'd like to find out what you think about SQL Server data compression. Complete this quick survey and you could win an Amazon Kindle. Complete the survey now.
2012-03-08
2,095 reads
Basics of XML and SQL Server, Part 1: Streaming XML
This article demonstrates how to generate an XML stream from SQL Server using the 'FOR XML PATH' statement, and how to explore that XML stream interactively using an XSL transformation.
2012-03-07
7,988 reads
Three Attack Vectors in SQL Server 2005
This article outlines three different tried and tested methods of obtaining access to databases in SQL Server 2005 where no database-level administrative access exists.
2012-03-07
7,437 reads
SQL Server 2012 - The Virtual Launch Event
Microsoft has scheduled a virtual launch event for SQL Server 2012 on Mar 7. Register now to learn about the next version of SQL Server.
2012-03-07 (first published: 2012-03-01)
4,718 reads
Large table cleanup with minimal locks
How do you delete millions of rows with minimal impact to the business? This article gives you a way to accomplish the removal of old data.
2012-03-06
15,504 reads
SQL Saturday #114 - Vancouver
A free day of SQL Server training in Vancouver, BC, Canada on Mar 17, 2012.
2012-03-06
1,373 reads
SQL Saturday #115 - Portugal
A free day of SQL Server training in Lisbon. Register and come if you can.
2012-03-06
1,289 reads
Blogs
Programmatic Tool Calling with the Claude SDK
Programmatic Tool Calling with the Claude SDK Every morning somebody on the team runs the...
A New Word: Mauerbauertraurigkeit
By Steve Jones
mauerbauertraurigkeit – n. inexplicable urge to push people away, even close friends whose company...
Methodology for dealing with bad data in production
By Brian Kelley
Pinal Dave wrote up his methodology for what to do when you discover bad...
Forums
Advanced T-SQL: Replacing Slow Cursors with Window Functions
Comments posted to this topic are about the item Advanced T-SQL: Replacing Slow Cursors...
Finding Bad Queries
Comments posted to this topic are about the item Finding Bad Queries
The Service Name
Comments posted to this topic are about the item The Service Name