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

Five Rules For Successful Conversations With DBAs

As a developer working with SQL Server, you'll need to work with DBAs at one point or another. Here are some easy ways to make those conversations go smoothly.  Read more...
By Joshua Feierman 2015/04/10 (first published: 2013/09/24) | Source: SQLServerCentral.com | Category: dbas
Rating: |  Discuss |   Briefcase | 17,351 reads

The Internet of Things: A New World Order?

Was the marketing hook 'The Internet of Things' conjured up before the technical definition? Are we being persuaded to spend money on fending off yet another fantasy tsunami of data? Already, we have televisions that listen to, and report, your conversations; so are we facing the Science Fiction future of gadgets that report where you go, who you visit and what medications you take? As Robert Sheldon says; "It's big, almost too big to get your arms around".  Read more...
By Additional Articles 2015/04/10 | Source: SimpleTalk | Category: iot
Rating:  Rate this |   Briefcase | 8,060 reads

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 | 139 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,159 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,032 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

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,885 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 | 64 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,272 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 | 8,365 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,755 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 | 8,993 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 | 153 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,710 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: (not yet rated)  Rate this |   Briefcase | 7,551 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 | 116 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 | 311 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,025 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,585 reads
<< Newer    Items 21 to 40 of 13650    Older >>