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

Red Gate Rolls Out the Red Carpet for SQL Server Users

SQL in the City, the unique event for database developers and administrators organized by Red Gate Software, hits the streets of London and Seattle this fall. Now in its fourth year, it features presentations by some of the world’s top SQL Server speakers.  Read more...
By Press Release 2014/08/21 (first published: 2014/08/15) | Source: SQL in the City | Category: sql in the city
Rating: (not yet rated) |  Discuss |   Briefcase | 939 reads

Why the SQL Server FORCESCAN hint exists

It is often generalized that seeks are better than scans in terms of retrieving data from SQL Server. The index hint FORCESCAN was recently introduced so that you could coerce the optimizer to perform a scan instead of a seek. Which might lead you to wonder: Why would I ever want a scan instead of a seek?  Read more...
By Additional Articles 2014/08/15 | Source: MSSQLTips.com | Category: forcescan
Rating: (not yet rated)  Rate this |   Briefcase | 7,189 reads

SQL Saturday #323 - Paris

On September 13, 2014 the French SQL Server Community (GUSS) will be holding a SQL Saturday conference. The event is free to attend, with 4 paid-for pre-conference sessions available. Register while space is available.  Read more...
By Press Release 2014/08/15 | Source: SQL Saturday | Category: events
Rating: (not yet rated)  Rate this |   Briefcase | 5,625 reads

Restore Gene : Automating SQL Server Database Restores

Restore Gene is a simple 2-script framework, one PowerShell script and one SQL stored procedure, which will speed up the production of restore scripts for manual disaster recovery, as well help automate log shipping.   Read more...
By Paul Brewer 2014/08/14 | Source: SQLServerCentral.com | Category: restore database
Rating: |  Discuss |   Briefcase | 3,218 reads

How Much for a Laugh?

How much would you pay for a laugh? Maybe you'll donate to ensure that some of your SQL Server speakers will embarrass themselves at the PASS Summit.  Read more...
By Steve Jones 2014/08/14 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 212 reads

The Hybrid Cloud: Having your Cake

With a hybrid cloud, can you get the freedom and flexibility of a public cloud with the security and bandwidth of a private cloud? Robert Sheldon explains all the ins and outs.  Read more...
By Additional Articles 2014/08/14 | Source: SimpleTalk | Category: hybrid cloud
Rating: (not yet rated)  Rate this |   Briefcase | 7,939 reads

One System to Rule Them All

Can a single piece of software work well for most situations? Steve Jones wonders if we're not attacking the problems of large software applications in the right way.  Read more...
By Steve Jones 2014/08/13 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 131 reads

Stairway to Database Design Level 2: Domains, Constraints and Defaults

A clear understanding of SQL Data Types and domains is a fundamental requirement for the Database Developer, but it is not elementary. If you select the most appropriate data type, it can sidestep a variety of errors. Furthermore, if you then define the data domains as exactly as possible via constraints, you can catch a variety of those problems that would otherwise bedevil the work of the application programmer.  Read more...
By Joe Celko 2014/08/13 (first published: 2010/05/04) | Source: SQLServerCentral.com | Category: database design
Rating: |  Discuss |   Briefcase | 20,602 reads

Free eBook: Understanding SQL Server Concurrency

When you can’t get to your data because another application has it locked, a thorough knowledge of SQL Server concurrency will give you the confidence to decide what to do.  Read more...
By Press Release 2014/08/13 (first published: 2013/07/17) | Source: Red-Gate | Category: concurrency
Rating:  Rate this |   Briefcase | 28,714 reads

Automating SQL Server Agent Notification

This article looks at some automated approaches of monitoring SQL Server agent jobs.  Read more...
By Additional Articles 2014/08/13 | Source: Database Journal | Category: sql server agent
Rating: (not yet rated)  Rate this |   Briefcase | 7,169 reads

Data Mining: Part 13 Powershell

In this lesson we will explain how to create scripts to manage Data Mining Models using Powershell.  Read more...
By Daniel Calbimonte 2014/08/12 | Source: SQLServerCentral.com | Category: data mining
Rating: |  Discuss |   Briefcase | 2,935 reads

The Brittleness of Replication

Replication is a great feature in SQL Server, but it seems brittle. When things go wrong, they break quickly, and often severely. It seems that we have many features like this in SQL Server that are useful and handy, but receive very little attention as versions are released.  Read more...
By Steve Jones 2014/08/12 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 174 reads

Adding Custom Reports to SQL Server Management Studio

In this tip, Koen Verbeeck explores how to apply business intelligence solutions to administrative tasks, specifically creating custom reports and adding them to SQL Server Management Studio.  Read more...
By Additional Articles 2014/08/12 | Source: MSSQLTips.com | Category: reports
Rating: (not yet rated)  Rate this |   Briefcase | 8,450 reads

SQL Saturday #320 - Raleigh, NC

SQL Saturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. The Triangle SQL Server user group (http://www.tripass.org) of Raleigh, NC is hosting this event on September 6, 2014. Register while space is available.  Read more...
By Press Release 2014/08/12 | Source: SQL Saturday | Category: events
Rating: (not yet rated)  Rate this |   Briefcase | 6,295 reads

Verify SQL Backup Integrity

Perform automated database restores and check the integrity of your backup files  Read more...
By Willem Gossink 2014/08/11 | Source: SQLServerCentral.com | Category: backup
Rating: |  Discuss |   Briefcase | 3,639 reads

We Don't Care about Data and IT Security

Most of us say we care about IT and data security. Our actions speak differently.  Read more...
By Brian Kelley 2014/08/11 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 206 reads

Data is Not Always Enough

More data is better, but Steve Jones notes that even that isn't always enough to make decisions count for your organization.  Read more...
By Steve Jones 2014/08/11 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 74 reads

Practically Cloudy: SQL Server Disaster Recovery to Microsoft Azure - Backups

In the first in a series on the practicalities of using the Microsoft Azure Platform for the SQL Server professional, Buck Woody shows that, whatever your version of SQL Server, there is a way of storing offsite backups in the cloud.  Read more...
By Additional Articles 2014/08/11 | Source: SimpleTalk | Category: disaster recovery (dr)
Rating: (not yet rated)  Rate this |   Briefcase | 7,078 reads

How to Create a Corrupt SQL Server Database

This article details how to create a corrupt SQL Server database for testing purposes  Read more...
By Perry Whittle 2014/08/08 (first published: 2012/05/04) | Source: SQLServerCentral.com | Category: checkdb
Rating: |  Discuss |   Briefcase | 18,157 reads

The SQL of Membership: Equivalence Classes & Cliques

It is awkward to do 'Graph databases' in SQL to explore the sort of relationships and memberships in social networks because equivalence relations are classes (a set of sets) rather than sets. However one can explore graphs in SQL if the relationship has all three of the mathematical properties needed for an equivalence relationship.  Read more...
By Additional Articles 2014/08/08 | Source: SimpleTalk | Category: graph databases
Rating: (not yet rated)  Rate this |   Briefcase | 8,590 reads
<< Newer    Items 41 to 60 of 13002    Older >>