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/06/20 to 2013/06/27

Free eBook - Control Your Transaction Log so it Doesn't Control You

Download your free copy of SQL Server Transaction Log Management and see why understanding how log files work can make all the difference in a crisis.  Read more...
By Press Release 2013/06/27 | Source: Red-Gate | Category: ebook
Rating: (not yet rated)  Rate this |   Briefcase | 5,241 reads

Export to XML Using SSIS

Exporting data to XML format using SSIS initially seems like it should be straight forward – just dump it in a flat file and give it a name xml type, however SSIS has no XML destination just an XML source. I had no luck dumping the XML in flat file. My solution was to use a script task which worked well.  Read more...
By Additional Articles 2013/06/27 | Source: SQL Server Performance | Category: xml
Rating: (not yet rated)  Rate this |   Briefcase | 2,991 reads

SQLServerCentral Runs sp_Blitz - Informational Items

The sixth article in our series that looks at the results of the sp_Blitz™ script run against the SQLServerCentral servers.  Read more...
By Steve Jones 2013/06/27 | Source: SQLServerCentral.com | Category: sqlservercentral
Rating: |  Discuss |   Briefcase | 4,031 reads

Big Data for SQL folks: The Technologies (Part I)

Will RDBMs be obsolete? Should Data Professionals care about Big Data technologies? What is NoSQL? What is Hadoop? Big Data-the whole story.  Read more...
By Frank A. Banin 2013/06/26 | Source: SQLServerCentral.com | Category: big data
Rating: |  Discuss |   Briefcase | 13,446 reads

SQL Saturday #236 St Louis, MO

SQL Saturday is returning to St Louis for a full day of free SQL Server training and networking. This year's event will be on August 3, 2013 at the Saint Louis University's Center for Workforce & Organizational Development. We hope to see you there.   Read more...
By Press Release 2013/07/30 (first published: 2013/07/24) | Source: SQLServerCentral.com | Category: sql saturday
Rating: (not yet rated)  Rate this |   Briefcase | 4,311 reads

SQL Server Integration Services package to delete files from a Network or Local path based on date

We have a requirement to delete a group of files that are older than the specified number of days from the company file share. Due to the complex folder hierarchy and delicate nature of the data stored in these files, this task has to be originated from SQL Server. However, due to company security policy, and based on SQL Server security best practices, we blocked access to OLE Automation stored procedures, CLR features, and xp_cmdshell. Is there any way to accomplish this task without using these features?   Read more...
By 2013/06/26 | Source: MSSQLTips.com
Rating:  Rate this |   Briefcase | 3,561 reads

New SQL Monitor Custom Metric: Database Autogrowth

This metric for Red Gate SQL Monitor measures the number of database autogrowth events (data file or log file) in the last hour. Too many autogrowth events causes disk fragmentation which requires a change in the autogrowth settings of a database.  Read more...
By Press Release 2013/06/25 | Source: Red-Gate | Category: sql monitor
Rating: (not yet rated)  Rate this |   Briefcase | 3,728 reads

SQL Server Luxembourg User Group

Come join the SQL Server Luxembourg UG for free training and networking on June 27th at 5:30pm. Soren Nielsen will take a Deep Dive into SQL Server 2012’s “Always On” High Availability technology. This will be followed by Vern Rabe of the SQL User Group in Portland, Oregon, presenting “Data Types - Think You Know It All? Think Again”.  Read more...
By Press Release 2013/06/25 | Source: SQLServerCentral.com | Category: events
Rating:  Rate this |   Briefcase | 1,674 reads

Temporary Stored Procedures

Temporary Stored Procedures - little known sql server feature  Read more...
Rating: |  Discuss |   Briefcase | 17,438 reads

Painless management of a logging table in SQL Server

Tables that log a record of what happens in an application can get very large, easpecially if they're growing by half a billion rows a day. You'll very soon need to devise a scheduled routine to remove old records, but the DELETE statement just isn't a realistic option with that volume of data. Hugo Kornelis explains a pain-free technique for SQL Server.  Read more...
By Additional Articles 2013/06/25 | Source: SimpleTalk | Category: logging
Rating:  Rate this |   Briefcase | 4,769 reads

The Switch Workshop, by Red Gate and Re-Wired Group

Customers don’t just buy a product — they switch from something else. And customers don’t just leave a product — they switch to something else. It’s in these switching moments that the deepest customer insights can be found. On the 25th of July, a select group of 32 people will attend a unique, hands-on, full-day workshop at Red Gate to learn about “The Switch”.  Read more...
By Additional Articles 2013/06/24 | Source: SQLServerCentral.com | Category: events
Rating: (not yet rated)  Rate this |   Briefcase | 1,781 reads

Change Data Capture - SQL Server 2008

Change Data Capture (CDC) records DML operations performed on SQL tables and makes records available with information regarding what changed and when the change happened in a simple way.  Read more...
By Nitesh Dedhia 2013/06/24 | Source: SQLServerCentral.com | Category: sql server 2008
Rating: |  Discuss |   Briefcase | 6,107 reads

SQL Server Reporting Services ReportItems Collection

What is SQL Server Reporting Services 2012 (SSRS) ReportItems collection and how do I use it? Are there any restrictions on its use? Check out this tip to learn more.  Read more...
By Additional Articles 2013/06/24 | Source: MSSQLTips.com | Category: reporting services (ssrs)
Rating: (not yet rated)  Rate this |   Briefcase | 5,002 reads

Maximizing Throughput with TVPs

TVPs offer several performance optimization possibilities that other bulk operations do not allow, and these operations may allow for TVP performance to exceed other bulk operations by an order of magnitude, especially for a pattern where subsets of the data are frequently updated.  Read more...
By Additional Articles 2013/06/21 | Source: SQLCAT | Category: tvp
Rating:  Rate this |   Briefcase | 4,364 reads

SQL Saturday #226 - South Florida

SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. This event will be held Jun 29 2013 in Davie, FL. Admittance to this event is free, all costs are covered by donations and sponsorships. Please register soon as seating is limited, and let friends and colleages know about the event.  Read more...
By Press Release 2013/06/21 | Source: SQLServerCentral.com | Category: sql saturday
Rating: (not yet rated)  Rate this |   Briefcase | 1,737 reads

Understanding T-SQL Expression Short-Circuiting

Understanding the basics of how T-SQL logic works in branching is important to ensure you code works as expected. This article will help you learn how this impacts control of flow language.   Read more...
By Gianluca Sartori 2013/06/21 (first published: 2010/12/30) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 21,382 reads

Avoiding Parameter Sniffing in SQL Server

Parameter sniffing is when SQL Server compiles a stored procedure’s execution plan with the first parameter that has been used and then uses this plan for subsequent executions regardless of the parameters.   Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 5,013 reads

Email Formatted HTML Table with T-SQL

Create a professional looking HTML table from T-SQL, not SSRS.  Read more...
By Steve Moore 2013/06/20 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 12,144 reads