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

<< Newer    Items 21 to 40 of 13103    Older >>
 

Monitoring Longest Running Transaction using SQL Server Agent Alerts

Step by Step guide to setup SQL Server Agent Alert for the proactive monitoring of Monitoring of Longest Running Transactions.  Read more...
Rating: |  Discuss |   Briefcase | 4,927 reads

Free PDF Booklet: 119 SQL Code Smells

Once you've done a number of SQL code-reviews, you'll be able to identify signs in the code that indicate all might not be well. These 'code smells' are coding styles that, while not bugs, suggest design problems with the code. In this PDF, Phil Factor's put together 119 of those code smells so you can see what to avoid and why.  Read more...
By Additional Articles 2014/09/25 | Source: SimpleTalk | Category: design
Rating:  Rate this |   Briefcase | 9,306 reads

SQL Saturday #333 - St. Louis, MO

SQL Saturday is coming to the St. Louis University Campus on Oct 11, 2014. SQL Saturday offers a full day of free SQL Server training and networking, some of the speakers at this event include Kathi Kellenberger, Stuart Ainsworth, and Abhishek Srivastava. If you're thinking of attending this event, please register while space is available.  Read more...
By Press Release 2014/09/25 (first published: 2014/09/05) | Source: SQL Saturday | Category: events
Rating: (not yet rated)  Rate this |   Briefcase | 10,766 reads

Level 1: What is "SQL Server AlwaysOn"?

Level 1 of the stairway looks at exactly what AO and FCI are  Read more...
By Perry Whittle 2014/09/24 | Source: SQLServerCentral.com | Category: fci
Rating: |  Discuss |   Briefcase | 6,380 reads

Byte Me: A Mother of a Problem

Board games.  Read more...
By Bob Lang 2014/09/24 | Source: SQLServerCentral.com | Category: byte me
Rating: |  Discuss |   Briefcase | 315 reads

Free eBook: Defensive Database Programming

Resilient T-SQL code is code that is designed to last, and to be safely reused by others. The goal of defensive database programming, the goal of this book, is to help you to produce resilient T-SQL code that robustly and gracefully handles cases of unintended use, and is resilient to common changes to the database environment.  Read more...
By Press Release 2014/09/24 (first published: 2013/08/28) | Source: Red-Gate | Category: defensive programming
Rating: (not yet rated)  Rate this |   Briefcase | 35,193 reads

10 things I learned about rapidly scaling websites with Azure

Troy Hunt takes a look at a website whose traffic literally increased 60-fold overnight. Interesting stuff happens when scale changes that dramatically, so he decided to share a few things he learned.  Read more...
By Additional Articles 2014/09/24 | Source: Troy Hunt | Category: azure
Rating: (not yet rated)  Rate this |   Briefcase | 5,698 reads

Copy a database between servers with one command

This tool is a helper for your daily work to copy easily databases between Servers/instances and do all the necessary stuff for you.  Read more...
By Roland Hangg 2014/09/23 | Source: SQLServerCentral.com | Category: copy database script
Rating: |  Discuss |   Briefcase | 13,103 reads

Testing in Production

The Apple fall keynote recently didn't work as planned, and it seems as though their systems weren't tested well enough.  Read more...
By Steve Jones 2014/09/23 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 168 reads

Importing Excel Data into SQL Server Via SSIS: Questions You Were Too Shy to Ask

Retrieving data from Excel, and importing it into SQL Server hasn't the same appeal or glamour as, for example, performing heroics with ill-performing queries. This could be why one hesitates before asking questions about how to do it. Rob Sheldon calms your private doubts and fears by answering those embarrassing questions.  Read more...
By Additional Articles 2014/09/23 | Source: SimpleTalk | Category: ssis
Rating: (not yet rated)  Rate this |   Briefcase | 8,651 reads

SQL Saturday #352 - Sydney

SQL Saturday is coming to Sydney, Australia on October 25, 2014. Join us down under for a free day of SQL Server training and networking. Register while space is available.  Read more...
By Press Release 2014/09/23 | Source: SQL Saturday | Category: events
Rating: (not yet rated)  Rate this |   Briefcase | 5,114 reads

Automate Yourself to a Coffee Break

A DBA should be working to automate their tasks, and find time to do things that are really important. Like keeping their coffee cup topped off :)  Read more...
By Steve Jones 2014/09/22 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 223 reads

Premature Optimisation

Learning how to tune a system is a bit of science and a bit of an art. Gail Shaw gives some guidelines on when you might want to tune and how to go about it so as not to unnecessarily undertake the effort.  Read more...
By Gail Shaw 2014/09/22 | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 4,426 reads

Watson Freemium

IBM has released a free version of its Watson service to help people perform analytics on their data.  Read more...
By Steve Jones 2014/09/22 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 81 reads

Prevent Confidential Data at the Application Layer from getting into SQL Server

In this tip Tim Smith looks at different approaches to stop confidential data from getting into the database.  Read more...
By Additional Articles 2014/09/22 | Source: MSSQLTips.com | Category: security
Rating: (not yet rated)  Rate this |   Briefcase | 6,446 reads

Hierarchies on Steroids #1: Convert an Adjacency List to Nested Sets

SQL Server MVP Jeff Moden shows us a new very high performance method to convert an "Adjacency List" to “Nested Sets” on a million node hierarchy in less than a minute and 100,000 nodes in just seconds. Not surprisingly, the "steroids" come in a bottle labeled "Tally Table".  Read more...
By Jeff Moden 2014/09/19 (first published: 2012/11/13) | Source: SQLServerCentral.com | Category: hierarchy
Rating: |  Discuss |   Briefcase | 14,340 reads

No Compelling Reason

Steve Jones wants to know if you have compelling reasons to upgrade or not upgrade this week.  Read more...
By Steve Jones 2014/09/19 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 98 reads

A TDD Journey: 3- Mocks vs. Stubs; Test Frameworks; Assertions; ReSharper Accelerators

Test-Driven Development (TDD) involves the repetition of a very short development cycle that begins with an initially-failing test that defines the required functionality, and ends with producing the minimum amount of code to pass that test, and finally refactoring the new code. Michael Sorens continues his introduction to TDD by implementing the first tests and introducing the topics of Test doubles; Test Runners, Constraints and Assertions.  Read more...
By Additional Articles 2014/09/19 | Source: SimpleTalk | Category: test driven development
Rating: (not yet rated)  Rate this |   Briefcase | 6,449 reads

The 10 (.5) Commandments for IT Professionals

A list of the commandments, or at least suggestions, that Simon Holzman sees as important for IT professionals.  Read more...
By Simon Holzman 2014/09/18 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 362 reads

Data Mining Part 17: Working with Reports

In this chapter, we will learn how to create Data Mining Reports using Reporting Services.  Read more...
By Daniel Calbimonte 2014/09/18 | Source: SQLServerCentral.com | Category: data mining
Rating: |  Discuss |   Briefcase | 2,941 reads
<< Newer    Items 21 to 40 of 13103    Older >>