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

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,257 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,847 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,214 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,897 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

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

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,017 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 | 159 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,325 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: Red-Gate | Category: transaction logs
Rating:  Rate this |   Briefcase | 63,553 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,814 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 | 505 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,662 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: Red-Gate | Category: sql monitor
Rating: (not yet rated)  Rate this |   Briefcase | 6,265 reads

Obedience Training For Databases: Cascading Constraints

In which Phil Factor illustrates in TSQL how it is possible to use foreign key constraints to enforce data rules, and illustrates some surprising consequences of using cascading.  Read more...
By Phil Factor 2015/03/30 | Source: SQLServerCentral.com | Category: constraints
Rating: |  Discuss |   Briefcase | 2,716 reads

Identifying and Solving Index Scan Problems

When you're developing database applications, it pays to check for index scans in the SQL Server query plan cache. Once you've identified the queries, what next? Dennes Torres gives some preliminary guidelines on how to find out why these index scans are being chosen for these queries and how to make the queries run faster and more efficiently.  Read more...
By Additional Articles 2015/03/30 | Source: SimpleTalk | Category: query plan
Rating:  Rate this |   Briefcase | 8,501 reads

Software Engineering in Practice

Is there a need for apprenticeships in the data world? Should we consciously seek to view our first year as an apprenticeship? Should companies provide learning paths for new hires?  Read more...
By Steve Jones 2015/03/30 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 112 reads

One Rule, Umpteen Constraints

Despite being deprecated for many years, Phil Factor explains why RULEs are still hanging on in there in SQL Server 2014.  Read more...
By Phil Factor 2015/03/30 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 74 reads
<< Newer    Items 61 to 80 of 13673    Older >>