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

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,966 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,570 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 | 7,078 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 | 208 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,179 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,675 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 | 225 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,131 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,355 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 | 148 reads

Upgrade and Refresh, or Not?

Today we have a guest editorial from Andy Warren that looks at the upgrade cycle and how that affects our jobs.  Read more...
By Andy Warren 2015/03/06 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 111 reads

How to Design, Build and Test a Dynamic Search Stored Procedure

Learn how to design, build and test a dynamic search SP in just a few simple but methodical steps.  Read more...
By Dwain Camps 2015/03/06 (first published: 2013/11/05) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 18,656 reads

Azure Blob Storage Part 6: Blob Properties, Metadata, etc.

After finding it difficult to find seriously useful information on Azure blob storage written after Storage Client Library 1.7 (and we’re on 4.something now), Robin Shahan decided to try and fill that gap with this article.  Read more...
By Additional Articles 2015/03/06 | Source: Just Azure | Category: blob storage
Rating: (not yet rated)  Rate this |   Briefcase | 5,280 reads

Measuring Career Growth

A guest editorial from Tim Mitchell today looks at keeping track of what we have done in our careers, and the value that it gives us.  Read more...
By Tim Mitchell 2015/03/05 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 367 reads

Data Mining Part 25: Microsoft Visio Add-Ins

In the chapter 18-22 we explained how to work with Microsoft Excel to Access to the Data Mining information. This time, we will explain how to work with Microsoft Visio.   Read more...
By Daniel Calbimonte 2015/03/05 | Source: SQLServerCentral.com | Category: data mining
Rating: |  Discuss |   Briefcase | 3,258 reads

Getting Starting with Database Engine Tuning Advisor in SQL Server – Part 1

There are different techniques to optimize the performance of SQL Server queries but wouldn’t it be great if we had some recommendations before we started planning or optimizing queries so that we didn’t have to start from the scratch every time? This is where you can use the Database Engine Tuning Advisor utility to get recommendations based on your workload.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 6,263 reads

Stairway to Database Source Control Level 3: Working With Others (Centralized Repository)

One of the main purposes of placing a database under source control, alongside the application code, is to allow team collaboration during development projects. The Version Control System (VCS) stores and manages all of the project files, maintaining an audit trail of what changed, and who made the change. Each team member can work on a file, or set of files, and submit their changes to the VCS to make them available to other team members. They can also inspect the VCS to discover recent changes made by other team members.  Read more...
By Dave Green 2015/03/04 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 2,698 reads

Byte Me: Waifs And Strays

Make it HR's problem.  Read more...
By Bob Lang 2015/03/04 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 365 reads

Free eBook: SQL Server Hardware

SQL Server Hardware will provide the fundamental knowledge and resources you need to make intelligent decisions about choice, and optimal installation and configuration, of SQL Server hardware, operating system and the SQL Server RDBMS.  Read more...
By Press Release 2015/03/04 (first published: 2013/07/24) | Source: Red-Gate | Category: hardware
Rating:  Rate this |   Briefcase | 45,328 reads

Questions About SQL Server Transaction Log You Were Too Shy To Ask

Tony Davis answers 10 surprisingly tricky questions about SQL Server Transaction Log.  Read more...
By Additional Articles 2015/03/04 | Source: SimpleTalk | Category: transaction log
Rating:  Rate this |   Briefcase | 7,902 reads
<< Newer    Items 61 to 80 of 13607    Older >>