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

<< Newer    Items 21 to 40 of 13589    Older >>
 

Mail Fails with SQLCMD Error

I had a SQL Server job that kept failing with sqlcmd error and this describes how I resolved it.  Read more...
By Ramya Makam 2015/03/19 | Source: SQLServerCentral.com | Category: sqlcmd
Rating: |  Discuss |   Briefcase | 2,405 reads

How to get Database Design Horribly Wrong

Database Design is one of those tasks where you have to carefully get all the major aspects right. If you mess-up just one of these, it can all go horribly wrong. So what are these aspects that can ruin database design, and how can you get them right? Robert Sheldon explains.  Read more...
By Additional Articles 2015/03/19 | Source: SimpleTalk | Category: database design
Rating:  Rate this |   Briefcase | 11,221 reads

SQL Saturday #364 - Boston, MA

SQL Saturday is coming to Boston on April 18th 2015. Join us for a free day of SQL Server training and networking, and listen to great speakers like Grant Fritchey, Brent Ozar, and Andy Leonard. Register while space is available.  Read more...
By Press Release 2015/03/19 | Source: SQL Saturday | Category: events
Rating: (not yet rated)  Rate this |   Briefcase | 4,542 reads

Stairway to Advanced T-SQL Level 3: Understanding Common Table Expressions (CTEs)

A CTE is a temporary result set defined by a simple query, and is used within the execution scope of a single INSERT, UPDATE, DELETE, or SELECT statement. In this article we will explore how to define and use CTE's.  Read more...
By 2015/03/18 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 8,146 reads

Byte Me: Shrinking Transactions

The editorial cartoon for 18 March 2015.  Read more...
By Bob Lang 2015/03/18 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 514 reads

Free eBook: Fundamentals of SQL Server 2012 Replication

Fundamentals of SQL Server 2012 Replication provides a hands-on introduction to SQL Server replication. The book introduces you to the technologies that make up replication, and then walks you through setting up different replication scenarios. When you've finished reading, you should be able to implement your own multi-server replication setup while following the principle of least privilege.  Read more...
By Press Release 2015/03/18 (first published: 2014/02/26) | Source: Red-Gate | Category: replication
Rating:  Rate this |   Briefcase | 37,302 reads

Using the ROLLUP, CUBE, and GROUPING SETS Operators

Greg Larsen discusses the ROLLUP, CUBE and GROUPING SETS operators. These operators are used with the GROUP BY clause and allow you to create subtotals, grand totals and superset of subtotals. Read on to find out more about these additional GROUP BY operators.  Read more...
By Additional Articles 2015/03/18 | Source: Database Journal | Category: group by
Rating: (not yet rated)  Rate this |   Briefcase | 8,581 reads

Small Experiments in Data

Amsterdam is using data to try and improve their city.  Read more...
By Steve Jones 2015/03/17 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 119 reads

The Right and Wrong of T-SQL DML TRIGGERs (SQL Spackle)

Triggers in T-SQL have many uses. There are right and wrong ways to write triggers. To learn the difference, read on...  Read more...
By Dwain Camps 2015/03/17 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 5,584 reads

What is Behaviour Driven (Database) Development?

Behaviour Driven Development (BDD) is not always clearly understood, and the term is particularly unfamiliar in database circles. Seb Rose introduces us to the fundamentals of BDD, and make some suggestions for how it might be relevant to database development.  Read more...
By Additional Articles 2015/03/17 | Source: SimpleTalk | Category: agile database techniques
Rating:  Rate this |   Briefcase | 6,528 reads

Converting to data-driven code

How converting extensive, repetitive code to a data-driven approach resolved a maintenance headache and helped identify bugs  Read more...
By Mike Tanner 2015/03/16 | Source: SQLServerCentral.com | Category: sql
Rating: |  Discuss |   Briefcase | 5,914 reads

Try It

Grant Fritchey asks you to experiment, to make an effort, to just try it.  Read more...
By Grant Fritchey 2015/03/16 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 119 reads

SQL Saturday #387 - Madison, WI

SQL Saturday is coming to Madison, Wisconsin on April 11th 2015. Join us for a free day of SQL Server training and networking and hear expert speakers like David Klee, Wendy Pastrick, and Jes Borland. Register while space is available.  Read more...
By Press Release 2015/03/16 | Source: SQL Saturday | Category: events
Rating: (not yet rated)  Rate this |   Briefcase | 4,005 reads

Calculate the Statistical Mode in SQL Server using T-SQL

Next to the average and the median, there is another statistical value that you can calculate over a set: the mode. This is the value that appears the most often in the set. The average and the median are straight forward to calculate with T-SQL in SQL Server, but how can we determine the mode using T-SQL?  Read more...
By Additional Articles 2015/03/16 | Source: MSSQLTips.com | Category: statistical modeling
Rating:  Rate this |   Briefcase | 4,903 reads

Computational Biologist

A job Steve Jones has never heard of is using data to improve medical treatments.  Read more...
By Steve Jones 2015/03/16 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 84 reads

The Worst Comments

Comments in code can be tricky, but certainly some are better than others. What are your bad examples?  Read more...
By Steve Jones 2015/03/13 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 235 reads

Setting Different Colors for Connections in SSMS

Learn how to set colors for different connections in SSMS.  Read more...
By Peter Schott 2015/03/13 (first published: 2013/09/17) | Source: SQLServerCentral.com | Category: management studio (ssms)
Rating: |  Discuss |   Briefcase | 18,719 reads

Defusing Database Time Bombs: Avoiding the Need to Refactor Databases

Where applications are evolved by gradually molding them to a growing understanding of the business domain, this presents great challenges to database development. If databases are designed too loosely, and initial errors are allowed to fester, the results become harder and harder to refactor until eventually they constitute a database time bomb. Thomas LeBlanc describes how to avoid a few basic, but very common, database time bombs.  Read more...
By Additional Articles 2015/03/13 | Source: SimpleTalk | Category: database design
Rating:  Rate this |   Briefcase | 6,455 reads

Data Breach Danger

Is a data breach a danger to those identified in the data. A court says no, but Steve Jones wonders if this is a bad decision.  Read more...
By Steve Jones 2015/03/12 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 110 reads

Data Mining Part 26: Data Mining and Microsoft Azure

This article shows a step by step tutorial to create a virtual machine in 15 min on Windows Azure.   Read more...
By Daniel Calbimonte 2015/03/12 | Source: SQLServerCentral.com | Category: microsoft
Rating: |  Discuss |   Briefcase | 1,571 reads
<< Newer    Items 21 to 40 of 13589    Older >>