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

Advice for Learning T-SQL SELECT Statement Step By Step

In this tip, Dallas Snider shares his experience with how someone can start learning T-SQL from the beginning with no prior knowledge.  Read more...
By Additional Articles 2015/02/09 | Source: | Category: learning
Rating: (not yet rated)  Rate this |   Briefcase | 8,190 reads

Performance of the SQL MERGE vs. INSERT/UPDATE

The SQL MERGE statement offers convenience, safety and elegance, but how does it perform compared to other methods?  Read more...
By Dwain Camps 2015/02/06 (first published: 2013/10/28) | Source: | Category: merge
Rating: |  Discuss |   Briefcase | 29,288 reads


Inspired by the movie with the same name, Steve Jones has a Friday poll about inspiration and ideas.  Read more...
By Steve Jones 2015/02/06 | Source: | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 192 reads

Release Testing Is Risk Management Theatre

The adoption of Continuous Delivery often leads to the discovery of suboptimal practices within an organisation, and the Release Testing antipattern is a common example. Steve Smith explores the questions: what is Release Testing, and why is it an example of Risk Management Theatre?  Read more...
By Additional Articles 2015/02/06 | Source: SimpleTalk | Category: release testing
Rating:  Rate this |   Briefcase | 6,355 reads

SQL Saturday #374 - Vienna, Austria

SQL Saturday is a full-day technical conference and training event with international speakers. With over 20 sessions on SQL Server and a separate pre-con, the event is aimed at all those interested in SQL Server - from pros to beginners. This event will be on February 28, 2015, so register while space is available.  Read more...
By Additional Articles 2015/02/06 | Source: SQL Saturday | Category: sql saturday
Rating: (not yet rated)  Rate this |   Briefcase | 5,668 reads

Interrupt Me, I'm Stagnating

Today we have a guest editorial from Andy Warren with a few hints on how you can continue to be proactive as a DBA.  Read more...
By Andy Warren 2015/02/05 | Source: | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 174 reads

How does a View work on a Table with a Clustered Columnstore Index ?

This article is about how a view works when it is created on a table with clustered columnstore index on it.  Read more...
By Ramya Makam 2015/02/05 | Source: | Category: clustered columnstore
Rating: |  Discuss |   Briefcase | 4,025 reads

How do you develop and deploy your database?

Could you spare 3 minutes to do us a quick favor? Redgate’s running this short survey on how our readers develop and deploy databases. It’s just 12 multiple choice questions, so if you’ve got a couple of minutes to spare, we’d love to hear from you.  Read more...
By Press Release 2015/02/26 (first published: 2015/02/05) | Source: Red-Gate | Category: deployment process
Rating: (not yet rated)  Rate this |   Briefcase | 12,367 reads

Microsoft Azure Storage Queues Part 3: Security and Performance Tips

After discussion the main concepts and basic API calls for Azure Storage Queues in parts 1 and 2 of this series, Roman Schacherl turns his focus to two topics that no one likes to implement but everybody needs: security and performance.  Read more...
By Additional Articles 2015/02/05 | Source: Just Azure | Category: queues
Rating: (not yet rated)  Rate this |   Briefcase | 6,106 reads

Stairway to SQL Server Security Level 6: Execution Context and Code Signing

A fundamental way that SQL Server determines whether a principal has the permissions necessary to execute code is with its execution context rules. It’s all complicated by the possibility that a principal has permission to execute code but doesn’t have permission on the underlying objects accessed by the code, such as the data in a table. This stairway level will explore SQL Server’s execution context, ownership chains, and impersonation, as well as show you how you can control access to data via T-SQL code.  Read more...
By Don Kiely 2015/02/04 | Source: | Category: stairway series
Rating: |  Discuss |   Briefcase | 2,015 reads

Byte Me: Reality TV

That's entertainment. 
By Bob Lang 2015/02/04 | Source: | Category: byte me
Rating: (not yet rated) |  Discuss |   Briefcase | 329 reads

Centralize Your Database Monitoring Process

SQL Server Data Collector, together with Management Data Warehouse, is a fine and useful component for gathering information centrally about how SQL Server instances are being used, and thereby keeping an eye out for problems. It comes into its own when you have figured out how to configure it to run on maybe hundreds of instances using Central Management Server. Dennes describes how to tame the system so that it scales.  Read more...
By Additional Articles 2015/02/04 | Source: SimpleTalk | Category: monitoring
Rating:  Rate this |   Briefcase | 6,864 reads

New SQL Monitor Custom Metric: Number of Unused Indexes

This metric can help if you want to monitor the number of indexes per database that haven't been used for the last month. Indexes that aren't in use should be removed because they can degrade INSERT, UPDATE and DELETE performance, and they use storage space.  Read more...
By Press Release 2015/02/04 | Source: Red-Gate | Category: sql monitor
Rating: (not yet rated)  Rate this |   Briefcase | 1,525 reads

It's OK to be an Outfitter, not a Prospector

As data professional I have played with Analytics and found I'm better suited to development and administration, and that's ok.  Read more...
Rating: |  Discuss |   Briefcase | 76 reads

Performance Improvement for Cursors in Stored Procedures

Exploring some differences between using cursors, local fast forward cursors and using set logic.  Read more...
By Brian Hibbert 2015/02/03 | Source: | Category: cursors
Rating: |  Discuss |   Briefcase | 8,427 reads

SQL Saturday #374 - Austria

SQL Saturday is holding its first event in Vienna on February 28, 2014. With over 20 sessions on SQL Server, the event is aimed at all those interested in SQL Server - from pros to beginners. Register while space is available.  Read more...
By Press Release 2015/02/03 | Source: SQL Saturday | Category: events
Rating: (not yet rated)  Rate this |   Briefcase | 5,056 reads

Managing the Big Data Technical Staff

Big data is everywhere, and most large IT enterprises have installed one or more big data applications. These applications provide fast access to large stores of data, usually customer or sales data. Your technical staff that supports these applications and the systems that analyze and consume the data didn't exist ten years ago. Who are these new IT professionals, and how should you manage them?  Read more...
By Additional Articles 2015/02/03 | Source: Database Journal | Category: management
Rating: (not yet rated)  Rate this |   Briefcase | 7,850 reads

Capture CREATE, DROP, ALTER from the default SQL trace file

Tracks and stores changes to database objects by reading from the default SQL server trace file using ::fn_trace_gettable()  Read more...
By MyDoggieJessie 2015/02/02 | Source: | Category: trace files
Rating: |  Discuss |   Briefcase | 4,061 reads

Expediency versus Best Practice!

Rumour has it that some grand old houses in the British Isles may be haunted. A SQL Server consultant spends a night in such a house musing over the use of T-SQL versus SSIS. The story is entirely fictitious and the article has been written pro bono and dedicated to the SQL Server community. For its interest, amusement and imagination.   Read more...
By Andrew Baker 2015/02/02 | Source: | Category: misc
Rating: |  Discuss |   Briefcase | 1,956 reads

Amazon's Aurora: A Distributed SQL Database Alternative For MySQL Applications

SQL-based distributed Cloud Relational databases aren't new, but Amazon's Aurora offers an alternative to SQL Azure, and, being MySQL-compatible, provides the obvious route to the cloud for hosted LAMP web applications.   Read more...
By Additional Articles 2015/02/02 | Source: SimpleTalk | Category: amazon
Rating:  Rate this |   Briefcase | 7,346 reads
<< Newer    Items 61 to 80 of 13517    Older >>