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

Maps in SQL Server Reporting Services

Learn how to add maps to your Reporting Services reports with this article from expert Adam Aspin.  Read more...
By Adam Aspin 2015/04/13 | Source: | Category: reporting services (ssrs)
Rating: |  Discuss |   Briefcase | 5,905 reads

Pre-built or Ad Hoc

Steve Jones talks about the ad hoc nature of some NoSQL databases and whether that's something that most users want.  Read more...
By Steve Jones 2015/04/13 | Source: | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 106 reads

Don't exaggerate the difficulties of the RDBMS

Phil Factor argues that in learning about relational databases such as SQL Server, we should encourage people to "break a few pots".  Read more...
By Phil Factor 2015/04/13 | Source: | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 104 reads

Never Ignore a Sort Warning in SQL Server

It is always bad news if your SQL queries are having to use the SORT operator. It is worse news if you get a warning that sort operations are spilling onto TempDB. If you have a busy, slow TempDB, then the effect on performance can be awful. You should check your query plans to try to eliminate SORTs and never leave a SORT warning unheeded. Fabiano Amorim shows the range of ways of getting information on what is going on with a query that is doing a SORT and when requests are made for memory.  Read more...
By Additional Articles 2015/04/13 | Source: SimpleTalk | Category: sort
Rating:  Rate this |   Briefcase | 6,421 reads

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: | Category: dbas
Rating: |  Discuss |   Briefcase | 17,419 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,306 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: | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 141 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,221 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: | Category: ssrs
Rating: (not yet rated)  Rate this |   Briefcase | 7,140 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: | 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: | Category: stairway series
Rating: |  Discuss |   Briefcase | 1,909 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: | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 65 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,441 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,571 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: | Category: continuous integration
Rating: |  Discuss |   Briefcase | 5,809 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: | Category: deleting data
Rating:  Rate this |   Briefcase | 9,235 reads


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: | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 156 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: | 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: | Category: t-sql
Rating: |  Discuss |   Briefcase | 25,779 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 | 7,674 reads
<< Newer    Items 21 to 40 of 13654    Older >>