SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
<< Previous headlines | Later headlines >>
SQLServerCentral.com Headlines from 2013/12/08 to 2013/12/15

DAX Query - Part 2

A more detailed look at the DAX language and some of its more frequently used functions  Read more...
By Gary Strange 2013/12/13 (first published: 2013/05/02) | Source: SQLServerCentral.com | Category: dax
Rating: |  Discuss |   Briefcase | 8,214 reads

SQL Saturday #274 - Slovenia

SQL Saturday is coming to Slovenia on December 21, 2013. This is a free all-day training and networking event for SQL Server professionals.  Read more...
By Press Release 2013/12/13 | Source: SQL Saturday | Category: sql saturday
Rating: (not yet rated)  Rate this |   Briefcase | 2,657 reads

Model Based Testing at Red Gate

Phil Scrace, a test engineer at Red Gate, talks about adopting Model Based Testing (MBT), a technique that combines graph theory and code writing to help keep pace with frequently changing functionality.  Read more...
By Additional Articles 2013/12/13 | Source: SimpleTalk | Category: agile
Rating: (not yet rated)  Rate this |   Briefcase | 2,196 reads

DAX Query Basics

In this document I will attempt to talk you through writing your first very simple DAX queries. For the purpose of this document I will query the rather familiar Adventure Works Tabular Cube.   Read more...
By Gary Strange 2013/12/12 (first published: 2012/09/25) | Source: SQLServerCentral.com | Category: dax
Rating: |  Discuss |   Briefcase | 15,004 reads

Cambridge, UK - SQL in the City Seminar - Deployment Stairway

Grant Fritchey, SQL Server MVP will be hosting a free seminar in Cambridge on January 10 2014. Join fellow database professionals to learn tips and best practices for SQL Server version control, continuous integration and deployment.  Read more...
By Press Release 2013/12/12 | Source: SQL in the City | Category: sql in the city
Rating: (not yet rated)  Rate this |   Briefcase | 1,713 reads

How to find user who ran DROP or DELETE statements on your SQL Server Objects

Someone has dropped a table from your database and you want to track who did it. Or someone has deleted some data from a table, but no one will say who did. In this tip, we will look at how you can use the transaction log to track down some of this information.   Read more...
By Additional Articles 2013/12/12 | Source: MSSQLTips.com | Category: sql server objects
Rating:  Rate this |   Briefcase | 6,778 reads

Stairway to SQL Server Replication: Level 4 - Transactional Replication – The Subscriber

The Subscriber is the server where all the changes that are published by replication get delivered to. Every publication needs to have at least one subscriber, but a publication can have many subscribers. This level assumes that you have followed the first three levels and that you have a publication set up, to which you can subscribe.  Read more...
By Sebastian Meine 2013/12/11 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 9,361 reads

SQL Server 2012 AlwaysOn High Availability and Disaster Recovery Design Patterns

SQL Server 2012 AlwaysOn provides flexible design choices for selecting an appropriate high availability and disaster recovery solution for your application. This article looks at the common design patterns.  Read more...
By Additional Articles 2013/12/11 | Source: MSDN Communities | Category: always on
Rating:  Rate this |   Briefcase | 5,172 reads

Free eBook: Understanding SQL Server Concurrency

When you can’t get to your data because another application has it locked, a thorough knowledge of SQL Server concurrency will give you the confidence to decide what to do.  Read more...
By Press Release 2018/03/07 (first published: 2013/07/17) | Source: Redgate | Category: concurrency
Rating:  Rate this |   Briefcase | 93,904 reads

The Zero to N Parameter Problem (Sql Server 2005 and Up -- Update)

This article uses XML to deal with optional parameters along with multiple parameter passed into a stored procedure. (Note: We are re-running this as we had a newsletter issue last week)  Read more...
By Sloan Holliday 2013/12/16 (first published: 2013/12/10) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 7,192 reads

New SQL Monitor Custom Metric: Default TCP Port

This metric checks whether your SQL Server installation is using the default TCP port. It’s widely known that SQL Server 2005 and 2008 listen on TCP port 1433. Keeping this default gives hackers a potential way of attacking your server.  Read more...
By Press Release 2013/12/10 | Source: SQL Monitor Metrics | Category: sql monitor
Rating: (not yet rated)  Rate this |   Briefcase | 1,749 reads

PowerShell Data Basics: File-Based Data

One of the frustrations of anyone beginning with PowerShell is the simple task of getting data in and out. To help out with this, Michael Sorens begins a series that shows you how to import data from most of the common file formats and sources. He also shows how to export data in a range of formats.  Read more...
By Additional Articles 2013/12/10 | Source: SimpleTalk | Category: powershell
Rating:  Rate this |   Briefcase | 2,507 reads

Forum Etiquette: How to post data/code on a forum to get the best help

Get correct answers to your SQL forum questions faster by making it easier to load your sample data and read your code.  Read more...
By Jeff Moden 2013/12/10 (first published: 2007/11/27) | Source: SQLServerCentral.com | Category: best practices
Rating: |  Discuss |   Briefcase | 127,939 reads

Nominations open for the 2013 Tribal Awards

SQLServerCentral and Simple-Talk are co-hosting the Tribal Awards. Nominations open today for each of the 11 categories which recognize technical excellence, willingness to help the wider community, and exceptional SQL Karaoke skills.  Read more...
By Press Release 2013/12/09 | Source: SQLServerCentral.com | Category: awards
Rating: |  Discuss |   Briefcase | 467 reads

A few reflections on RBAR by a weary application developer

Follow the guidance of your DBA, but remember, he or she is from another land.  Read more...
By George Copeland 2013/12/09 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 6,847 reads

SQL Server Database Backup and Restore with Windows Azure Blob Storage Cloud Services using T-SQL Commands

SQL Server 2012 introduces a new feature to issues backups on the Windows Azure Blob Storage service directly and restore from there when needed. But how does it work and how to get started using T-SQL commands for backup and restore operation?   Read more...
By Additional Articles 2013/12/09 | Source: MSSQLTips.com | Category: backup and restore
Rating: (not yet rated)  Rate this |   Briefcase | 3,145 reads