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

SQL Saturday #337 - Portland, OR

SQL Saturday is coming to Portland on November 1! Join us for a free day of SQL Server training and networking. Speakers at this event include Red Gate's Grant Fritchey, Kathi Kellenberger, Benjamin Nevarez, and more. There are also 3 paid-for pre-con sessions for this event. Register while space is available.  Read more...
By Press Release 2014/10/09 | Source: SQL Saturday | Category: events
Rating: (not yet rated)  Rate this |   Briefcase | 5,748 reads

Byte Me: Recruitment Drive

Innovative recruitment solutions available now!  Read more...
By Bob Lang 2014/10/08 | Source: SQLServerCentral.com | Category: byte me
Rating: (not yet rated) |  Discuss |   Briefcase | 391 reads

Data Mining Part 18: Excel and Data Mining

In this new article, we will introduce you to Microsoft Excel and Data Mining.  Read more...
By Daniel Calbimonte 2014/10/08 | Source: SQLServerCentral.com | Category: excel
Rating: |  Discuss |   Briefcase | 3,715 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 2014/10/08 (first published: 2013/07/30) | Source: Red-Gate | Category: execution plans
Rating:  Rate this |   Briefcase | 42,451 reads

Backup and Restore Strategies in SQL Server – Part 1

You need to set up backup and restore strategies to recover data or minimize the risk of data loss in case a failure happens. In this article series, Arshad Ali discusses backup and restore strategies in SQL Server.  Read more...
By Additional Articles 2014/10/08 | Source: Database Journal | Category: backup / restore
Rating:  Rate this |   Briefcase | 8,378 reads

Solving Kerberos Issues in SSRS When Running Beside IIS

When SSRS is running on a server with IIS, pass through Windows Authentication can be difficult to set up.  Read more...
By Ian Massi 2014/10/07 | Source: SQLServerCentral.com | Category: reporting services (ssrs)
Rating: |  Discuss |   Briefcase | 3,222 reads

A T-SQL Code Testing Guide

Testing our database code is a fairly immature process for many of this, but perhaps we could build a guide that helps everyone learn to write better and more comprehensive tests.  Read more...
By Steve Jones 2014/10/07 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 295 reads

Improving the Quality of SQL Server Database Connections in the Cloud

To access SQL Server from the client, you use TDS protocol over TCP. This is fine over reliable LANs but over the internet these connections are relatively slow and fragile. TDS is still used to connect to databases in the cloud, but you need to use a combination of the new features such as connection pools and idle connection resiliency to make applications faster and more reliable. Edward Elliott shows you how.  Read more...
By Additional Articles 2014/10/07 | Source: SimpleTalk | Category: tcp connection
Rating:  Rate this |   Briefcase | 6,392 reads

Connecting to Analysis Services in Another Domain

Connecting to resources in untrusted domains with windows authentication can be tricky. Here's how to make it easy.  Read more...
By Ian Massi 2014/10/06 | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 1,984 reads

SQL Server Reporting Services (SSRS) Log Files for Troubleshooting

Your SQL Server Report Server service will not start or you keep getting an error when you navigate to the SSRS URL? What logging tools are available to assist you with diagnosing SSRS problems, issues, or errors? Check out this tip to learn more.  Read more...
By Additional Articles 2014/10/06 | Source: MSSQLTips.com | Category: reporting services (ssrs)
Rating:  Rate this |   Briefcase | 6,626 reads

The Next Five Years

What is coming in the next five years for us? Steve Jones has a few thoughts.  Read more...
By Steve Jones 2014/10/06 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 252 reads

Saving Hard Dollars

Data analysis can save money and resources, but it will certainly transform our world.  Read more...
By Steve Jones 2014/10/06 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 83 reads

Using the WMI Event Watcher Task in SSIS to Process Data Files

With the WMI Event Watcher Task in SSIS we can import files as soon as they arrive.  Read more...
By Orlando Colamatteo 2014/10/03 (first published: 2012/07/02) | Source: SQLServerCentral.com | Category: integration services (ssis)
Rating: |  Discuss |   Briefcase | 13,872 reads

The Decline of SQL Server

The popularity of SQL Server seems to be high, but there might be reasons to be concerned.   Read more...
By Steve Jones 2014/10/03 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 443 reads

Ninja Immutable Databases

'Immutable' databases operate under the principle that data or objects should not be modified after they are created. Once again they hold the promise of providing strong consistency combined with horizontal read scalability, and built-in caching. Are Immutable databases a new idea? Are they different in any way from the mainstream RDBMSs?  Read more...
By Additional Articles 2014/10/03 | Source: SimpleTalk | Category: immutable databases
Rating: (not yet rated)  Rate this |   Briefcase | 8,408 reads

You Can Still Vote for PASS

If you couldn't vote last week or didn't get a ballot, you still can. Please go to www.sqlpass.org and learn more.  Read more...
By Steve Jones 2014/10/03 (first published: 2014/09/29) | Source: SQLServerCentral.com | Category: pass
Rating: |  Discuss |   Briefcase | 437 reads

Data Compression and Snapshot Isolation

Data Compression and Snapshot Isolation don't play well together, you may not see a performance benefit  Read more...
By Jeff Reinhard 2014/10/02 | Source: SQLServerCentral.com | Category: data compression
Rating: |  Discuss |   Briefcase | 2,481 reads

Protect Confidential SQL Server Data Q and A

Following on from a webcast, Tim Smith answers some questions on SQL Server security like: Is It Better To Mask At the Application Level Or The SQL Server Database Level? Are there any options to find SSNs in SQL Server besides RegEx? And, why would anyone store sensitive data un-encrypted in SQL Server?   Read more...
By Additional Articles 2014/10/02 | Source: MSSQLTips.com | Category: security
Rating:  Rate this |   Briefcase | 7,050 reads

The Final Service Packs

Microsoft has released a final service pack for SQL Server 2008 R2, which many of you might want to install.  Read more...
By Steve Jones 2014/10/02 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 161 reads

Stairway to AlwaysOn Level 2: Storage 101

level 2 of the stairway  Read more...
By Perry Whittle 2014/10/01 | Source: SQLServerCentral.com | Category: alwayson
Rating: |  Discuss |   Briefcase | 2,571 reads
<< Newer    Items 41 to 60 of 13162    Older >>