SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
<< Previous headlines | Later headlines >>
SQLServerCentral.com Headlines from 2013/03/08 to 2013/03/15

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: azure sql database
Rating: (not yet rated)  Rate this |   Briefcase | 2,641 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 | 32,343 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,917 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,551 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,911 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: Redgate | Category: survey
Rating: (not yet rated)  Rate this |   Briefcase | 3,354 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,798 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 (xe)
Rating:  Rate this |   Briefcase | 4,109 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 | 223 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 (data)
Rating:  Rate this |   Briefcase | 3,497 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 | 12,590 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: Redgate | Category: webinar
Rating:  Rate this |   Briefcase | 5,195 reads

SQL Saturday #204 - Detroit

Join of for a free day of SQL Server training and networking in Detroit on March 16th.  Read more...
By Press Release 2013/03/11 | Source: SQLServerCentral.com | Category: sql saturday
Rating: (not yet rated) |  Discuss |   Briefcase | 328 reads

Dynamically Download FTP Files Using SSDT

Dynamically initialise FTP connection using expressions and retrieve files stored in multiple FTP directories using SQL Server Data Tools  Read more...
By Sifiso W. Ndlovu 2013/03/11 | Source: SQLServerCentral.com | Category: ftp
Rating: |  Discuss |   Briefcase | 7,991 reads

Database Deployment: The Bits - Versioning

Although databases have no inherent way of recording their version numbers, SQL Server provides the means of doing so, and much more besides. This is a great advantage to anyone faced with the task of deploying databases without errors.  Read more...
By Additional Articles 2013/03/11 | Source: SimpleTalk | Category: deployment
Rating:  Rate this |   Briefcase | 2,546 reads


The popular UK conference heads to Nottingham from May 2-4, 2013. Both Grant Fritchey and Steve Jones will be speaking, along with lots of talented SQL Server professionals. Register today.  Read more...
By Press Release 2013/03/11 (first published: 2013/02/06) | Source: SQLServerCentral.com | Category: sqlbits
Rating:  Rate this |   Briefcase | 4,601 reads

Brent Ozar's Six Scary SQL Surprises

In lesson 3 of the Top 5 Hard-earned Lessons of a DBA series, Brent Ozar exposes six common but scary surprises that can lurk behind the façade of SSMS. Read it now, and learn hard lessons the easy way.  Read more...
By Additional Articles 2013/03/08 | Source: Redgate | Category: administration
Rating: (not yet rated)  Rate this |   Briefcase | 6,759 reads

Using the SQL Server MERGE Statement to Process Type 2 Slowly Changing Dimensions

The MERGE statement is powerful and multifunctional, yet it can be hard to master. SOmetimes the MERGE statement that just doesn't do what it's needed to do, like process a Type 2 slowly-changing dimension. Check out this tip to learn more.  Read more...
By Additional Articles 2013/03/08 | Source: MSSQLTips.com | Category: merge
Rating:  Rate this |   Briefcase | 3,771 reads

Deleting large number of rows from a table in a VLDB

For enterprise systems, purging data is a reality. Today, we will see some strategies that I recently implemented to make this process work efficiently.  Read more...
By Nakul Vachhrajani 2013/03/08 (first published: 2011/03/24) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 23,142 reads