Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in

<< Newer    Items 61 to 80 of 13951    Older >>

Trust People

Steve Jones thinks that we are not doing a great job of harnessing the brain power of our entire teams.  Read more...
By Steve Jones 2015/07/13 | Source: | Category: editorial
Rating: |  Discuss |   Briefcase | 280 reads

Modeling for Graph Databases

This week Steve Jones looks at modeling data in a graph database.  Read more...
By Steve Jones 2015/07/13 | Source: | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 83 reads

Knee-Jerk Wait Statistics : CXPACKET

With another entry in his knee-jerk series on wait statistics, Paul Randal (@PaulRandal) explains CXPACKET and why it may or may not be a problem.  Read more...
By Additional Articles 2015/07/13 | Source: | Category: cxpacket
Rating:  Rate this |   Briefcase | 2,726 reads

Data Loss or Downtime

This Friday Steve Jones has a DR poll. He asks what might be more important to you in a disaster and why.  Read more...
By Steve Jones 2015/07/10 | Source: | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 219 reads

A simple trick for “Block Comment” syntax in SSMS

Make your comment blocks much more useful, in a surprising number of ways  Read more...
By Peter Zerk 2015/07/10 (first published: 2013/07/08) | Source: | Category: t-sql
Rating: |  Discuss |   Briefcase | 20,006 reads

FORMAT() is nice and all, but…

Aaron Bertrand compares multiple date formatting techniques, demonstrating again that SQL Server's FORMAT() is not worth the convenience.  Read more...
Rating:  Rate this |   Briefcase | 5,429 reads

Data Mining Part 30: System Views

Sometimes we need to retrieve system information from our data mining models. In this chapter, we will show how to do it using system views.  Read more...
By Daniel Calbimonte 2015/07/09 | Source: | Category: data mining
Rating: |  Discuss |   Briefcase | 2,221 reads

Is the Golden Age of Information Technology Almost Over?

Andy Warren wonders if our industry is moving to a new era today.  Read more...
By Andy Warren 2015/07/09 | Source: | Category: editorial
Rating: |  Discuss |   Briefcase | 208 reads

How to Unlock Your Team's Creative Power with SQL Prompt and a VCS

Extend SQL Prompt's functionality by connecting your snippets to version control  Read more...
By Gaurav Vohra 2015/07/09 | Source: | Category: sql prompt
Rating: |  Discuss |   Briefcase | 1,282 reads

In-Memory OLTP – Common Workload Patterns and Migration Considerations

In-Memory OLTP is a high performance, memory-optimized engine integrated into SQL Server 2014 and designed for modern hardware trends. In-Memory OLTP allows users to move data into memory resident tables while keeping other data in traditional, disk-based table structures.  Read more...
By Additional Articles 2015/07/09 | Source: Microsoft MSDN
Rating:  Rate this |   Briefcase | 2,383 reads

Byte Me: Pillow Talk

Shrink DB. 
By Bob Lang 2015/07/08 | Source: | Category: byte me
Rating: (not yet rated) |  Discuss |   Briefcase | 304 reads

Extending Custom Execution in the SSIS Catalog – Level 21 of the Stairway to Integration Services

In this installment of the Stairway to Integration Services, Andy Leonard shows you how to execute packages synchronously or asynchronously.  Read more...
Rating: |  Discuss |   Briefcase | 2,627 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/07/08 (first published: 2013/07/30) | Source: Redgate | Category: execution plans
Rating:  Rate this |   Briefcase | 64,147 reads

The Poster of the Plethora of PowerShell Pitfalls

One of the downsides of learning a new computer language is that transfer of training doesn't always work to your advantage. In fact, the habits you picked up in the past may now cause confusion. In this poster or wall-chart for long walls, Michael Sorens selects the thirty-six most common causes of confusion for anyone getting to grips with PowerShell.  Read more...
By Additional Articles 2015/07/08 | Source: SimpleTalk | Category: powershell
Rating: (not yet rated)  Rate this |   Briefcase | 4,004 reads

Translating reports with Analysis Services and MS-Excel

Translating reports with Analysis Services 2012 and MS-Excel 2013 in a multilingual environment  Read more...
By Jan D'Hondt 2015/07/07 | Source: | Category: ssas
Rating: |  Discuss |   Briefcase | 3,291 reads

Temporarily Change SQL Server Log Shipping Database to Read Only

I want to temporarily use a Log Shipped secondary database for Read Only operations, but Log Shipping was not configured for read only operations. I don't want to reconfigure Log Shipping, so is there a way to do this without redoing Log Shipping.  Read more...
By Additional Articles 2015/07/07 | Source: | Category: log shipping
Rating: (not yet rated)  Rate this |   Briefcase | 2,170 reads

Monitoring Availability Groups with Redgate SQL Monitor

Anthony Nocentino, experienced Enterprise Architect and Friend of Redgate, explains the challenges presented by monitoring Availability Groups and shows you a technique for monitoring AG replication latency with Redgate SQL Monitor and its Custom Metric functionality.  Read more...
By Anthony Nocentino 2015/07/07 | Source: Redgate | Category: sql monitor
Rating: (not yet rated)  Rate this |   Briefcase | 1,539 reads

Why Can't We Code?

Today Steve Jones talks about the ways in which we interview new developers. Are they working or do we need a new way? Should we be considering those people that have actually accomplished something?  Read more...
By Steve Jones 2015/07/07 | Source: | Category: editorial
Rating: |  Discuss |   Briefcase | 505 reads

Soundex - Experiments with SQLCLR Part 2

Constructive feedback on SOUNDEX - Experiments with SQLCLR lead to further experimentation with phonetic algorithms  Read more...
By David Poole 2015/07/06 | Source: | Category: soundex
Rating: |  Discuss |   Briefcase | 3,080 reads

Learning About Temporal Tables

Learn about the new temporal table feature in SQL Server 2016  Read more...
By Site Owners 2015/07/06 | Source: | Category: temporal tables
Rating: (not yet rated) |  Discuss |   Briefcase | 2,861 reads
<< Newer    Items 61 to 80 of 13951    Older >>