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

<< Newer    Items 21 to 40 of 13323    Older >>
 

Finding SQL Server views with (or without) a certain property

In this tip Aaron Bertrand uses SQL Server metadata queries to discover SQL Server views that have certain properties or use certain syntax.  Read more...
By Additional Articles 2014/12/12 | Source: MSSQLTips.com | Category: views
Rating: (not yet rated)  Rate this |   Briefcase | 4,356 reads

A Spectacular Case of 100% CPU Caused by Online Reindexing

An investigation of a serious performance issue during online re-indexing on a production server leads us to interesting discoveries and solutions.  Read more...
By Viktor Gorodnichenko 2014/12/11 | Source: SQLServerCentral.com | Category: execution plan
Rating: |  Discuss |   Briefcase | 6,011 reads

Citizen Programmers

Steve Jones finds the Salesforce platform interesting and notes we have lots of "citizen programmers" doing work with data.  Read more...
By Steve Jones 2014/12/11 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 112 reads

Cloud Identities versus Federated Identities in Office 365

Identities, the 'accounts' by which Cloud and Web users identify themselves, are tricky to manage, and tiresome for the users. Cloud services such as Office 365 have their main use in large organisations and so there have to be easy ways for system administrators to maintain them. Microsoft provide three alternative strategies; Cloud identities, Synced identities and federated identities. What is the differences between them, and which should you choose?   Read more...
By Additional Articles 2014/12/11 | Source: SimpleTalk | Category: cloud services
Rating: (not yet rated)  Rate this |   Briefcase | 6,117 reads

SQL Monitor Custom Metric: Excessive Virtual Log Files in Transaction Log

This metric picks up excessive counts of Virtual Log Files (VLF) in a transaction log that can lead to performance problems, including write performance, restore and recovery times. The ideal value for this metric should be less than 25; excessively high values (greater than 50) can cause high write times when writing to the transaction log.  Read more...
By Press Release 2014/12/11 | Source: Red-Gate | Category: sql monitor
Rating: (not yet rated)  Rate this |   Briefcase | 5,503 reads

SQL Server Survey

How do you use SQL Server, and how do you expect this to change next year? Fill in our survey, and enter a prize draw to win Amazon vouchers.  Read more...
By Press Release 2014/12/11 (first published: 2014/12/02) | Source: Red-Gate
Rating:  Rate this |   Briefcase | 16,501 reads

Level 4: Analyse & Deploy a Windows Server Failover Cluster

In level 4 of the stairway to AlwaysOn we look at creating a Windows Server Failover Cluster.  Read more...
By Perry Whittle 2014/12/10 | Source: SQLServerCentral.com | Category: cluster
Rating: |  Discuss |   Briefcase | 1,486 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/12/10 (first published: 2013/07/30) | Source: Red-Gate | Category: execution plans
Rating:  Rate this |   Briefcase | 49,981 reads

Managerial Moneyball

Steve Jones notes that the Moneyball phenomenon has come to managers and perhaps a little training and data can help find us better managers.   Read more...
By Steve Jones 2014/12/10 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 91 reads

Lead and Lag Functions in SQL Server 2012

Arshad Ali discusses how to use CTE and the ranking function to access or query data from previous or subsequent rows. He also shows you how to leverage the LEAD and LAG analytics functions to achieve the same result without writing a self-join query using CTE and ranking function  Read more...
By Additional Articles 2014/12/10 | Source: Database Journal | Category: sql server 2012
Rating: (not yet rated)  Rate this |   Briefcase | 6,026 reads

SSRS - Report for Stored Procedure with Multiple Values Passed

You created a report that passed three separate values to a stored procedure, simply enough. However, now the user comes back and they want the ability to select multiple values for the report to return data against. Check out this article for a walk-through on how to handle this request.  Read more...
By Shawn Melton 2014/12/09 | Source: SQLServerCentral.com | Category: report development
Rating: |  Discuss |   Briefcase | 5,126 reads

Holiday Struggles

The sporadic schedule of a day or two a week this holiday season has been a struggle for Steve Jones.  Read more...
By Steve Jones 2014/12/09 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 107 reads

SQL Server Developer tools survey

Participate in an online survey on SQL Server Developer Tools for a chance to win one of ten $100 Amazon vouchers.  Read more...
By Press Release 2014/12/09 (first published: 2014/12/05) | Source: SQLServerCentral.com | Category: survey
Rating: (not yet rated)  Rate this |   Briefcase | 12,257 reads

Continuous Delivery for Databases: Microservices, Team Structures, and Conway's Law

Matthew Skelton proposes a way to enable database continuous delivery that isn’t as outlandish as it first appears. What can Conways Law and Microservices tell us about the future of databases and DBAs? Matthew shows us a glimpse.  Read more...
By Additional Articles 2014/12/09 | Source: SimpleTalk | Category: continuous delivery
Rating: (not yet rated)  Rate this |   Briefcase | 5,300 reads

The 2014 Tribal Awards - Nominations Open

Nominations open until December 10. The Tribal Awards are back and looking to recognize some of the great contributors to the SQL community. Nominations are now open for 11 different categories, but closing soon so make sure your user group, favorite twitter account, or person who's helped you the most this year is nominated.  Read more...
By Press Release 2014/12/09 (first published: 2014/12/02) | Source: SQLServerCentral.com | Category: awards
Rating: (not yet rated) |  Discuss |   Briefcase | 635 reads

We Still Need Human Judgment

Computers aren't necessarily more infallible than humans, and they aren't necessarily even going to make better decisions. We still need humans in the decision process.  Read more...
By Steve Jones 2014/12/08 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 183 reads

Software Projects: the important boring bits

Phil Factor on the sort of boring expertise that will help you thrive as a consultant.  Read more...
By Phil Factor 2014/12/08 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 89 reads

Scripting SQL Server databases with SMO using EnforceScriptingOptions

Obscure impact of switch EnforceScriptingOptions to scripting a SQL Server database.  Read more...
By Johan Bijnens 2014/12/08 | Source: SQLServerCentral.com | Category: sqlserver
Rating: |  Discuss |   Briefcase | 2,185 reads

How to troubleshoot SSL encryption issues in SQL Server

Tibor Nagy explains how to find the root cause of SSL encryption configuration problems in Microsoft SQL Server.  Read more...
By Additional Articles 2014/12/08 | Source: MSSQLTips.com | Category: ssl
Rating: (not yet rated)  Rate this |   Briefcase | 4,873 reads

Overcoming Proposal Objections

We have all had our innovative solutions and proposals shot down by leads, managers and directors. This article addresses some of the causes and tips to improving the success rate for getting your ideas into the priority list.  Read more...
By Eric Notheisen 2014/12/05 | Source: SQLServerCentral.com | Category: management
Rating: |  Discuss |   Briefcase | 87 reads
<< Newer    Items 21 to 40 of 13323    Older >>