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

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,660 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,419 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,064 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,447 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,089 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 | 133 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,526 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 | 16,789 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,727 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 | 83 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,656 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,769 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 | 112 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,605 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 | 635 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 | 16,789 reads

sp_msforeachdb: Improving on an Undocumented Stored Procedure

Have you ever wanted to run a query across every database on a server with the convenience of a stored procedure? If so, Microsoft provided a stored procedure to do so. It’s unreliable, outdated, and somewhat obfuscated, though. Let’s improve on it!  Read more...
By Edward Pollack 2014/12/01 | Source: SQLServerCentral.com | Category: sp_msforeachdb
Rating: |  Discuss |   Briefcase | 8,667 reads

Your Best Work

Interviewing people is hard to do well. Steve Jones talks about a technique that might help you better choose good employees for your organization.  Read more...
By Steve Jones 2014/12/01 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 110 reads

Using Stored Procedures to Provide an Application’s Business-Logic Layer

When faced with a complex business application, Dwain's team chose to encapsulate and implement most of an application’s business logic in SQL Server, using an interface made up of stored procedures. Here's how they did it.  Read more...
By Additional Articles 2014/12/01 | Source: SimpleTalk | Category: business logic
Rating:  Rate this |   Briefcase | 7,754 reads

Facebooking Up to Your Social Responsibilities

Phil Factor argues that as terrorists and criminals exploit the new opportunities that open up as technology develops, technologists must work with Governments to ensure thoughtful custodianship of data, and sensitivity towards legitimate privacy.  Read more...
By Phil Factor 2014/12/01 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 67 reads
<< Newer    Items 41 to 60 of 13323    Older >>