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

Software Projects: the important boring bits

Phil Factor on the sort of boring expertise that will help you thrive as a consultant.  Read more...
By Phil Factor 2014/12/08 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 90 reads

Scripting SQL Server databases with SMO using EnforceScriptingOptions

Obscure impact of switch EnforceScriptingOptions to scripting a SQL Server database.  Read more...
By Johan Bijnens 2014/12/08 | Source: SQLServerCentral.com | Category: sqlserver
Rating: |  Discuss |   Briefcase | 2,207 reads

How to troubleshoot SSL encryption issues in SQL Server

Tibor Nagy explains how to find the root cause of SSL encryption configuration problems in Microsoft SQL Server.  Read more...
By Additional Articles 2014/12/08 | Source: MSSQLTips.com | Category: ssl
Rating: (not yet rated)  Rate this |   Briefcase | 5,006 reads

Overcoming Proposal Objections

We have all had our innovative solutions and proposals shot down by leads, managers and directors. This article addresses some of the causes and tips to improving the success rate for getting your ideas into the priority list.  Read more...
By Eric Notheisen 2014/12/05 | Source: SQLServerCentral.com | Category: management
Rating: |  Discuss |   Briefcase | 87 reads

What, When and who? Auditing 101

In this article we will take a look at one of the new technology that was introduced in SQL Server 2008 for Auditing.   Read more...
By Roy Ernest 2014/12/05 (first published: 2011/11/28) | Source: SQLServerCentral.com | Category: auditing
Rating: |  Discuss |   Briefcase | 14,739 reads

SQL Server Developer tools survey

Participate in an online survey on SQL Server Developer Tools for a chance to win one of ten $100 Amazon vouchers.  Read more...
By Press Release 2014/12/09 (first published: 2014/12/05) | Source: SQLServerCentral.com | Category: survey
Rating: (not yet rated)  Rate this |   Briefcase | 12,543 reads

Webinar: Performance Tuning .NET & SQL Code Using ANTS Performance Profiler

In this LIDNUG webinar, Mitchel Sellers walks through performance tuning best practices, and investigates how developers can use ANTS Performance Profiler to explore their application code and the SQL queries and execution plans behind it.   Read more...
By Press Release 2014/12/05 | Source: Red-Gate | Category: performance tuning
Rating: (not yet rated)  Rate this |   Briefcase | 6,124 reads

The SQL Scrabble Puzzle

An enhancement to a Phil Factor puzzle gives you a chance to play scrabble in T-SQL.  Read more...
By Additional Articles 2014/12/05 | Source: Other | Category: contest
Rating:  Rate this |   Briefcase | 6,504 reads

Monitor Database Growth and Usage

Create a repository of all your database devices and stay informed about changes in their size and usage.  Read more...
By Willem Gossink 2014/12/04 | Source: SQLServerCentral.com | Category: monitoring
Rating: |  Discuss |   Briefcase | 6,130 reads

What Have You Learned Lately?

Have you learned anything new lately? Steve Jones asks the question after an interesting T-SQL Tuesday.  Read more...
By Steve Jones 2014/12/04 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 134 reads

The Big Database Freeze

When a hospital’s mission-critical database fails at Christmas, disaster for the hospital – and its hapless DBA – seems certain. With less than an hour to spare before catastrophe, can the DBA Team save the day? This is a fictionalized true story.  Read more...
By Additional Articles 2014/12/04 | Source: Red-Gate | Category: verify
Rating: (not yet rated)  Rate this |   Briefcase | 8,601 reads

SQL Server Survey

How do you use SQL Server, and how do you expect this to change next year? Fill in our survey, and enter a prize draw to win Amazon vouchers.  Read more...
By Press Release 2014/12/11 (first published: 2014/12/02) | Source: Red-Gate
Rating:  Rate this |   Briefcase | 17,047 reads

Stairway to SQL Server Security Level 5: Schemas and Security

In this stairway level you’ll learn how you can give principals access to groups of objects by assigning permissions on schemas instead of individual tables, code modules, and other objects. You’ll also learn about the benefits of user-schema separation and how it can increase object security, and how using default schemas for users and groups can simplify object access management and security.  Read more...
By Don Kiely 2014/12/03 | Source: SQLServerCentral.com
Rating: |  Discuss |   Briefcase | 2,742 reads

Always Canary

One way to make deployments smoother is to use a second system, but that's a challenge for databases, as Steve Jones notes.  Read more...
By Steve Jones 2014/12/03 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 84 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/12/03 (first published: 2013/08/28) | Source: Red-Gate | Category: defensive programming
Rating: (not yet rated)  Rate this |   Briefcase | 43,683 reads

Bitwise Operations in T-SQL

How can you get a list of columns that have changed within a trigger in T-SQL? How can you see what bits are set within a varbinary or integer? How would you pass a bitmap parameter to a system stored procedure? Phil Factor has answers.  Read more...
By Additional Articles 2014/12/03 | Source: SimpleTalk | Category: bitwise operations
Rating: (not yet rated)  Rate this |   Briefcase | 8,800 reads

The Value of Code

What's the value of code to your organization? Steve Jones thinks it's much larger than many people believe.  Read more...
By Steve Jones 2014/12/02 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 113 reads

Runbooks in SQL Azure

SQL Azure Runbooks promise to be your “SQL Server Agent in the cloud” enabling automation of time consuming, repetitive tasks.  Read more...
By Paul Hebhardt 2014/12/02 | Source: SQLServerCentral.com | Category: sql azure
Rating: |  Discuss |   Briefcase | 2,613 reads

The 2014 Tribal Awards - Nominations Open

Nominations open until December 10. The Tribal Awards are back and looking to recognize some of the great contributors to the SQL community. Nominations are now open for 11 different categories, but closing soon so make sure your user group, favorite twitter account, or person who's helped you the most this year is nominated.  Read more...
By Press Release 2014/12/09 (first published: 2014/12/02) | Source: SQLServerCentral.com | Category: awards
Rating: (not yet rated) |  Discuss |   Briefcase | 639 reads

SQL Server Survey

How do you use SQL Server, and how do you expect this to change next year? Fill in our survey, and enter a prize draw to win Amazon vouchers.  Read more...
By Press Release 2014/12/11 (first published: 2014/12/02) | Source: Red-Gate
Rating:  Rate this |   Briefcase | 17,047 reads
<< Newer    Items 41 to 60 of 13327    Older >>