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/08/06 to 2013/08/13

SQL in the City Seminar San Diego 2013 – DBA Team Seminar

Join Red Gate for a free seminar on September 20 (the day before SQL Saturday San Diego). SQL Server MVPs, Steve Jones and Grant Fritchey will present informative sessions featuring best practices for SQL Server database administration, in addition to showing Red Gate tools in action.   Read more...
By Press Release 2013/08/13 | Source: Red-Gate | Category: sql in the city
Rating: (not yet rated)  Rate this |   Briefcase | 1,391 reads

How to Compile, Deploy and Consume a SQL Server CLR Assembly

Specialized tasks like cryptography require external libraries that are not available in SQL Server. Methods for such tasks can be compiled in a .NET language and deployed to SQL Server as a CLR assembly where the assembly's methods can be referenced by SQL Server stored procedures and functions.  Read more...
By Stan Kulp 2013/08/13 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 5,003 reads

The SQL of Gaps and Islands in Sequences

Some SQL problems are intriguing because, just when good methods emerge and are accepted, other alternative solutions are discovered. The fun of exploring problems such as 'Gaps and Islands' is all the greater when we have a thorough test-harness to try out the alternative solutions.  Read more...
By Additional Articles 2013/08/13 | Source: SimpleTalk | Category: gaps
Rating:  Rate this |   Briefcase | 2,314 reads

How efficient is your covered index?

Observing an index seek utilizing a composite index within SQL execution plan might be more than meets the eye – you should look again.  Read more...
By Simon Liew 2013/08/12 | Source: SQLServerCentral.com | Category: covering index
Rating: |  Discuss |   Briefcase | 8,204 reads

The Basics of Good Negotiations Webinar

This PASS VC Webinar will take place August 14, 1PM EDT. Creatively resolving differences and negotiating mutually beneficial agreements is crucial in all walks of life. It’s especially important and challenging in the IT industry where soft skills are not necessarily prevalent. ??In this session, we’ll introduce the basic concepts and precepts that will aid you in negotiating better agreements with your neighbors, peers and co-workers, and even your boss.  Read more...
By Press Release 2013/08/12 | Source: SQLServerCentral.com | Category: pass virtual chapters
Rating: (not yet rated)  Rate this |   Briefcase | 2,510 reads

Understanding the importance of key length with the SQL Server asymmetric encryption algorithms

K. Brian Kelly is trying to use SQL Server's built-in encryption and sees there are three different options available for an asymmetric key, corresponding to key length. What's the impact of the key length?  Read more...
By Additional Articles 2013/08/12 | Source: MSSQLTips.com | Category: encryption
Rating: (not yet rated)  Rate this |   Briefcase | 2,692 reads

Survey: Help Improve SQL Doc

Do you use SQL Doc? We're building the new version, and we'd like your help. Complete the survey for a chance to win a $50 Amazon voucher.  Read more...
By Press Release 2013/08/09 | Source: Red-Gate | Category: survey
Rating:  Rate this |   Briefcase | 2,553 reads

SSIS 2012 - Using PowerShell to Remotely Execute File System Packages

A Powershell script that allows you to execute SSIS packages using the traditional Package Deployment Model can be very useful. But what do you do when the execution isn't triggered by the same computer where the target package resides? Marcin Policht offers a solution.  Read more...
Rating:  Rate this |   Briefcase | 2,137 reads

Automated Trigger To Require a WHERE Clause

Learn how you can build triggers that prevent an update or delete statement from being run without a WHERE clause in this article.  Read more...
By Rahul Kumar Ghosh 2013/08/09 (first published: 2011/01/25) | Source: SQLServerCentral.com | Category: delete
Rating: |  Discuss |   Briefcase | 16,484 reads

10 Myths about Backups in SQL Server

Let's dispel a few myths about backups in SQL Server.  Read more...
By Shashank Srivastava 2013/08/08 | Source: SQLServerCentral.com | Category: backup / recovery
Rating: |  Discuss |   Briefcase | 5,394 reads

SQL Saturday #233 Oklahoma City

