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

Live Query Statistics in SQL Server 2016

SQL Server 2016, which at the time of writing is in preview release CTP 2.1, has a great new feature called Live Query Statistics. In this article, Koen Verbeeck introduces the new feature which allows you to view a live execution plan of an active query, giving a fantastic opportunity for troubleshooting and debugging.   Read more...
By Additional Articles 2015/08/19
Rating: (not yet rated)  Rate this |   Briefcase | 2,723 reads

Byte Me: Corporate Oversight

You can count on this.  Read more...
By Bob Lang 2015/08/19 | Source: SQLServerCentral.com | Category: byte me
Rating: (not yet rated) |  Discuss |   Briefcase | 175 reads

Connect to Salesforce Data as a Linked Server

Use the TDS Remoting feature of the ODBC Driver to set up a linked server for Salesforce data.  Read more...
By Eric Madariaga 2015/08/18 | Source: SQLServerCentral.com | Category: salesforce
Rating: |  Discuss |   Briefcase | 3,668 reads

Getting the Measure of Your Application

The idea of ‘instrumenting’ an application often seems to puzzle application developers. Modern IDEs are so full of code-tracers, debuggers and profilers that developers seem to resent the idea that applications should be designed and developed so as to be measurable. Tony Davis looks at the issue.  Read more...
By Additional Articles 2015/08/18 | Source: SimpleTalk | Category: measurable applications
Rating:  Rate this |   Briefcase | 4,194 reads

Your Portfolio

Putting together a portfolio allows you the chance to showcase what you're good at doing. Steve Jones thinks this might be a good thing for technical people.  Read more...
By Steve Jones 2015/08/18 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 110 reads

Learning In-Memory OLTP

References and links to help you learn more about In-Memory OLTP tables  Read more...
By Site Owners 2015/08/17 | Source: SQLServerCentral.com | Category: in-memory oltp
Rating: (not yet rated) |  Discuss |   Briefcase | 2,459 reads

The Case of the Shrinking CFO, err Database

Shrink SQL Server databases quickly and with virtually no contention.  Read more...
By Edward Polley 2015/08/17 | Source: SQLServerCentral.com | Category: shrink
Rating: |  Discuss |   Briefcase | 3,732 reads

Mission Critical Deployments

Is a software deployment responsible for a plane crash? That's a scary thought.  Read more...
By Steve Jones 2015/08/17 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 94 reads

Nope to NoOps, No way to NoDBA

Phil Factor suspect the NoOps movement is dressing up some old mistakes in fancy new clothes.  Read more...
By Phil Factor 2015/08/17 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 196 reads

Free webinar: DLM Demo

Redgate’s Database Lifecycle Management solution ensures database changes made in development environments are always tested and reviewed before being deployed, and adds automation to the process. Find out how by joining Steve Jones, MVP and editor of SQLServerCentral, as he demonstrates the solution and shows why such an approach is essential if you want to release changes frequently.  Read more...
By Additional Articles 2015/08/17 (first published: 2015/08/11) | Source: Redgate | Category: dlm
Rating: (not yet rated)  Rate this |   Briefcase | 6,002 reads

MySQL Error Handling using the Signal and Resignal Statements

MySQL introduced the SIGNAL and RESIGNAL statements in version 5.5 to allow you to raise your own error conditions from stored procedures, triggers, and events. Rob Gravelle demonstrates how to utilize both.  Read more...
By Additional Articles 2015/08/17 | Source: Database Journal | Category: mysql
Rating: (not yet rated)  Rate this |   Briefcase | 1,499 reads

Stairway to MDX - Level 13: MDX Time/Date Series Functions: LastPeriods() and ParallelPeriod() Functions

BI Architect Bill Pearson continues with the third of a subseries surrounding a group of MDX functions we can use to support analysis and reporting in a time / date context. In this Level, we will explore the LastPeriods() and ParallelPeriod() functions, and get hands-on practice with each in meeting sample business requirements.  Read more...
By Bill Pearson 2015/08/14 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 1,863 reads

Free webinar: DLM Demo

Redgate’s Database Lifecycle Management solution ensures database changes made in development environments are always tested and reviewed before being deployed, and adds automation to the process. Find out how by joining Steve Jones, MVP and editor of SQLServerCentral, as he demonstrates the solution and shows why such an approach is essential if you want to release changes frequently.  Read more...
By Additional Articles 2015/08/17 (first published: 2015/08/11) | Source: Redgate | Category: dlm
Rating: (not yet rated)  Rate this |   Briefcase | 6,002 reads

How many environments?

This Friday Steve Jones looks at the setup for your software pipeline. He's wondering how complex it is with how many separated environments.  Read more...
By Steve Jones 2015/08/14 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 103 reads

Configure the SQL Server Integration Services For Loop Container

Dallas Snider looks at how you can configure the SQL Server Integration Services For Loop Container. He explores what options are available, how you can establish variables and how you can you test the process.  Read more...
By 2015/08/14 | Source: MSSQLTips.com | Category: integration services
Rating: (not yet rated)  Rate this |   Briefcase | 2,495 reads

The Tally Table

The tally table is a valuable tool for a SQL Server developer, but how many of you understand how to create and use one?  Read more...
By Steve Jones 2015/08/13 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 287 reads

Data Mining Part 31: DMX functions

In this chapter, we will learn how to use some DMX functions in our mining models.  Read more...
By Daniel Calbimonte 2015/08/13 | Source: SQLServerCentral.com | Category: data mining
Rating: (not yet rated) |  Discuss |   Briefcase | 1,724 reads

What is Database Lifecycle Management (DLM)?

When the different teams that are involved throughout the life of a database fail to reconcile their different roles and priorities, and so fail to cooperate or work adaptively, the result is gridlock: databases defined as though carved in stone rather than by code and data. William Brewer explores how DLM can offer an alternative that allows databases to respond quickly to business change.  Read more...
By Additional Articles 2015/08/13 | Source: SimpleTalk | Category: dlm
Rating: (not yet rated)  Rate this |   Briefcase | 5,461 reads

Free Webinar: Should your databases be Continuously Delivered?

If you want to learn more about Continuous Delivery, and where your databases fit into the picture, join Dave Farley on September 2nd for a webinar covering why databases are an essential component of CD, and how to start modernizing your software development practices.  Read more...
By Additional Articles 2015/08/31 (first published: 2015/08/13) | Source: Redgate | Category: webinar
Rating: (not yet rated)  Rate this |   Briefcase | 7,223 reads

Business Pressures

The business pressures can often change how we work, or even how we build our software. A few notes on Github from Steve Jones.  Read more...
By Steve Jones 2015/08/12 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 95 reads
<< Newer    Items 41 to 60 of 14041    Older >>