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

Welcome to SQLServerCentral.com

A Microsoft SQL Server community of 1,792,541 DBAs, developers and SQL Server users

Rss
Headlines today   April 1, 2015

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 | 452 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: (not yet rated)  Rate this |   Briefcase | 1,537 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 | 58,051 reads
Previous headlines

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 | 345 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 | 4,845 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 | 3,017 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,223 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 | 5,952 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 | 13,963 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 | 5,430 reads
 
Ask SQL Server Central



From the SQLServerCentral Blogs

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 | 1,089 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 | 1,236 reads
Question of the Day

April 1 2015, a space oddity

By T. Allums 2015/04/01 | Category: foolishness
Rating: (not yet rated) |  Discuss |   Briefcase | 430 reads

If a chicken and a half can lay an egg and a half in a day and a half, how long would it take a monkey with a wooden leg...  Read more...
Top Members (last 30 days)
# Name Score Level
30 days All-time
1.
ArnoKwetters
604 604 SSChasing Mays  
2.
zzalina0
437 1059 Ten Centuries  
3.
patricklambin
310 2707 SSCrazy  
4.
Jeff Moden
280 36877 SSC-Dedicated  
5.
Aishwarya_S
240 321 Old Hand  
Latest forum posts