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

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 | 12,758 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,711 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 | 119 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,166 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 | 1,974 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 | 149 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 | 8,992 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,237 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,550 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 | 103 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 | 501 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,365 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 | 5,998 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,650 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,160 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 | 107 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 | 73 reads

Cumulative sum of previous rows

I had an update statement that took 3 minutes to run after this code change it took 6 seconds.  Read more...
By Ben Kubicek 2015/03/27 (first published: 2014/05/08) | Source: SQLServerCentral.com | Category: cumulative
Rating: |  Discuss |   Briefcase | 14,336 reads

SSMS or SSDT

The question this week deals with tools. Steve Jones is looking to see which tools are preferred by most database developers.  Read more...
By Steve Jones 2015/03/27 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 236 reads

Azure Blob Storage Part 9: Shared Access Signatures

In this article, Robin Shahan talks about security and how to control access to containers and blobs using shared access signatures (SAS) and stored access policies.   Read more...
By Additional Articles 2015/03/27 | Source: Just Azure | Category: blob storage
Rating: (not yet rated)  Rate this |   Briefcase | 6,854 reads
<< Newer    Items 41 to 60 of 13650    Older >>