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

After Six Months On The Job What Challenges Remain?

Today we have a guest editorial from Andy Warren that asks what you might do when you get settled at a new job.  Read more...
By Andy Warren 2015/04/10 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 155 reads

Cardinality Estimator – What’s new in SQL Server 2014

SQL Server 2014 has introduced a rebuilt Cardinality Estimator (CE) with new algorithms. Which are the biggest differences between the new CE and the previous one? Which one works better? Read more to find out.  Read more...
Rating: |  Discuss |   Briefcase | 5,344 reads

State v Migrations

Steve Jones talks a bit about the difference between state based and migrations based approaches for deployment.  Read more...
By Steve Jones 2015/04/09 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 84 reads

Creating a multi-option parameter report for SQL Server Reporting Services

If you have a reporting requirement where users want to enter report parameters by either selecting values from a dropdown list or entering To and From range values, Ghanesh Prasad explains how to accomplish this in a Reporting Services report?.  Read more...
By Additional Articles 2015/04/09 | Source: MSSQLTips.com | Category: ssrs
Rating: (not yet rated)  Rate this |   Briefcase | 7,563 reads

Stairway to SQL Server Security Level 7: Security Across Databases with Cross-Database Ownership Chaining

Sometimes you need to reach outside a database and access data and objects from multiple databases, which raises some security issues and increases the complexity of data access. In this stairway level, you’ll learn about cross-database ownership chaining so that you can reach across database boundaries securely.  Read more...
By Don Kiely 2015/04/08 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 1,993 reads

Release Wednesday

One of the teams at Red Gate is releasing new changes every Wednesday, which reminds Steve Jones of a time earlier in his career.  Read more...
By Steve Jones 2015/04/08 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 66 reads

Free eBook: Performance Tuning with SQL Server Dynamic Management Views

Dynamic Management Views (DMVs) are a significant and valuable addition to the DBA's troubleshooting armory, laying bare previously unavailable information regarding the under-the-covers activity of your database sessions and transactions.  Read more...
By Additional Articles 2015/04/08 (first published: 2013/08/21) | Source: Red-Gate | Category: performance tuning
Rating:  Rate this |   Briefcase | 57,951 reads

Painless Refactoring of SQL Server Database Objects

Refactoring a database object can often cause unexpected behavior in the code that accesses that object. In this article, adapted from his excellent book, Defensive Database Programming with SQL Server, Alex Kuznetsov discusses several techniques that will harden your code, so that it will not break, or behave unpredictably, as a result such changes.  Read more...
By Additional Articles 2015/04/08 | Source: SimpleTalk | Category: database objects
Rating:  Rate this |   Briefcase | 9,110 reads

What is Database Continuous Integration?

This is an introductory article to explain what Continuous Integration (CI) is and how it can be used in database development.  Read more...
By Steve Jones 2015/04/07 | Source: SQLServerCentral.com | Category: continuous integration
Rating: |  Discuss |   Briefcase | 5,907 reads

Deleting Historical Data from a Large Highly Concurrent SQL Server Database Table

In this tip, Daniel Farina explains an unconventional way of deleting millions of old records from a table which is accessed by a system 24x7, and without impacting that system.  Read more...
By Additional Articles 2015/04/07 | Source: MSSQLTips.com | Category: deleting data
Rating:  Rate this |   Briefcase | 9,576 reads

Kanban

Steve Jones talks about organizing and tracking work with kanban and how that might help you.  Read more...
By Steve Jones 2015/04/07 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 160 reads

Your Cloud Held Hostage – Could It Happen?

Today's guest editorial by Andy Warren is more of a movie plot than reality, but perhaps it's worth considering.  Read more...
By Andy Warren 2015/04/06 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 111 reads

A Hazard of Using the SQL Update Statement

If you've never encountered this quirk of the SQL UPDATE statement, you should take a look and find a simple way around it.  Read more...
By Dwain Camps 2015/04/06 (first published: 2013/09/09) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 25,920 reads

Introduction to SQL Server Spatial Data

More and more applications require the handling of geospatial data. It is easy to store spatial data, but it takes rather more thought to retrieve and manipulate it. Tasks like searching neighborhoods, and calculating distances between points is often required from databases. But how do you start? Roy and Surenda take you through the basics.  Read more...
By Additional Articles 2015/04/06 | Source: SimpleTalk | Category: spatial data
Rating:  Rate this |   Briefcase | 8,068 reads

The Devil's in the Details

This week Steve Jones notes that the little details can sometimes have a big impact in your code.  Read more...
By Steve Jones 2015/04/06 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 120 reads

Large Chunks of Data

This Friday Steve Jones talks reporting. Specifically he wonders how long can a report be before it's just wasting space.  Read more...
By Steve Jones 2015/04/03 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 316 reads

Calculating Duration Using DATETIME Start and End Dates (SQL Spackle)

It's an old problem with a solution that's nearly as old. SQL Server MVP Jeff Moden shows us the old trick mixed with a slick trick to format the duration as extended hours, minutes, seconds, and milliseconds.   Read more...
By Jeff Moden 2015/04/03 (first published: 2014/01/16) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 19,235 reads

Azure Active Directory - Schema Extensions

The Azure Active Directory Graph API enables some interesting scenarios that you can implement in your applications by enabling you to query and manipulate directory objects in Azure AD. In this article, Rick Rainey provides a clear walkthrough of its implementation.  Read more...
By Additional Articles 2015/04/03 | Source: Just Azure | Category: active directory
Rating: (not yet rated)  Rate this |   Briefcase | 5,846 reads

Using APPLY to make your queries DRYer

Using the APPLY operator to reduce repetition and make queries DRYer.  Read more...
By Gerald Britton 2015/04/02 | Source: SQLServerCentral.com | Category: queries
Rating: |  Discuss |   Briefcase | 13,178 reads

A More Versatile SQL Server Random Number Function

Image a situation when you use the SQL Server RAND() T-SQL function as a column in a SELECT statement, and the same value is returned for every row as shown below. In this tip, Dallas Snider explains how you can get differing random values on each row.  Read more...
By Additional Articles 2015/04/02 | Source: MSSQLTips.com | Category: random numbers
Rating:  Rate this |   Briefcase | 8,894 reads
<< Newer    Items 41 to 60 of 13668    Older >>