From Zero to SSIS! Learning SQL Server Integration Services
Learn SSIS from MVP Andy Leonard in Waltham, MA on Oct 6-8, 2010. This is a paid event. More details inside.
2010-09-16 (first published: 2010-08-19)
10,199 reads
Articles
Inside the Optimizer: Constructing a Plan - Part 4
The final part in a series by Paul White exploring the internals of query optimization. Learn how
2010-09-16
5,616 reads
Conditional report rendering based on render formats for SSRS Reports
When using Report Manager, users can export reports to different formats like PDF, XLS and others. When reports are exported to other formats they also include all of the content from the report, but rendered to the format of the report output. There maybe scenarios where you would not want a particular part or component of report to appear in these other report formats. A practical example of this could be that you want to display images when the report is displayed in HTML, but not when the report is exported to a PDF format. In this tip we take a look at a new feature in Reporting Services that allows us to control these items without having to create multiple report versions.
2010-09-16
2,831 reads
SQL Saturday #52 - Colorado
A free one day training event in the Denver Tech Center on Sept 25, 2010. Come learn about SQL Server and how to further your career at this one day event.
2010-09-16 (first published: 2010-09-01)
1,549 reads
Ways to minimize sort operations
In this article Brian Ellul explorea how it's possible to eliminate the SORT operator (and its performance cost) on performing SELECTS statements.
2010-09-15
12,138 reads
Issuing Current Time Increments in StreamInsight (A Practical Example)
The issuing of a Current Time Increment, Cti, in StreamInsight is very definitely one of the most important concepts to learn if you want your Streams to be responsive. A full discussion of how to issue Ctis is beyond the scope of this article but a very good explanation in addition to Books Online can be found in these three articles by a member of the StreamInsight team at Microsoft, Ciprian Gerea.
2010-09-15
1,779 reads
SQL Saturday #49 - Orlando
A free, one day training event taking place on October 16, 2010 in Orlando, FL.
2010-09-15
1,426 reads
Inside the Optimizer: Constructing a Plan - Part 3
Join Paul White in part three of a four-part series exploring the internals of query optimization as he looks at the rules that are used to build the execution plan.
2010-09-14
6,508 reads
SQL Saturday #55 - San Diego
The first SQL Saturday in San Diego kicks off fall with a full day of free SQL Server information, lectures, and seminars from the experts on the West Coast.
2010-09-14 (first published: 2010-09-07)
1,663 reads
SQL Social - Kent, UK
Andrew Calvett talks Analysis Services for the September meeting of the Kent SQL Server user's group.
2010-09-14
1,427 reads
Blogs
PostgreSQL Support in the Data API Builder
By Steve Jones
Next week I’m at VS Live in San Diego (register and join me) and...
Ten Years of PowerShell
Ten years ago today, I filmed a Pluralsight Play by Play on open source...
T-SQL Tuesday #202: 100 Hours
By Steve Jones
It’s time for T-SQL Tuesday again and this is a great prompt to start...
Forums
Stored Procedures for Server-Level Object and Column Search
Comments posted to this topic are about the item Stored Procedures for Server-Level Object...
Databricks Genie Spaces for SQL Analysts: Natural Language Querying Without Leaving Your Data Platform
Comments posted to this topic are about the item Databricks Genie Spaces for SQL...
The Costs of Multiple Platforms
Comments posted to this topic are about the item The Costs of Multiple Platforms
Question of the Day
RegEx Functions II
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') AND BusinessEntityID IN (7,8)See possible answers