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

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,979 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

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,617 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,840 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 | 440 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,358 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,467 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 | 6,993 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,559 reads

Life Logging

This editorial was orignally published on Dec 8, 2009. It is being re-run as Steve is on vacation. Would you like the idea of capturing everything you do? Audio, video, text, code, a log of your life. A new book from Microsoft Research talks about this and Steve Jones things it could be an interesting capability for your career.  Read more...
By Steve Jones 2014/10/01 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 142 reads

Free eBook: Performance Tuning with SQL Server Dynamic Management Views

Dynamic Management Views (DMVs) are a significant and valuable addition to the DBA's troubleshooting armory, laying bare previously unavailable information regarding the under-the-covers activity of your database sessions and transactions.  Read more...
By Additional Articles 2014/10/01 (first published: 2013/08/21) | Source: Red-Gate | Category: performance tuning
Rating:  Rate this |   Briefcase | 35,977 reads

Filling In Missing Values Using the T-SQL Window Frame

Since SQL Server delivered the entire range of window functions, there has been far less justification for using the non-standard ex-Sybase 'Quirky Update' tricks to perform the many permutations of running totals in SQL Server. One of these related problems is the 'Data Smear'. Do window functions make this easier, and what is performance like? Dwain Camps investigates.  Read more...
By Additional Articles 2014/10/01 | Source: SimpleTalk | Category: t-sql
Rating:  Rate this |   Briefcase | 8,799 reads

Challenge Yourself

How do you grow your career? Steve Jones has a few ideas on what you can do to both improve your skills and build your brand.  Read more...
By Steve Jones 2014/09/30 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 230 reads

Synchronize Salesforce with SQL Server using SSIS

Easily synchronize live Salesforce data with SQL Server using the Salesforce SSIS DataFlow Tasks.   Read more...
By Eric Madariaga 2014/09/30 | Source: SQLServerCentral.com | Category: integers
Rating: |  Discuss |   Briefcase | 4,026 reads

SQL Server 2008 R2 Build List

The list of builds for SQL Server 2008 R2 up to SP3.  Read more...
By Steve Jones 2014/09/30 (first published: 2010/05/25) | Source: SQLServerCentral.com | Category: sql server 2008 r2
Rating: |  Discuss |   Briefcase | 52,606 reads

Webinar: 7 Steps to Build a Database Deployment Pipeline

Join Red Gate’s Alex Yates and TeamCity for a free webinar this Thursday, October 2nd. In this practical demo, Alex will show you how to set up continuous delivery for your SQL databases using TeamCity, Red Gate’s SQL Automation Pack, and Octopus Deploy. Places are limited – register now.  Read more...
By Press Release 2014/09/30 | Source: Red-Gate | Category: webinar
Rating: (not yet rated)  Rate this |   Briefcase | 7,160 reads

Change All Computed Columns to Persisted in SQL Server

Aaron Bertrand recently answered a question from a user who wanted to convert all of their SQL Server computed columns to be persisted. This allows you to shift the SQL Server cost of performing the computation from query time to the time of the insert/update, at the cost of storage. In this tip, Aaron shows you how.  Read more...
By Additional Articles 2014/09/30 | Source: MSSQLTips.com | Category: change column
Rating: (not yet rated)  Rate this |   Briefcase | 6,905 reads
<< Newer    Items 41 to 60 of 13154    Older >>