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

Steve Jones and Grant Fritchey at SQL Intersection

SQL Server Central’s Steve Jones and Red Gate’s Grant Fritchey will be among a stellar line-up of speakers at SQL Intersection conference in Las Vegas on the 8th to the 11th of April.   Read more...
By Press Release 2013/03/27 | Source: SQLServerCentral.com | Category: sql intersection
Rating: (not yet rated) |  Discuss |   Briefcase | 122 reads

Forum Etiquette: How to post data/code on a forum to get the best help

Get correct answers to your SQL forum questions faster by making it easier to load your sample data and read your code.  Read more...
By Jeff Moden 2013/12/10 (first published: 2007/11/27) | Source: SQLServerCentral.com | Category: best practices
Rating: |  Discuss |   Briefcase | 114,448 reads

HASHBYTES: Is CHECKSUM really required?

When compared with HASHBYTES, CHECKSUM, has a number of drawbacks. Hence, a question that comes up is: Is Checksum really required? In this article, I attempt to answer that question.  Read more...
By Nakul Vachhrajani 2013/03/27 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 6,749 reads

SQL Server 2012 Integration Services - PowerShell-Based Project Deployment

You have the option of using PowerShell when automating management of SQL Server 2012 Integration Services. While this functionality is not as straightforward as those accustomed to traditional PowerShell cmdlets might expect, the steps required to accomplish the most common SSIS administrative tasks follow a relatively consistent pattern.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 1,818 reads

Data Mining SQLIO Results

Learn how to use Analysis Services Data Mining to identify the influence of RAID level and IO Pattern on Latency.  Read more...
By Paul Brewer 2013/03/26 | Source: SQLServerCentral.com | Category: sqlio
Rating: |  Discuss |   Briefcase | 2,938 reads

Red Gate brings SQL in the City back to London for the third year running

Data professionals are invited to attend Red Gate’s free SQL in the City event for a day of SQL Server training in London.  Read more...
By Press Release 2013/03/26 (first published: 2013/03/21) | Source: Red-Gate | Category: red gate software
Rating: (not yet rated) |  Discuss |   Briefcase | 644 reads

SQL Server's Auto Update Statistics Async Option

I have been trying to tune my SQL Server and I noticed a few database settings for statistics. I also read the previous tip on automatic statistics updates. Could you please describe the Auto Create Statistics Async option? How is this configured and when should I use it and when should I avoid using it?  Read more...
By Additional Articles 2013/03/26 | Source: MSSQLTips.com | Category: async
Rating: (not yet rated)  Rate this |   Briefcase | 3,490 reads

Stairway to SQL PowerShell Level 5: SQL Server PowerShell Building Blocks

You should be on your way with PowerShell with the previous levels and now the topic shifts to using Functions and Assemblies built in to .NET for use with automation. This topic will be used in your PowerShell adventures throughout your career and this Stairway.  Read more...
By Ben Miller 2013/03/25 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 5,400 reads

Data Science Laboratory System - Instrumentation

It is sensible to check the performance of different solutions to data analysis in 'lab' conditions. Measurement by instrumentation makes it easier to develop systems that are efficient.  Read more...
By Additional Articles 2013/03/25 | Source: SimpleTalk | Category: data science
Rating: (not yet rated)  Rate this |   Briefcase | 2,325 reads

Creating Custom T-SQL Conditions and Policies for SQL Server Policy-Based Management

In SQL Server, the built in conditions and policies are a great place to get started with monitoring your environment, but there are no facets for some aspects of SQL Server I want to monitor. How can I check on my environment using Policy Based Management? Check out this tip to learn more.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 2,819 reads

Use of Identity Property to Resolve Concurrency Issues

This article describes how the identity property was used to resolve contention in a database  Read more...
By Ajit Ananthram 2013/03/22 (first published: 2011/02/24) | Source: SQLServerCentral.com | Category: locking
Rating: |  Discuss |   Briefcase | 17,721 reads

SQLServerCentral Runs sp_Blitz - Performance Part 2

The second part of our performance examination on the SQLServerCentral database servers using the sp_Blitz script from Brent Ozar, PLF.  Read more...
By Steve Jones 2013/03/21 | Source: SQLServerCentral.com | Category: sqlservercentral
Rating: |  Discuss |   Briefcase | 6,262 reads

Query Tuning, Encryption, and more at SQL Intersection

Grant Fritchey is speaking about query tuning, Steve Jones talking about Encryption, Paul Randal telling you how to make SQL Server faster. All at SQL Intersection. Join us in April.  Read more...
By Press Release 2013/03/21 | Source: SQLServerCentral.com | Category: sql intersection
Rating: (not yet rated)  Rate this |   Briefcase | 3,418 reads

Using Optimizer_WhatIF and StatsStream to Simulate a Production Environment

SQL Server's Query optimiser judges the best query plan from the data in the relevant tables and the server's hardware. How, then, can you investigate the query plans being generated for slow-running queries on a customer's production server when you can neither access the server, nor recreate the database from a backup?  Read more...
By Additional Articles 2013/03/21 | Source: SimpleTalk | Category: optimizer_whatif
Rating:  Rate this |   Briefcase | 2,002 reads

The Power of the SQL Server Database Owner

I have a couple of databases supporting applications. The first application requires that it's user be a member of the db_owner role. The second application actually has to own the database. What are the effects of having such permissions? Check out this tip to learn more.  Read more...
By Additional Articles 2013/03/20 | Source: MSSQLTips.com | Category: db_owner
Rating:  Rate this |   Briefcase | 3,929 reads

Populating a Vertically Filtered Replicated Table

Vertical filtering of a large replicated table introduces the potential for unwanted transactions to be pushed to the subscriber. This article talks about how you might avoid this.  Read more...
By Jason Bunn 2013/03/20 | Source: SQLServerCentral.com | Category: replication
Rating: |  Discuss |   Briefcase | 2,291 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,414 reads