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

SQL Injection, Still?

We still have problems with SQL Injection. Steve Jones has a few thoughts on why.  Read more...
By Steve Jones 2015/02/17 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 184 reads

What’s going on, on my server, right now?

Quick and easy way to monitor server activity and be notified from alerts.  Read more...
By Kimberly Killian 2015/02/16 (first published: 2013/07/23) | Source: SQLServerCentral.com | Category: sql monitoring
Rating: |  Discuss |   Briefcase | 17,883 reads

Managing Test Data as a Database CI Component - Part 1

Constructing a test environment for your databases can be a difficult task at the best of times. Once you’ve actually acquired the hardware needed and architected the environment, you still have to arrange and securely transport the data. And with the rising demand for fast feedback and continuously integrated processes, having all of this automated and operating at speed is a challenge all of its own.  Read more...
By Additional Articles 2015/02/16 | Source: SimpleTalk | Category: test data
Rating:  Rate this |   Briefcase | 6,046 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 | 13,596 reads

Salaries and Experience

Experience matters in setting your salary, but Steve Jones reminds us there are different types of experience, and there's more to life than money.  Read more...
By Steve Jones 2015/02/16 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 995 reads

Outpacing Change

The law seems to be failing to with the boons and pitfalls of technology.  Read more...
By Dave Convery 2015/02/16 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 50 reads

Closer to the Heart

This week Steve Jones wonders where you would work if you had the chance.  Read more...
By Steve Jones 2015/02/13 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 111 reads

Understanding Graphical Execution Plans - Part 1: Explaining the Plan

Understanding execution plans is a good basic skill for all DBA's and SQL developers. Darren White gives us an overview of what execution plans are in SQL Server and how they are used.  Read more...
By Darren White 2015/02/13 (first published: 2014/02/18) | Source: SQLServerCentral.com | Category: execution plan
Rating: |  Discuss |   Briefcase | 21,297 reads

Cascaded Parameters in SQL Server Reporting Services

You have a reporting requirement where a user has two or more parameters for a single report, but the values for one parameter depend on the values chosen in a previous parameter. Ghanesh Prasad explains how to create cascaded parameters in SQL Server Reporting Services to solve this issue.  Read more...
By Additional Articles 2015/02/13 | Source: MSSQLTips.com
Rating: (not yet rated)  Rate this |   Briefcase | 7,083 reads

SQL Saturday #371 - Tampa, FL

SQL Saturdau is coming to Tampa on February 28, 2015. This is a free training event for those wanting to learn about SQL Server. Register while space is available.  Read more...
By Additional Articles 2015/02/13 | Source: SQL Saturday | Category: events
Rating: (not yet rated)  Rate this |   Briefcase | 5,843 reads

Starting a New Job

Steve Jones talks about starting a new job and the need to get up to speed quickly, perhaps by being prepared on day 1.  Read more...
By Steve Jones 2015/02/12 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 174 reads

How to use the IsNothing Inspection Function in SSRS

SSRS includes multiple functions that can be used in within an expression. This article hopes to just show an example of how to use the IsNothing function in an SSRS report.  Read more...
By Shawn Melton 2015/02/12 | Source: SQLServerCentral.com | Category: report development
Rating: |  Discuss |   Briefcase | 4,321 reads

SQL Bits XIV, London, March 4 – 7, 2015

SQL Bits is Europe's largest SQL Server conference. They have experts teaching beginners, and beginners questioning experts, providing feedback and improving the event every year. Register with the code SSC-HERO to get a 15% discount on the ticket price!  Read more...
By Press Release 2015/02/12 | Source: SQLServerCentral.com | Category: events
Rating: (not yet rated) |  Discuss |   Briefcase | 346 reads

Bowled Over by SQL Window Functions

What better way to learn how to construct complex CHECK CONSTRAINTs, use the SQL 2012 window frame capability of the OVER clause and LEAD analytic function, as well as how to pivot rows into columns using a crosstab query? Create the SQL code to score Ten-pin Bowling, of course. Dwain Camps explains the how, what and why.  Read more...
By Additional Articles 2015/02/12 | Source: SimpleTalk | Category: functions
Rating:  Rate this |   Briefcase | 8,107 reads

Ship Safe...Ship Often

How can we ship safe, and ship often? Steve Jones has a few comments on the need for better engineering.  Read more...
By Steve Jones 2015/02/11 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 69 reads

Stairway to AlwaysOn Level 5: Analyse & Deploy a Failover Cluster Instance

In Level 5 of this stairway, we help you understand and deploy a Failover Cluster Instance (FCI).  Read more...
By Perry Whittle 2015/02/11 | Source: SQLServerCentral.com | Category: cluster
Rating: |  Discuss |   Briefcase | 1,974 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 2015/02/11 (first published: 2013/08/28) | Source: Red-Gate | Category: defensive programming
Rating: (not yet rated)  Rate this |   Briefcase | 51,405 reads

Using SQL Server's GROUP BY clause to Summarize your Data

SQL Server’s GROUP BY clause provides you a way to aggregate your SQL Server data and to group data on a single column, multiple columns, or even expressions. Greg Larsen discusses how to use the GROUP by clause to summarize your data.  Read more...
By Additional Articles 2015/02/11 | Source: Database Journal | Category: group by
Rating:  Rate this |   Briefcase | 9,529 reads

The Quickest Guide to Getting Started with PowerPivot

If you are still on the edge about PowerPivot and have not given it a shot, this article will get you started with ample of screen shots and a step-by-step guide.   Read more...
By Amir Charania 2015/02/10 | Source: SQLServerCentral.com | Category: powerpivot
Rating: |  Discuss |   Briefcase | 4,928 reads

Questions About T-SQL Control-of-Flow Language You Were Too Shy to Ask

Surely, we all know how T-SQL Control-of-flow language works? In fact it is surprisingly easy to get caught out. What, for example, do the BREAK, RETURN and CONTINUE keywords do in their various contexts? Robert Sheldon has the answers to this and other questions.  Read more...
By Additional Articles 2015/02/10 | Source: SimpleTalk | Category: t-sql
Rating:  Rate this |   Briefcase | 9,552 reads
<< Newer    Items 41 to 60 of 13522    Older >>