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

<< Newer    Items 61 to 80 of 13677    Older >>
 

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,955 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 | 121 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,082 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 | 318 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,283 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,853 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,262 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,946 reads

Microservices for Databases

The idea of using microservices is gaining traction, but Steve Jones notes that the issues of databases might prevent adoption for many applications.  Read more...
By Steve Jones 2015/04/02 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 123 reads

Get Your Service Broker Messages in Order. Always.

Learn how you can guarantee the ordering of all messages in a Service Broker queue, regardless of conversations.  Read more...
By Steve Jones 2015/04/01 | Source: SQLServerCentral.com | Category: service broker (sssb)
Rating: |  Discuss |   Briefcase | 2,024 reads

Time to Rebrand

I became a SQL guy back in 1998 because the company that hired me used SQL Server. It’s been a good ride and it’s paid the bills, but after 15 years or so it’s time to do something different.   Read more...
By Andy Warren 2015/04/01 | Source: Other | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 5,434 reads

Byte Me: Shifting Gear

The old ways are not always the best.  Read more...
By Bob Lang 2015/04/01 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 160 reads

Deploying the same database to many different RDBMSs

With the idea of a generic Dacpac defined by international standard, comes the potential for a Visual Studio developer to use SSDT to create a generic database model to a SQL-92 compliant standard that can then be deployed to any one of the major RDBMSs. The same database model would be deployable to Oracle, MySQL, or SQL Server, for example. Professor Hugh Bin-Haad explains the reasoning and technology behind this.  Read more...
By Additional Articles 2015/04/01 | Source: SimpleTalk | Category: humor
Rating:  Rate this |   Briefcase | 9,336 reads

Free eBook: SQL Server Transaction Log Management

When a SQL Server database is operating smoothly and performing well, there is no need to be particularly aware of the transaction log, beyond ensuring that every database has an appropriate backup regime and restore plan in place. When things go wrong, however, a DBA's reputation depends on a deeper understanding of the transaction log, both what it does, and how it works.  Read more...
By Press Release 2015/04/01 (first published: 2013/08/14) | Source: Redgate | Category: transaction logs
Rating:  Rate this |   Briefcase | 63,555 reads

Finally, a Universal Data Integration Utility

Earlier today, a revolutionary product was released: a universal data integration utility.   Read more...
By Tim Mitchell 2015/04/01 | Source: Other | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 5,815 reads

Source Code Security

The code you use may contain security information. Be extra careful in this case, especially when you use encryption.  Read more...
By Steve Jones 2015/03/31 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 104 reads

Shredding Unicode Japanese characters using SSIS

This articles describes two ways to shred Unicode Japanese character from xls files into SQL Server table using SSIS  Read more...
By Arun Mishra 2015/03/31 | Source: SQLServerCentral.com | Category: sql server
Rating: |  Discuss |   Briefcase | 506 reads

Getting Started with Database Engine Tuning Advisor in SQL Server – Part 2

Arshad Ali demonstrates how you can use the command line interface to tune SQL queries and how you can use SQL Server Profiler to capture the workload for tuning with Database Engine Tuning Advisor.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 8,669 reads

SQL Monitor Custom Metric: Hash Warnings (Last Hour)

This alert is raised when the number of hash warnings events in the last hour goes above a specified threshold. A hash warning event means that part of the data processed for a hash operation was written to tempdb during query execution, which can degrade SQL Server Performance.  Read more...
By Press Release 2015/03/31 | Source: Redgate | Category: sql monitor
Rating: (not yet rated)  Rate this |   Briefcase | 6,266 reads
<< Newer    Items 61 to 80 of 13677    Older >>