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

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,289 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,028 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 | 132 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,394 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,242 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,701 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 | 82 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,427 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,531 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 | 111 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,598 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 | 625 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,242 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,622 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,593 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 | 65 reads

Dynamic PIVOT CLR

Learn how yo can use a SQL-CLR procedure to handle all your PIVOT queries.  Read more...
By Eric Wahner 2014/11/28 (first published: 2012/12/06) | Source: SQLServerCentral.com | Category: .net
Rating: |  Discuss |   Briefcase | 14,774 reads

Guidelines for Using Natively-Compiled Stored Procedures in SSIS Packages

As you may know, SQL Server In-Memory OLTP introduced in SQL Server 2014 offers great performance improvements for ETL processes. In this tip we cover techniques you need to know about various behaviors of SQL Server In-Memory OLTP depending on the options you select.  Read more...
By Additional Articles 2014/11/28 | Source: MSSQLTips.com | Category: in-memory oltp
Rating:  Rate this |   Briefcase | 7,087 reads

Personal Development

Steve Jones thinks that a personal development plan is important and talks today a little about how you should build one.  Read more...
By Steve Jones 2014/11/28 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 741 reads
<< Newer    Items 41 to 60 of 13320    Older >>