Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

<< Newer    Items 41 to 60 of 13693    Older >>
 

Sweeping out SQL Server 2005

Tony Davis on why the dusty corners of many organizations still hide numerous SQL 2005 instances.  Read more...
By Tony Davis 2015/04/20 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 72 reads

SSIS Design Pattern - Staging Delimited Flat Files

Learn how to use SSIS to load Delimited Flat Files to staging tables.  Read more...
Rating: |  Discuss |   Briefcase | 6,158 reads

How to Get SQL Server Data Conversion Horribly Wrong

One of the most certain ways of going wrong with any relational database is to get data conversion wrong. Implicit data conversion is a good feature for the expert but can cause a lot of trouble to the unwary. These boil down to seven ways of failing to get data conversion right. Rob Sheldon explains and gives sage advice on how to avoid the problems.  Read more...
By Additional Articles 2015/04/20 | Source: SimpleTalk | Category: data conversion
Rating: (not yet rated)  Rate this |   Briefcase | 6,347 reads

The Elusive Conditional WHERE Clause

What's this, a conditional WHERE clause that doesn't use dynamic SQL?  Read more...
By John Hick 2015/04/17 (first published: 2013/04/18) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 33,663 reads

Monitoring After Deployment

This Friday's poll looks at the time after deployment. Can you tell if things were successful? Do you have a formal way to determine if the changes are causing issues?  Read more...
By Steve Jones 2015/04/17 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 94 reads

Webinar: Wait, what exactly are we shipping? Keeping control in database continuous delivery

Join us on Tuesday 28th April at 4pm BST (11am EDT) for a free webinar panel discussion featuring Brian A. Randell, Grant Fritchey, Steve Jones, and host, Stephanie Herr, on the topic of maintaining visibility and control in database continuous delivery.   Read more...
By Press Release 2015/04/23 (first published: 2015/04/17) | Source: Redgate | Category: webinar
Rating: (not yet rated)  Rate this |   Briefcase | 7,409 reads

How DBAs Can Adopt the Craftsman Mindset

The job of a DBA requires a fusion of skill and knowledge. To acquire this requires a craftsman mindset. Craftsmen find that the better they get at the work, the more enjoyable the work gets, and the more successful they become. Deliberate practice, Specialization and an appetite for overcoming difficulty are good habits to deliberately adopt to successfully grow those craftsmanlike skills to the point that you become “so good they can’t ignore you”.  Read more...
By Additional Articles 2015/04/17 | Source: SimpleTalk | Category: dba skills
Rating:  Rate this |   Briefcase | 7,311 reads

QA for Data

Often DBAs and developers might make quick data changes to correct user problems or application shortfalls. Steve Jones notes that we can make mistakes, and perhaps we should ensure we QA, or at least log, our changes.  Read more...
By Steve Jones 2015/04/16 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 122 reads

How to Categorize Uncategorized Data

Using SQL to perform cluster analysis to gain insight into data with unknown groups  Read more...
By Stephan Calderon 2015/04/16 | Source: SQLServerCentral.com | Category: cluster analysis
Rating: |  Discuss |   Briefcase | 3,790 reads

Microsoft® SQL Server® 2014 Service Pack 1 (SP1) released

Service Pack 1 for SQL Server 2014 has been released.  Read more...
By 2015/04/16 | Source: Microsoft SQL Home | Category: sql server 2014
Rating:  Rate this |   Briefcase | 9,644 reads

Selecting Data Using the TOP Clause

There are times when you don’t what to return a complete set of records. When you have this kind of requirement to only select the TOP X number of items Transact SQL (TSQL) has the TOP clause to meet your needs. In this article Greg Larsen explores how to select a subset of data from a record set.  Read more...
By Additional Articles 2015/04/16 | Source: Database Journal | Category: top
Rating:  Rate this |   Briefcase | 8,386 reads

Byte Me: Feeling The Squeeze

Blame the jargon.  Read more...
By Bob Lang 2015/04/15 | Source: SQLServerCentral.com | Category: byte me
Rating: |  Discuss |   Briefcase | 331 reads

Stairway to SQL Server Security Level 8: Data Encryption

This stairway level will explore data protection through encryption, both when the data is in motion across the network or in memory and at rest in a table. You’ll learn about the encryption key hierarchy and the various kinds of keys you can use to encrypt data, as well as how you can manage the keys or let SQL Server do it for you.  Read more...
By Don Kiely 2015/04/15 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 2,857 reads

Free eBook: Defensive Database Programming

Resilient T-SQL code is code that is designed to last, and to be safely reused by others. The goal of defensive database programming, the goal of this book, is to help you to produce resilient T-SQL code that robustly and gracefully handles cases of unintended use, and is resilient to common changes to the database environment.  Read more...
By Press Release 2015/04/15 (first published: 2013/08/28) | Source: Redgate | Category: defensive programming
Rating: (not yet rated)  Rate this |   Briefcase | 58,764 reads

SQL Server Spatial Indexes

Spatial Data in SQL Server has special indexing because it has to perform specialised functions. It is able, for example, to break down an indexed space into a grid hierarchy by using a technique called tessellation. This is a rules-based system that, when you compare a shape to an index, works out how many cells in the the grid hierarchy are touched by that shape , and how deep down the grid hierarchy to search. There is powerful magic in Spatial Indexes as Surenda and Roy explain.  Read more...
By Additional Articles 2015/04/15 | Source: SimpleTalk | Category: spatial data
Rating:  Rate this |   Briefcase | 5,942 reads

Using LAST_VALUE

When I began using LAST_VALUE, the results were not what I expected at all. Read on to learn the secret!  Read more...
By Kathi Kellenberger 2015/04/14 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 14,467 reads

The Opportunistic Hacker

Sometimes the crimes of opportunity might be the worst ones for our data.  Read more...
By Steve Jones 2015/04/14 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 185 reads

Prevent and Log Certain SQL Server Login Attempts

Aaron Bertrand presents a more elegant to prevent developers from attempting to log into production databases using application logins (and to log any such attempts).   Read more...
By Additional Articles 2015/04/14 | Source: MSSQLTips.com | Category: login
Rating: (not yet rated)  Rate this |   Briefcase | 6,671 reads

SQL Monitor Custom Metric: Tables Without Clustered Indexes

This metric by Fabiano Amorim measures the number of tables without clustered indexes defined that contain more than 1000 rows per database. This is good practice to help improve query performance.  Read more...
By 2015/04/14 | Source: SQL Monitor Metrics | Category: custom metrics
Rating: (not yet rated)  Rate this |   Briefcase | 6,197 reads

Maps in SQL Server Reporting Services

Learn how to add maps to your Reporting Services reports with this article from expert Adam Aspin.  Read more...
By Adam Aspin 2015/04/13 | Source: SQLServerCentral.com | Category: reporting services (ssrs)
Rating: |  Discuss |   Briefcase | 6,387 reads
<< Newer    Items 41 to 60 of 13693    Older >>