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

Making Data Analytics Simpler: SQL Server and R

R an SQL Server are a match made in heaven. You don't need anything special to get started beyond the basic instructions. Once you have jumped the hurdle of reliably and quickly transferring data between R and SQL Server you are ready to discover the power of a relational database when when combined with statistical computing and graphics.  Read more...
By Additional Articles 2015/05/11 | Source: SimpleTalk | Category: data analtyics
Rating: (not yet rated)  Rate this |   Briefcase | 7,226 reads

Database Source Control Workshop: Philadelphia, PA

Redgate and Ike Ellis are hosting a database source control workshop in Philadelphia PA, on June 4, 2015. Learn all you need to put your development databases in source control, using the version control system of your choice. Register while space is available.  Read more...
By Press Release 2015/05/11 | Source: Redgate | Category: events
Rating: (not yet rated)  Rate this |   Briefcase | 4,213 reads

Temporary Stored Procedures

Temporary Stored Procedures - little known sql server feature  Read more...
By Harsha Majety 2015/05/08 (first published: 2013/06/25) | Source: SQLServerCentral.com | Category: temporary stored procedures.
Rating: |  Discuss |   Briefcase | 28,325 reads

How Virtualized?

This week's poll asks about virtualization in your environment. Let us know if you are moving your SQL Server to virtual machines.  Read more...
By Steve Jones 2015/05/08 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 117 reads

RESTful SignalR Service

This article explains how to expose SignalR feature through an ASP.NET Web API, which helps applications that can use REST service and to broadcast a real time message to their clients.  Read more...
By Additional Articles 2015/05/08 | Source: CodeProject.com | Category: rest api
Rating: (not yet rated)  Rate this |   Briefcase | 7,112 reads

How do you work with databases?

How do you use SQL Server, and how do you expect this to change next year? Fill in Redgate's survey by May 15 and enter a prize draw to win one of 4 $50 Amazon vouchers.  Read more...
By Press Release 2015/05/12 (first published: 2015/05/05) | Source: Redgate | Category: survey
Rating: (not yet rated)  Rate this |   Briefcase | 16,527 reads

Tips to Optimize Your SQL Statements - Part 2

Read more tips to optimize SQL statements, specifically on a Data warehouse.  Read more...
By Brian Ellul 2015/05/07 | Source: SQLServerCentral.com | Category: sql server 2014
Rating: |  Discuss |   Briefcase | 10,350 reads

vNext 2016

Steve Jones looks at the next version of SQL Server, SQL Server 2016. Until this week, it was known as vNext.  Read more...
By Steve Jones 2015/05/07 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 156 reads

Alan Cooper: Geek of the Week

Alan Cooper helped to debug the most widely-used PC language of the late seventies and early eighties, BASIC-E, and, with Keith Parsons, developed C-BASIC. He then went on to create Tripod, which morphed eventually into Visual Basic in 1991. Alan remains enthusiastic and interested in development with strong views on Agile and Pair Programming.  Read more...
By Additional Articles 2015/05/07 | Source: SimpleTalk | Category: interview
Rating:  Rate this |   Briefcase | 6,347 reads

Stairway to Advanced T-SQL Level 4: Record Level Processing Using Transact-SQL Cursors

Using a CURSOR is not normally the best way to process through a set of records. Yet when a seasoned programmer moves to writing TSQL for the first time they frequently look for ways to process a sets of records one row at a time. They do this because they are not used to thinking about processing records as a set. In order to process through a TSQL record set a row at a time you can use a cursor. A cursor is a record set that is defined with the DECLARE CURSOR statement. Cursors can be defined as either read-only or updatable. In this article I will introduce you to using cursors to do record level processing one row at a time.   Read more...
By Gregory Larsen 2015/05/06 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 4,040 reads

SQL Monitor Custom Metric: Plan Cache; Cache Pages Total

This metric collects the number of 8-kilobyte pages that make up the plan cache to help identify memory pressure or plan cache pollution. A sudden drop in values for this metric may indicate that the instance is under memory pressure and SQL Server had to reclaim part of the plan cache for other use.  Read more...
By Press Release 2015/05/06 | Source: Redgate | Category: sql monitor
Rating: (not yet rated)  Rate this |   Briefcase | 5,739 reads

Idempotent

There are all sorts of coding practices that produce better code. Steve Jones talks about one today.  Read more...
By Steve Jones 2015/05/06 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 123 reads

Generating A Password in SQL Server with T-SQL from Random Characters

Dallas Snider explains how to use T-SQL to generate a random password that meets an organization's password requirements.  Read more...
By Additional Articles 2015/05/06 | Source: MSSQLTips.com | Category: password
Rating:  Rate this |   Briefcase | 6,303 reads

Can Auditing Fail?

It doesn't seem to be a feature that an auditing system can fail, but the application being audited continues to run.  Read more...
By Steve Jones 2015/05/05 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 74 reads

DDL Auditing using the Default trace

This article explains how default trace can be used for auditing purposes when combined with PowerShell scripts  Read more...
By Nagaraj Venkatesan 2015/05/05 | Source: SQLServerCentral.com | Category: audit
Rating: |  Discuss |   Briefcase | 2,507 reads

Time Slots - An Essential Extension to Calendar Tables

After answering many forum entries from developers asking for help with dealing with SQL that involved time intervals and ranges, Dwain dreamed of a generalized tool that sets up time slots of various sorts without the need to experiment; that could do the heavy lifting, so that developers could do aggregations and reports based on time intervals without the hard graft. Here is Dwain's dream made reality.  Read more...
By Additional Articles 2015/05/05 | Source: SimpleTalk | Category: calendar table
Rating:  Rate this |   Briefcase | 6,204 reads

How do you work with databases?

How do you use SQL Server, and how do you expect this to change next year? Fill in Redgate's survey by May 15 and enter a prize draw to win one of 4 $50 Amazon vouchers.  Read more...
By Press Release 2015/05/12 (first published: 2015/05/05) | Source: Redgate | Category: survey
Rating: (not yet rated)  Rate this |   Briefcase | 16,527 reads

How to FTP a Dynamically Named Flat File

Learn how you can dynamically name a file in SSIS and then send it using the FTP task.  Read more...
Rating: |  Discuss |   Briefcase | 5,522 reads

MongoDB vs. Azure DocumentDB

There’s a new kid on the block in the NoSQL world – Azure DocumentDB. Released in preview back in August 2014 and going Generally Available this month, Azure DocumentDB is Microsoft’s initial foray into the increasingly competitive space of non-relational database management systems. Of course there is no better competitor in this space to measure up against than MongoDB. How close does DocumentDB stack up to MongoDB? Are they even close?  Read more...
By Additional Articles 2015/05/04 | Source: Just Azure | Category: nosql
Rating: (not yet rated)  Rate this |   Briefcase | 8,130 reads

Complete Definitions

When we write scripts, we often assume many settings will be at some default value. When we generate scripts, that's not the case. Perhaps we should be sure that we always include the settings we expect.  Read more...
By Steve Jones 2015/05/04 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 108 reads
<< Newer    Items 41 to 60 of 13750    Older >>