Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
<< Previous headlines | Later headlines >> Headlines from 2013/03/06 to 2013/03/13

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,318 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: | Category: performance tuning
Rating: |  Discuss |   Briefcase | 6,797 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,807 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: | 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,396 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: | Category: data mining
Rating: |  Discuss |   Briefcase | 12,495 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,164 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: | Category: sql saturday
Rating: (not yet rated) |  Discuss |   Briefcase | 326 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: | Category: ftp
Rating: |  Discuss |   Briefcase | 7,973 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,461 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: | Category: sqlbits
Rating:  Rate this |   Briefcase | 4,416 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,742 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: | Category: merge
Rating:  Rate this |   Briefcase | 3,566 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: | Category: t-sql
Rating: |  Discuss |   Briefcase | 23,127 reads

Securing SQL Server: Vulnerabilities You Might Not Have Considered

A short look at the vulnerabilities your data may be susceptible to outside of the database tables.   Read more...
By Ashvin Kamaraju 2013/03/07 | Source: | Category: encryption
Rating: |  Discuss |   Briefcase | 5,821 reads

Data Insecurity: A Perspective on Data Encryption

The focus of this paper is on the protection of PII data stored within a database using encryption technologies.  Read more...
By Ron Johnson 2013/03/07 | Source: | Category: encryption
Rating: |  Discuss |   Briefcase | 1,616 reads

A SQL-Based Universal Currency Formatter

SQL Server isn't usually the best place to format dates or currency as strings. It can be a complex task to conform correctly with national and cultural conventions. Just occasionally, though, you need to do it. This is easy in SQL Server 2012, but if you aren't using that, what do you do?  Read more...
By Additional Articles 2013/03/07 | Source: SimpleTalk | Category: currency
Rating:  Rate this |   Briefcase | 2,173 reads

Hidden Tricks To SQL Server Table Cleanup

How to delete millions of rows with virtually no contention.  Read more...
By Edward Polley 2015/09/04 (first published: 2013/03/06) | Source: | Category: delete
Rating: |  Discuss |   Briefcase | 22,971 reads

Using Temp Tables in SSIS

emporary tables are created in the Temporary tables are created in the TempDB database, which persists for a particular session. The objective is to maintain that session, until the temp table information is used and dump the data into a physical table.   Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 3,820 reads

SQL Saturday #194 - Exeter

A day of SQL Server training in the UK on Mar 9, 2013. Sign up if you can come.  Read more...
By Press Release 2013/03/06 | Source: | Category: sql saturday
Rating: (not yet rated)  Rate this |   Briefcase | 1,738 reads