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 13701    Older >>
 

Stairway to SQL PowerShell Level 9: Objects For Everyone

This level will show how to create objects including a login, a database, a filegroup, a file a database user and then we’ll end with a table and an index.  Read more...
By Ben Miller 2015/04/22 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 2,994 reads

Security Through Chaos

A company Steve Jones knows uses a diverse network infrastructure to help provide security.  Read more...
By Steve Jones 2015/04/22 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 103 reads

Schema-Based Access Control for SQL Server Databases

Access-control within the database is important for the security of data, but it should be simple to implement. It is easy to become overwhelmed by the jargon of principals, securables, owners, schemas, roles, users and permissions, but beneath the apparent complexity, there is a schema-based system that, in combination with database roles and ownership-chaining, provides a relatively simple working solution.  Read more...
By Additional Articles 2015/04/22 | Source: SimpleTalk | Category: access restriction
Rating: (not yet rated)  Rate this |   Briefcase | 5,502 reads

Free eBook: SQL Server Execution Plans, Second Edition

Every day, out in the various online forums devoted to SQL Server, and on Twitter, the same types of questions come up repeatedly: Why is this query running slowly? Why is SQL Server ignoring my index? Why does this query run quickly sometimes and slowly at others? My response is the same in each case: have you looked at the execution plan?  Read more...
By Press Release 2015/04/22 (first published: 2013/07/30) | Source: Redgate | Category: execution plans
Rating:  Rate this |   Briefcase | 60,711 reads

Would a Duress Password be a Good Idea?

Today we have a guest editorial from Andy Warren. Should we adopt a duress password, just in case we find ourselves in a movie situation while at work?  Read more...
By Andy Warren 2015/04/21 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 136 reads

Data Mining Part 26: Introduction to Cubes

In this tutorial we will explain what are the SSAS cubes to use them in Data Mining.  Read more...
By Daniel Calbimonte 2015/04/21 | Source: SQLServerCentral.com | Category: data mining
Rating: (not yet rated) |  Discuss |   Briefcase | 3,539 reads

Automating Image-Based Deployment of SQL Server on Azure IaaS VMs - Preparing OS Image

There are several different approaches to automating deployment of SQL Server Infrastructure-as-a-Service virtual machines in Microsoft Azure. Marcin Policht examines an approach that involves uploading or creating a custom operating system image which is well suited for scenarios where you want to deploy a custom-configured SQL Server instance to multiple virtual machines with minimal effort and maximum consistency.  Read more...
By Additional Articles 2015/04/21 | Source: Database Journal | Category: iaas
Rating: (not yet rated)  Rate this |   Briefcase | 5,684 reads

Embrace Stored Procedures

Developers working with SQL Server should learn to embrace stored procedures. They really, really do work well.  Read more...
By Steve Jones 2015/04/20 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 332 reads

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 | 73 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,223 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,745 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,807 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 | 96 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,604 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,424 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,816 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,724 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,466 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 | 338 reads
<< Newer    Items 41 to 60 of 13701    Older >>