Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

<< Newer    Items 61 to 80 of 14742    Older >>
 

Execute Dynamic SQL commands in SQL Server

In some applications having hard coded SQL statements is not appealing, because of the dynamic nature of the queries being issued against the database server. Because of this sometimes there is a need to dynamically create a SQL statement on the fly and then run that command. This can be done quite simply from the application perspective where the statement is built on the fly whether you are using ASP.NET, ColdFusion or any other programming language. But how do you do this from within a SQL Server stored procedure?  Read more...
By Additional Articles 2016/05/03 | Source: MSSQLTips.com | Category: dynamic sql
Rating:  Rate this |   Briefcase | 5,047 reads

Buzzword Bingo

What uses of acronyms and phrases hinder instead of help?  Read more...
By Gary Varga 2016/05/02 | Source: SQLServerCentral.com | Category: communication
Rating: (not yet rated) |  Discuss |   Briefcase | 40 reads

Forcing SQL Agent Jobs to Fail When Remote Procedures Timeout

Your SQL Agent Jobs may be silently failing when using Linked Servers.  Read more...
By Chad Feghali 2016/05/02 | Source: SQLServerCentral.com | Category: sql agent
Rating: |  Discuss |   Briefcase | 1,261 reads

Install Cumulative Updates

This week Steve Jones recommends installing Cumulative Updates. If you can test them.  Read more...
By Steve Jones 2016/05/02 | Source: SQLServerCentral.com | Category: patching
Rating: (not yet rated) |  Discuss |   Briefcase | 43 reads

Announcing BIML Academy

Join Andy Leonard the week of May 9-13 for 5 free days of BIML training.   Read more...
By Press Release 2016/05/09 (first published: 2016/04/26) | Source: SQLServerCentral.com | Category: biml
Rating: (not yet rated)  Rate this |   Briefcase | 7,250 reads

Getting started with Azure SQL Data Warehouse

Azure SQL Data Warehouse is an obvious first-step towards migrating on-premise organisational data to the cloud. So how do you get started with it? Robert Sheldon provides a simple guide that should provide you with sufficient of the the basics you need to get a SQL Data Warehouse database up and running.  Read more...
By Additional Articles 2016/05/02 | Source: SimpleTalk | Category: azure
Rating: (not yet rated)  Rate this |   Briefcase | 2,581 reads

Stress Testing

It seems that one area many DBAs don't have much knowledge in is testing hardware.   Read more...
By Steve Jones 2016/04/29 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 90 reads

Create stunning visualizations with Power View in 20 minutes or less!

Learn about Microsoft’s latest end-user BI reporting tool, Power View, and create animated graphs that impress your boss!  Read more...
By Amir Charania 2016/04/29 (first published: 2014/12/30) | Source: SQLServerCentral.com | Category: power view
Rating: |  Discuss |   Briefcase | 11,976 reads

Write for SQLServerCentral - Bonus for Azure

We're always looking for articles, but here are a few ones that I'd like to see written up.  Read more...
By Site Owners 2016/04/29 (first published: 2014/09/04) | Source: SQLServerCentral.com | Category: sqlservercentral
Rating: (not yet rated) |  Discuss |   Briefcase | 1,917 reads

Questions About PowerShell Basics That You Were Too Shy To Ask

Developers who are already familiar with application languages will be baffled by different aspects of PowerShell to the beginner to programming. Laerte recalls his initial struggles with PowerShell and answers those questions he wished he'd found quick answers to.  Read more...
By Additional Articles 2016/04/29 | Source: SimpleTalk | Category: powershell
Rating:  Rate this |   Briefcase | 3,927 reads

Generate a SSIS-package that reads from Twitter using Biml

Learn how to use Biml to create a SSIS-package with a Script component that can read from Twitter.  Read more...
Rating: |  Discuss |   Briefcase | 1,717 reads

Losing All Traces of Data

Could someone remove data from all systems and backups?  Read more...
By Steve Jones 2016/04/28 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 90 reads

Azure SQL Database Elastic Database Jobs

In this article, Marcin Policht describes the basic functionality and implementation steps for Azure SQL Database's Elastic Database jobs.  Read more...
By Additional Articles 2016/04/28 | Source: Database Journal | Category: azure
Rating: (not yet rated)  Rate this |   Briefcase | 4,091 reads

Data Mining Part 38: Text Mining - The term lookup

In this new article, we will show how to use the SSIS term lookup transformation tool.   Read more...
By Daniel Calbimonte 2016/04/27 | Source: SQLServerCentral.com | Category: ssis
Rating: |  Discuss |   Briefcase | 1,106 reads

Cloud First

SQL Server 2016 is the first cloud first version of SQL Server being released as the on-premise product.  Read more...
By Steve Jones 2016/04/27 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 75 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 2016/04/27 (first published: 2013/07/30) | Source: Redgate | Category: execution plans
Rating:  Rate this |   Briefcase | 79,202 reads

How to change server level collation for a SQL Server Instance

Manvendra Singh explains step by step how to change the server level collation setting for an existing SQL Server instance.  Read more...
By Additional Articles 2016/04/27 | Source: MSSQLTips.com | Category: server-level collation
Rating: (not yet rated)  Rate this |   Briefcase | 2,934 reads

SQL Server Resource Governor

Using Resource Governor on a SQL Server that suffers from CPU contention thus allowing us specify limits on the amount of CPU that an incoming request can use.  Read more...
By Arun Sirpal 2016/04/26 | Source: SQLServerCentral.com | Category: resource governor
Rating: |  Discuss |   Briefcase | 1,430 reads

Specialist or Generalist

The idea of being a generalist of specialist may not need to be a choice.  Read more...
By Steve Jones 2016/04/26 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 102 reads

Announcing BIML Academy

Join Andy Leonard the week of May 9-13 for 5 free days of BIML training.   Read more...
By Press Release 2016/05/09 (first published: 2016/04/26) | Source: SQLServerCentral.com | Category: biml
Rating: (not yet rated)  Rate this |   Briefcase | 7,250 reads
<< Newer    Items 61 to 80 of 14742    Older >>