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

Welcome to SQLServerCentral.com

A Microsoft SQL Server community of 1,786,624 DBAs, developers and SQL Server users

Rss
Headlines today   March 6, 2015

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 | 14,929 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 | 1,396 reads
Previous headlines

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 | 2,447 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 | 2,837 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,090 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 | 41,738 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 | 3,715 reads

Data Warehouse to OData to Excel and R

How do you make data available to analysts who want to blend data with R or Power Query tools? Why with OData services.  Read more...
By Benjamin Seidle 2015/03/03 | Source: SQLServerCentral.com | Category: odata
Rating: |  Discuss |   Briefcase | 4,378 reads

Reviewing Logical Hard Drive details using T-SQL and OLE Automation Procedures

One of the most important SQL Server DBA tasks is checking logical hard drive details such as the total capacity, free disk space, and used space by the SQL Server data and log files. In this tip we look at a method to view this information in a faster and simpler way.  Read more...
By Additional Articles 2015/03/03 | Source: MSSQLTips.com | Category: ole automation
Rating: (not yet rated)  Rate this |   Briefcase | 3,724 reads

Silicon Valley - DLM Training Workshop – Database Continuous Integration

Learn how to do SQL Server continuous integration at the first in a new series of Database Lifecycle Management Training Workshops, in Silicon Valley on March 27. To celebrate the launch, places for this workshop are free.   Read more...
By Press Release 2015/03/03 | Source: Red-Gate | Category: events
Rating: (not yet rated)  Rate this |   Briefcase | 3,060 reads
 
Ask SQL Server Central



From the SQLServerCentral Blogs

DevOps, the DBA, and the word “No”

Check out this DevOps Reactions animated GIF and caption. It’s funny on multiple levels, but it also makes me both mad...  Read more...
By Grant Fritchey 2015/03/06 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,852 reads

T-SQL :- How to Search String in all Stored Procedures across All User Defined Databases

There are many different ways to accomplish this tasks. Download Link https://gallery.technet.microsoft.com/T-SQL-How-to-Search-String-a1704fc6 The below examples uses undocumented sp’s to loop through all the...  Read more...
By Prashanth Jayaram 2015/03/06 | Source: SQLServerCentral Blogs | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 2,074 reads
Question of the Day

Foreign Key Fun

By Tom Thomson 2015/03/06 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 585 reads

The following code is run


if exists (select * from sysobjects where name = 'junk' and xtype ='U')
drop table junk;
go
create table junk (
x int primary key clustered
);
insert junk(x)
select top 1000...  Read more...
Top Members (last 30 days)
# Name Score Level
30 days All-time
1.
Anshul Parmar
416 416 SSC-Addicted  
2.
patricklambin
322 2466 SSCrazy  
3.
rajasekhar.srs
317 318 Old Hand  
4.
Jeff Moden
271 36646 SSC-Dedicated  
5.
blablablablakokos
261 261 SSC Veteran  
Latest forum posts