SQL Saturday comes to Oklahoma City on August 24th for a free day of SQL Server training and networking. This event also features a paid-for pre conference session on Friday with Bill Pearson on Practical Self-Service BI with PowerPivot for Excel.  Read more...
By Press Release 2013/08/08 | Source: SQLServerCentral.com | Category: sql saturday
Rating: (not yet rated)  Rate this |   Briefcase | 2,048 reads

SQLServerCentral.com Users Survey 2013

We want to make sure we're covering the things that are relevant to you, so we're asking for some feedback on what you use on SSC, where we need to improve, and what you'd like to see. It should only take a few minutes, and three randomly-selected people will win a $100 Amazon gift card for their efforts.   Read more...
By Additional Articles 2013/08/08 (first published: 2013/07/25) | Source: SQLServerCentral.com | Category: sqlservercentral
Rating: (not yet rated)  Rate this |   Briefcase | 4,231 reads

Introduction to SQL Server Check Constraints

Check Constraints play a very important role in SQL Server as it allows data validation rules to be imposed at the SQL Server instance level itself instead of writing rules for each application.   Read more...
By Additional Articles 2013/08/08 | Source: SQL Server Performance | Category: check constraint
Rating:  Rate this |   Briefcase | 4,811 reads

Biml Workshop presented by Varigence and Linchpin People

Business Intelligence Markup Language (Biml) automates your BI patterns and eliminates the manual repetition that consumes most of your time. On October 15th come see why BI professionals around the world think Biml is the future of data integration and BI.   Read more...
By Press Release 2013/08/07 (first published: 2013/07/17) | Category: events
Rating:  Rate this |   Briefcase | 5,926 reads

Building an Incremental Load Package – Level 3

The Stairway to BIML continues, with a lesson on how you might build a more complex package: an incremental load package.  Read more...
By Andy Leonard 2013/08/07 | Source: SQLServerCentral.com | Category: biml
Rating: |  Discuss |   Briefcase | 8,891 reads

Concatenation of Different SQL Server Data Types

TSQL provides 2 ways to concatenate data, the + sign and the new CONCAT() function. This tip will cover the differences in the two, so you can achieve the expected behavior in your code.   Read more...
By Additional Articles 2013/08/07 | Source: MSSQLTips.com | Category: concat (t-sql)
Rating:  Rate this |   Briefcase | 3,254 reads

Free eBook: Troubleshooting SQL Server: A Guide for the Accidental DBA

Three SQL Server MVPs (Jonathan Kehayias, Ted Krueger and Gail Shaw) provide fascinating insight into the most common SQL Server problems, why they occur, and how they can be diagnosed using tools such as Performance Monitor, Dynamic Management Views and server-side tracing. The focus is on practical solutions for removing root causes of these problems, rather than "papering over the cracks".  Read more...
By Press Release 2014/06/25 (first published: 2013/08/07) | Source: Red-Gate | Category: troubleshooting
Rating:  Rate this |   Briefcase | 23,248 reads

Data Mining Introduction Part 6: Time series algorithm

This article is part of the Data Mining introduction series. This article is about time series.   Read more...
By Daniel Calbimonte 2013/08/06 | Source: SQLServerCentral.com | Category: data
Rating: |  Discuss |   Briefcase | 5,779 reads

Changing SQLServerCentral - Newsletter Layout

Our series discussing the current and potential changes to SQLServerCentral.   Read more...
By Steve Jones 2013/08/06 | Source: SQLServerCentral.com | Category: sqlservercentral
Rating: |  Discuss |   Briefcase | 777 reads

SQL Saturday #240 Curacao

QL Saturday is coming to Curacao, Netherlands Antilles for a free day of SQL Server training and Networking on August 17. There will also be a pre-conference session on Practical Self-Service BI with PowerPivot for Excel.   Read more...
By Press Release 2013/08/06 | Source: SQLServerCentral.com | Category: events
Rating: (not yet rated)  Rate this |   Briefcase | 2,070 reads

An Introduction to Windows Azure BLOB Storage

Azure BLOB storage is persistent Cloud data storage that serves a variety of purposes. Mike Wood shows the basics of how to use it, from start through to snapshots and metadata; both from .NET, and by using the free tool, Cerebrata Azure Explorer.   Read more...
By Additional Articles 2013/08/06 | Source: SimpleTalk | Category: azure
Rating: (not yet rated)  Rate this |   Briefcase | 1,836 reads