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

Debugging Natively-Compiled Stored Procedures Statements

Considering that SQL Server 2014 Natively Compiled Stored Procedures are compiled into binary code, you may have asked yourself if it's possible to monitor statement execution. In this tip Daniel Farina explains how you can monitor SQL Server Natively Compiled Stored Procedures.  Read more...
By Additional Articles 2014/12/15 | Source: MSSQLTips.com | Category: stored procedures
Rating: (not yet rated)  Rate this |   Briefcase | 5,192 reads

Data Security Woes

Another week, and another set of data security issues around the world.  Read more...
By Steve Jones 2014/12/15 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 66 reads

What, when and who? Auditing 101 - Part 2

In my previous article we discussed Change Tracking which is one of the new technologies introduced by Microsoft. This article will focus on Change Data Capture.   Read more...
By Roy Ernest 2014/12/12 (first published: 2012/01/16) | Source: SQLServerCentral.com | Category: sql server
Rating: |  Discuss |   Briefcase | 11,875 reads

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,567 reads

The Last Job

Steve Jones contemplates employment and the future of the last job he'll have. This Friday he asks you if this might be yours.  Read more...
By Steve Jones 2014/12/12 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 130 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,058 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 | 113 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,399 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,759 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,857 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,506 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 | 50,084 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,134 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,161 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,456 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,413 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 | 638 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
<< Newer    Items 21 to 40 of 13327    Older >>