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

Calculate the Statistical Mode in SQL Server using T-SQL

Next to the average and the median, there is another statistical value that you can calculate over a set: the mode. This is the value that appears the most often in the set. The average and the median are straight forward to calculate with T-SQL in SQL Server, but how can we determine the mode using T-SQL?  Read more...
By Additional Articles 2015/03/16 | Source: MSSQLTips.com | Category: statistical modeling
Rating:  Rate this |   Briefcase | 5,064 reads

Computational Biologist

A job Steve Jones has never heard of is using data to improve medical treatments.  Read more...
By Steve Jones 2015/03/16 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 84 reads

The Worst Comments

Comments in code can be tricky, but certainly some are better than others. What are your bad examples?  Read more...
By Steve Jones 2015/03/13 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 240 reads

Setting Different Colors for Connections in SSMS

Learn how to set colors for different connections in SSMS.  Read more...
By Peter Schott 2015/03/13 (first published: 2013/09/17) | Source: SQLServerCentral.com | Category: management studio (ssms)
Rating: |  Discuss |   Briefcase | 18,809 reads

Defusing Database Time Bombs: Avoiding the Need to Refactor Databases

Where applications are evolved by gradually molding them to a growing understanding of the business domain, this presents great challenges to database development. If databases are designed too loosely, and initial errors are allowed to fester, the results become harder and harder to refactor until eventually they constitute a database time bomb. Thomas LeBlanc describes how to avoid a few basic, but very common, database time bombs.  Read more...
By Additional Articles 2015/03/13 | Source: SimpleTalk | Category: database design
Rating:  Rate this |   Briefcase | 6,632 reads

Data Breach Danger

Is a data breach a danger to those identified in the data. A court says no, but Steve Jones wonders if this is a bad decision.  Read more...
By Steve Jones 2015/03/12 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 111 reads

Data Mining Part 26: Data Mining and Microsoft Azure

This article shows a step by step tutorial to create a virtual machine in 15 min on Windows Azure.   Read more...
By Daniel Calbimonte 2015/03/12 | Source: SQLServerCentral.com | Category: microsoft
Rating: |  Discuss |   Briefcase | 1,613 reads

Azure Blob Storage Part 7: Snapshots

Robin Shahan introduces the concepts of snapshots in relation to Azure blob storage. She explains what they're for and how to take them, promote them, and delete them.  Read more...
By Additional Articles 2015/03/12 | Source: Just Azure | Category: blob storage
Rating: (not yet rated)  Rate this |   Briefcase | 5,661 reads

Database Continuous Integration workshop, Los Angeles

Redgate are hosting a 1-day public workshop on April 10th 2015 in Los Angeles, California. This workshop will teach you how to link your source control system to a build system, trigger database builds automatically, and lay the foundations for package-based deployments.  Read more...
By Press Release 2015/03/12 | Source: Red-Gate | Category: events
Rating: (not yet rated)  Rate this |   Briefcase | 5,495 reads

The Design Investment

How much of an investment should you make in learning design? Steve Jones talks about why we should learn how to do it right.  Read more...
By Steve Jones 2015/03/11 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 302 reads

Stairway to SQLCLR Level 5: Development (Using .NET within SQL Server)

This time we take a look at various aspects and limitations of working with SQL Server's CLR that affect what can be done and how to do certain things.  Read more...
By Solomon Rutzky 2015/03/11 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 3,931 reads

Free eBook: Troubleshooting SQL Server: A Guide for the Accidental DBA

Three SQL Server MVPs (Jonathan Kehayias, Ted Krueger and Gail Shaw) provide fascinating insight into the most common SQL Server problems, why they occur, and how they can be diagnosed using tools such as Performance Monitor, Dynamic Management Views and server-side tracing. The focus is on practical solutions for removing root causes of these problems, rather than "papering over the cracks".  Read more...
By Press Release 2015/03/11 (first published: 2013/08/07) | Source: Red-Gate | Category: troubleshooting
Rating:  Rate this |   Briefcase | 52,485 reads

IT Compliance and Software Development

What is IT Compliance and is it really necessary for contemporary Agile applications to be constrained by the requirements of compliance? William Brewer argues that if the objective is rapid delivery of applications, then compliance controls must be understood as early as possible in development.  Read more...
By Additional Articles 2015/03/11 | Source: SimpleTalk | Category: compliance
Rating:  Rate this |   Briefcase | 6,969 reads

Limitations of MongoDb

This article looks at two critical limitations suffered by MongoDb compared with SQL Server.  Read more...
By Eric Notheisen 2015/03/10 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 207 reads

What SQL Statements Are Currently Using The Transaction Logs?

This article presents a utility that will show you what SQL statements are using the transaction logs, in terms of log space used and transaction duration.  Read more...
By Ian Stirk 2015/03/10 | Source: SQLServerCentral.com | Category: transaction log
Rating: |  Discuss |   Briefcase | 7,104 reads

SQL Server Random Sorted Result Set

In this tip Dallas Snider illustrates how to write a T-SQL query that will return rows sorted randomly.  Read more...
By Additional Articles 2015/03/10 | Source: MSSQLTips.com | Category: tsql
Rating:  Rate this |   Briefcase | 6,572 reads

Don’t Understand? You’re About to Learn Something

Learning opportunities abound, but they can be stressful, as shown in today's guest editorial.  Read more...
By Andy Warren 2015/03/09 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 221 reads

Managing Log Files Sizes the Easy Way

Learn an easy, rough, and ready way to manage log files in this piece.  Read more...
By Mark Roworth 2015/03/09 | Source: SQLServerCentral.com | Category: log files
Rating: |  Discuss |   Briefcase | 7,073 reads

Conrad Wolfram: Geek of the Week

Conrad Wolfram is the 'younger Wolfram' of Wolfram Research, the company behind Wolfram|Alpha and Mathematica. He wants to transform the way in which we engage with mathematics. In particular, he would like to reform mathematics education to make greater use of information technology, and he is also leading the way with interactive publishing technology.  Read more...
By Additional Articles 2015/03/09 | Source: SimpleTalk | Category: interview
Rating:  Rate this |   Briefcase | 6,287 reads

Fifty Words for Databases

Phil wonders whether it is our poor vocabulary about databases that has lead to the failure of developers and Operations people to understand each other on the topic of deployment.  Read more...
By Phil Factor 2015/03/09 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 144 reads
<< Newer    Items 41 to 60 of 13596    Older >>