Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
<< Previous headlines | Later headlines >>
SQLServerCentral.com Headlines from 2013/03/12 to 2013/03/19

Accounting for Windows Azure

On Thursday March 21st 12PM noon Central, Steve Hughes will discuss Accounting for Windows Azure when looking at Data Architecture.   Read more...
By Press Release 2013/03/19 | Source: SQLServerCentral.com | Category: pass
Rating: (not yet rated)  Rate this |   Briefcase | 2,397 reads

Trigger an Email of an SSRS Report from an SSIS Package

This article demonstrates how to trigger an SSRS subscription to email a report from an Execute SQL Task using SQL Server Agent and the ReportServer.dbo.AddEvent stored procedure.  Read more...
By Stan Kulp 2013/03/19 | Source: SQLServerCentral.com | Category: integration services (ssis)
Rating: |  Discuss |   Briefcase | 10,178 reads

Full Text Searches on Documents in FileTables

SQL Server's FileTable technology is an intriguing way of accomodating file-based text data in a database, and allowing for complex searches. The best way of learning FileTable is to try it out and experiment. Feodor shows how to set it up, add some sample data and set up full-text search.  Read more...
By Additional Articles 2013/03/19 | Source: SimpleTalk | Category: full text search
Rating:  Rate this |   Briefcase | 2,247 reads

SQLServerCentral at SQL Intersection

Steve Jones and Grant Fritchey will be speaking at the SQL Intersection conference in April. Come join them in learning about SQL Server in the spring.  Read more...
By Press Release 2013/03/18 | Source: SQLServerCentral.com | Category: sql intersection
Rating: (not yet rated)  Rate this |   Briefcase | 1,399 reads

Stairway to PowerPivot and DAX - Level 4: The DAX BLANK() Function

Business Intelligence architect and author Bill Pearson exposes the DAX BLANK() function, and then provides some hands-on exposure to its use in managing empty values underlying our PowerPivot model designs.  Read more...
By Bill Pearson 2013/11/06 (first published: 2013/03/18) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 6,204 reads

Database Deployment Challenges

There are a number of challenges that make the deployment task more difficult. Alex reviews the common techniques for deploying new databases and upgrading existing ones, and their flaws, and argues the advantages of an automated, incremental, script-based approach to deployments.  Read more...
By Additional Articles 2013/03/18 | Source: SimpleTalk | Category: deployment
Rating:  Rate this |   Briefcase | 2,582 reads

Testing the StreamInsight Service for Windows Azure

Getting 'up to speed' with StreamInsight is easier if you take the time to run it and test it out. Roger Jennings expains how to be up and running in nine simple steps, once you've sorted out the prerequisites  Read more...
By Additional Articles 2013/03/15 | Source: SimpleTalk | Category: sql azure
Rating: (not yet rated)  Rate this |   Briefcase | 2,144 reads

Designing a Dashboard - Level 6 in the Stairway to Reporting Services

This article walks through a sample dashboard, highlighting sparklines, databars, and indicators.  Read more...
By Jessica M. Moss 2013/03/15 (first published: 2011/08/04) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 29,362 reads

Expand Your Skills at the PASS Business Analytics Conference

Join top business intelligence and analytics experts in Chicago April 10-12 for 60+ sessions on the best practices, prescriptive guidance, and strategic vision you need to get the most from your data. Use code BACSSC to save $250 today!  Read more...
By Press Release 2013/04/03 (first published: 2013/03/14) | Source: PASS | Category: bi
Rating: (not yet rated)  Rate this |   Briefcase | 6,374 reads

An Incremental Database Development and Deployment Framework

Often, an existing database application must evolve rapidly by incremental steps. Alex describes a tried and tested system to provide an automated approach to deploying both new and existing database systems, whilst dealing with common security and configuration issues.  Read more...
By Additional Articles 2013/03/14 | Source: SimpleTalk | Category: database development
Rating:  Rate this |   Briefcase | 4,194 reads

Search for a Value Throughout Your Database

Learn how to search for a value throughout all database tables.  Read more...
By Gaurav Goel 2013/03/14 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 6,822 reads

Help Guide the Future of SQL Compare

How changes are applied to databases differs from person to person and from organization to organization. Here at Red Gate we’re writing the next chapter for SQL Compare and we need your feedback to validate some of our ideas. To help us in this endeavour, and to enter a prize draw for one of five $50 Amazon vouchers, please complete the following survey.  Read more...
By Press Release 2013/03/13 (first published: 2013/03/06) | Source: Red-Gate | Category: survey
Rating: (not yet rated)  Rate this |   Briefcase | 3,134 reads

An Orders of Magnitude Problem (T-SQL Tuning)

When a query suddenly starts taking much longer, what do you do? This story from Jerry   Read more...
By Jerry_Manioci 2013/03/13 | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 6,756 reads

Getting Started with Extended Events in SQL Server 2012

Extended Events provide a way of unintrusively monitoring what's going on in a SQL Server instance. Unlike SQL Server Profiler and SQL Trace, it has little performance impact. Now, in SQL Server 2012 SSMS, it is relatively easy to use, as Robert Sheldon shows.  Read more...
By Additional Articles 2013/03/13 | Source: SimpleTalk | Category: extended events
Rating:  Rate this |   Briefcase | 3,150 reads

SQL Saturday #188 - Lisbon

Join us for SQL Saturday #188, a free SQL Server training event in Lisbon, Portugal. This event also has pre-conference paid workshops.  Read more...
By Press Release 2013/03/12 | Source: SQLServerCentral.com | Category: sql saturday
Rating: |  Discuss |   Briefcase | 218 reads

SQL Server Statistics Questions We Were Too Shy to Ask

If you need to optimise SQL Server performance, it pays to understand SQL Server Statistics. Grant Fritchey answers some frequently-asked questions about SQL Server Statistics: the ones we somehow feel silly asking in public, and think twice about doing so.  Read more...
By Additional Articles 2013/03/12 | Source: SimpleTalk | Category: statistics
Rating:  Rate this |   Briefcase | 3,114 reads

Data Mining Introduction Part 3: The Cluster Algorithm

This is the part 3 of the Data Mining Series from Daniel Calbimonte. This article examines the cluster algorithm.  Read more...
By Daniel Calbimonte 2013/03/12 | Source: SQLServerCentral.com | Category: data mining
Rating: |  Discuss |   Briefcase | 9,105 reads

SQL Server Central Webinar Series #22 – What counts for a DBA (Wednesday, March 13 2013 5:00pm - 6:00pm GMT)

In this session, Louis Davidson, Microsoft MVP, will discuss how being observant of the environment you work in can help you make sure that you are aware of the health of your database systems, as well as your career.  Read more...
By Press Release 2013/03/12 (first published: 2013/02/22) | Source: Red-Gate | Category: webinar
Rating:  Rate this |   Briefcase | 5,057 reads