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

Newsletter Changes - Reducing Size

A change to the newsletter is coming soon.  Read more...
By Site Owners 2014/08/21 (first published: 2014/08/19) | Source: SQLServerCentral.com | Category: sqlservercentral
Rating: |  Discuss |   Briefcase | 1,513 reads

How to configure SSL encryption in SQL Server

Tibor Nagy explains how to configure Secure Sockets Layer (SSL) encryption on our SQL Servers, with a trusted certificate.  Read more...
By Additional Articles 2014/08/19 | Source: MSSQLTips.com | Category: ssl
Rating: (not yet rated)  Rate this |   Briefcase | 8,900 reads

Automate Your Central Management Server Registrations

Easily register SQL Servers in your inventory to your CMS for easy multi-server queries.  Read more...
By S. Kusen 2014/08/18 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 2,097 reads

Disconnecting Auditing

Currently we have system administrators responsible for securing our systems, including the auditing capabilities. However that's not the best way to ensure that we can protect our systems.  Read more...
By Steve Jones 2014/08/18 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 73 reads

Common database deployment blockers and Continuous Delivery headaches

Deployability is now a first class concern for databases, so why isn’t it as easy as it should be? Matthew Skelton explores seven of the most common challenges which will bring your database deployments to their knees.  Read more...
By Additional Articles 2014/08/18 | Source: SimpleTalk | Category: database deployment
Rating: (not yet rated)  Rate this |   Briefcase | 8,758 reads

The Broad View

An ingenuous use of existing data leads to the thought - when are we so deep in our work that we can't see how to improve?  Read more...
By Dave Convery 2014/08/18 | Source: SQLServerCentral.com | Category: open data
Rating: (not yet rated) |  Discuss |   Briefcase | 18 reads

SQL Saturday #300 - Kansas City

SQL Saturday is coming to Kansas on September 13, 2014. Our very own Steve Jones will be presenting, alongside other big names like Glenn Berry, Kathi Kellenberger, Sean and Jen McCown, Jason Strate, and many more. Register while space is available.  Read more...
By Press Release 2014/08/18 | Source: SQL Saturday | Category: events
Rating: (not yet rated)  Rate this |   Briefcase | 6,042 reads

The Next Generation

Steve Jones wonders about the next generations of IT workers. Can we encourage more people to enter this field? With the supposed shortages of talent today and the poor reputation of IT positions, can we change the trend of fewer people entering IT?  Read more...
By Steve Jones 2014/08/15 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 145 reads

From Hairdresser to DBA – How to start a career in IT

In writing about his career change from hairdresser to DBA, Greg Lucas shares his experiences and offers advice for those looking to move into IT.  Read more...
By Greg M Lucas 2014/08/15 (first published: 2012/09/11) | Source: SQLServerCentral.com | Category: professional development
Rating: |  Discuss |   Briefcase | 16,075 reads

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 | 952 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,488 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,908 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,261 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 | 217 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 | 8,255 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 | 133 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,648 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 | 29,123 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,548 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,992 reads
<< Newer    Items 41 to 60 of 13011    Older >>