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/25 to 2013/07/02

A New Look

We've changed the newsletter and would love to know what you think.  Read more...
By Site Owners 2013/07/02 | Source: SQLServerCentral.com | Category: sqlservercentral
Rating: |  Discuss |   Briefcase | 1,733 reads

Change the Maintenance Plan Owner

This article shows how you can change the maintenance plan owner in SQL SERVER  Read more...
By Shashank Srivastava 2013/07/02 | Source: SQLServerCentral.com | Category: maintenance plans
Rating: |  Discuss |   Briefcase | 1,004 reads

SQL Saturday #214 Louisville KY

Join us for a free day of SQL Server training and networking in Louisville Kentucky on July 13. This SQL Saturday event also has 2 paid pre-con all day sessions on July 12 presented by Dave Fackler and Bill Pearson.  Read more...
By Press Release 2013/07/02 | Source: SQLServerCentral.com | Category: events
Rating: (not yet rated)  Rate this |   Briefcase | 2,130 reads

Performance Tuning in the Age of Big Data

Database Administrators must now deal with large volumes of data and new forms of high-speed data analysis. If your responsibility includes performance tuning, here are the areas to focus on that will become more and more important in the age of Big Data.  Read more...
By Additional Articles 2013/07/02 | Source: Database Journal | Category: big data
Rating:  Rate this |   Briefcase | 2,775 reads

SQL Server CREATE TABLE syntax diagrams

Many of us have seen, on MSDN, the heading 'Syntax', followed by a rash of nested brackets and keywords, enough to put off the most resolute of code-cutters. However, there is a goldmine of information there, and Phil had an ambition to get at it, and share the gold. The result is this article, full of railroad diagrams.  Read more...
By Additional Articles 2013/07/01 | Source: SimpleTalk | Category: syntax
Rating:  Rate this |   Briefcase | 3,890 reads

Log Shipping Lite with PowerShell

A PowerShell driver that performs incremental restores on a standby server, a lite weight log shipping solution.  Read more...
By Paul Brewer 2013/07/01 | Source: SQLServerCentral.com | Category: powershell
Rating: |  Discuss |   Briefcase | 2,979 reads

xp_cmdshell for Non-System Admin Individuals

There may be times when you want to allow non-System Admin logins to be able to execute the xp_cmdshell extended stored procedure. In this articleGreg Larson will show you how to setup xp_cmdshell so non-System Admins can use this extended stored procedure.  Read more...
By Additional Articles 2013/07/01 | Source: Database Journal | Category: cmdshell
Rating:  Rate this |   Briefcase | 2,808 reads

Automating SQL Server Database Deployments: Scripting Details

To wrap up the series on Database Deployment Challenges, Alexander takes a dive into the details of how he scripted a solution and comes up with several practical tips for getting the most out of any automated database deployment framework.  Read more...
By Additional Articles 2013/06/28 | Source: SimpleTalk | Category: database deployment
Rating:  Rate this |   Briefcase | 4,171 reads

Display More Than 8000 Characters (SQL Spackle)

SQL Server MVP Jeff Moden shows us a quick and dirty bit of SQL Spackle to display the content of VARCHAR(MAX) and NVARCHAR(MAX).  Read more...
By Jeff Moden 2013/06/28 (first published: 2011/01/27) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 18,752 reads

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,231 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,962 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,030 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,417 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,310 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,555 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,711 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,672 reads

Temporary Stored Procedures

Temporary Stored Procedures - little known sql server feature  Read more...
Rating: |  Discuss |   Briefcase | 17,417 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,765 reads